Home › Forums › Tips, Hacks, & Ideas For Learning Japanese › Custom Excel Dictionary..?

This topic contains 6 replies, has 3 voices, and was last updated by  thisiskyle 10 years, 3 months ago.

Viewing 7 posts - 1 through 7 (of 7 total)
  • Author
    Posts
  • February 18, 2014 at 12:31 pm #44099

    Jonas Lundahl
    Member

    I’ve had this idea recently where I would take every word I gradually learn over time here on TextFugu and make lists of it in Excel. That way, I could easily just search for words using CTRL+F and get reminded of reading/meaning if I were not to remember the word in the moment I need it (like for example, when chatting with somebody in Japanese!).

    However, I can’t think of a good way to do this. I’ve went through a lot of words already three seasons in and I can’t think of an efficient way to do this. Maybe there’s a long list somewhere I can just copy+paste..? Ideas anybody?

    I did this for a few words (using my clumsy method above!) so you understand better what I mean:
    Example

    February 18, 2014 at 12:55 pm #44102

    thisiskyle
    Member

    If you have all your vocab in Anki (you should), go to File->Export, set the export format to “Notes in Plain Text”, eet Include to “All Decks”, un-check “Include Tags”, and hit Export. Save the file. Open the text file and go to File->Save As, leave the File name and Save as type as they are, but change the Encoding from UTF-8 to Unicode, hit save, then say yes when asked if you want to replace the existing file. Open a blank Excel spreadsheet. Drag the text file into Excel and drop it.

    February 18, 2014 at 1:04 pm #44103

    JoshuaJSlone
    Member

    It’s a little more than copy/pate, but in Anki if you go to File > Export you can choose to export as “Cards in Plain Text”. That gives output that looks like 

    <span style="font-family: Mincho; font-size: 50px">あたま</span>	<span style="font-size: 50px; ">あたま</span><br>Head<br><span style="">[sound:41-atama.mp3]</span>
<span style="font-family: Mincho; font-size: 50px">からだ</span>	<span style="font-size: 50px; ">からだ</span><br>Body<br><span style="">[sound:42-karada.mp3]</span>
<span style="font-family: Mincho; font-size: 50px">あさごはん</span>	<span style="font-size: 50px; ">あさごはん</span><br>Breakfast<br><span style="">[sound:43-asagohan.mp3]</span>

    With a bit of search/replace in a text program you could get rid of the tags and into a format that should be pretty easily pasteable into a spreadsheet.

    EDIT: Ahh, I see I’ve been beaten to this advice. I didn’t see the option to not include tags, but I haven’t kept the program updated.

    • This reply was modified 10 years, 3 months ago by  JoshuaJSlone.
    February 18, 2014 at 1:07 pm #44106

    Jonas Lundahl
    Member

    @thisiskyle Worked amazingly well! Perfect! Thanks a lot man! :D

    February 18, 2014 at 1:09 pm #44107

    thisiskyle
    Member

    Also, make sure you do “Notes in plain text” and not “cards in plain text” to avoid all the html style tags.

    February 18, 2014 at 1:27 pm #44108

    Jonas Lundahl
    Member

    I’m confused… what do I do?
    What do I do

    February 18, 2014 at 1:32 pm #44109

    thisiskyle
    Member

    Say no.
    Change the “save as type” to excel workbook.

  • Author
    Posts
Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic.

Bounty?