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, 10 months ago.

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

    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

    #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.

    #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, 10 months ago by  JoshuaJSlone.
    #44106

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

    #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.

    #44108

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

    #44109

    thisiskyle
    Member

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

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic.