Tutorial: Creating an (Audio) Anki Deck from a Google Translate Phrasebook

Parts:
Exporting & making the data Anki Friendly:
• Tutorial: Creating an ...
Importing into Anki:
• Tutorial: Creating an ...
Using AwesomeTTS:
• Tutorial: Creating an ...
I hope this comes in handy for someone.

[@paulsharp5800]

This is the best thing I have ever seen.

[@hughmungus99]

that's a bold statement homeboy

[@nowaysir7576]

@@hughmungus99 did u find something better ?

[@hughmungus99]

@@nowaysir7576 yeah this - kzbin.info/www/bejne/moLaZapvjMyLmbM

[@ciao_abhi]

@@hughmungus99 LOL you got me

[@TonyStack]

@@ciao_abhi I had a feeling it was rick roll but I still got rolled :,(

[@Janedair]

This was one of the most useful tutorials ever! I am very grateful. Thank you very much for all your work.

[@marcattiallan]

Adding flashcards to Anki has never been so easy! Thank you so much for this tutorial! Awesome job!

[@michaellortz5977]

This is awesome, I was literally making every card individually, you just saved a lot of time, thank you.

[@LukaB-pb4sd]

I'm lucky to see this one today. I started Anki for just 3 days and spent tons of time for input. Really appreciated!

[@brycspain]

I realize this is quite old but what an awesome innovation. Thank you for showing us how to do this. Kudos to you sir!

[@kimstt]

I didn't know Anki could be so powerful. Thank you so much for making this tutorial! Really helpful!

[@ProfeSeb]

You just saved me an incalculable amount of time, thanks!

[@enzuber]

Outstanding video - clear, informative and inspiring. Thank you!!!

[@Snowmanver2]

wicked, mate! Nice one! The recommendations are invaluable

[@MrEnterainment]

Very good video. Thank you. This has saved me about 6 hours of work!

[@superAweber]

My goodness, this is amazing! Wow!

[@AmyJHarris]

Thank you so much for this video! Anki just got even easier to use!

[@jazzyeric21]

Exactly what I was looking for. Thanks this is great. Thanks for posting

[@leel9186]

Thanks for saving me hours. You’re a gentleman.

[@douglas.mentor]

Amazing Video sir. Straightforward and highly effective. Tks

[@Ahhh800]

Great work , extremely clear and informative.

[@russellbailey5567]

Thanks for making this video. I am trying to learn how to do just about all of the things you demonstrated in this video. I am going to see if you also did any other videos like this.

[@d.b.1668]

Thank you for this excellent tutorial.

[@hectorquinones5579]

Awesome video. Thanks for posting!

[@adevela]

Excelent,Fantastic!!! Thank you so much Guy!!!

[@Shka_maru]

Glad I stumbled on this! Super helpful especially now with AI (ChatGPT and natural AI voices). I am currently testing out making audio decks for Japanese using AI for text, images, and audio on cards (no translations. using images to help build connections). Thank you again for this!

[@abmarques9483]

Thank you so much for this tutorial. It helped a lot.

[@ALGMandarin]

This saves me time to find the mp3 and attach to the card, thanks.

[@Subhashreeify]

Thank you so much! This was immensely helpful!

[@echoyang8662]

Thanks for your tutorial. It is really helpful.

[@jacquieleggett1107]

Thank you very much-I very appreciated this tutorial.

[@dayph]

Thanks for showing me this stuff!

[@asynjaveronica]

Woooooooooooow.... you seved me loooots of time! Thank you so much!!!

[@_alexsm94_]

Thank you! I've searched this function for a year.

[@RoyalAventoe]

Thanks for this, very useful!

[@abdulghanimoalim6851]

Great video! Thank you so much

[@pratamaSVD]

Wow im native in indonesians.. its fascinating that some people from opposite world learning our language 😃

[@carolinagoncalves2045]

This is amazing, thank you very much!

[@mauriciorbp]

Excellent! you are the best, Thank you very much.

[@caroline7079]

Thank you this helped me so much!

[@DJ-st6qk]

Great, man!! Thank you very much!!

[@rodrigocristo3888]

Thanks for helping us!

[@luizguilhermedossantosguim5662]

Very good tutorial!!

[@jorgefrancescoferdinandmez10]

Really a good idea thanks :)

[@ecnalms851]

oh my god, you're a saint!

[@gaboceron100]

To make the add-on work I just had to close and open the app again. Thanks for the video.

[@2570611]

Thanks! It`s very helpful for me!

[@brunogrecco7928]

Awesome video, man. tks

[@angban401]

Fantastic 😊

[@fandianffxiv]

thanks for sharing mate!

[@emrebasar3129]

wow bro, You must have come down from heaven :D

[@kejzak1]

thx . You save my free time!

[@nhatkythicongtudong]

Thankyou very much! very helpul!

[@WhiteSiroi]

omg, thank you so much, awesome

[@KienNguyen-uv7wj]

thank you. so useful

[@aidmaks]

very usefull, thank you !

[@Jstashado82]

Your video helped so much. Lol I was stuck for a second on the simple things since i'm new to this thing so thought i'd help anyone slow as I was lol. Thanks again. @ 4:27 I didn't catch how the formula was copied and pasted. Copied from goggle search: Set up your formula in the top cell, position the mouse in the lower right-hand corner of the cell until you see the plus, and double-click. Note that this option can copy the formula down as far as Excel finds data to the left. If you have row headers or other data in place, Excel continues to copy the formula.

[@user-jw9qt6vo2o]

Genius!!!

[@awachi]

thank you so much dude

[@faisalmuhammad200]

you dont need the formula if all your starred words are from one language to another, for example all from english to german, just copy the two columns in the text file Also when saving your .txt file make sure that the encoding is selected to UTF-8. Thanks to the uploader for such a nice video and information

[@jobsjabbone4654]

Fucking hell. You are the king. You cant imagine how much easier you made my life.!

[@younesmerozen1889]

Splendid

[@kamrankaykhosravy699]

Wonderful!

[@leeyamanor4765]

Thank you!!

[@cmdplaytowin]

Good Stuff!

[@jareda1414]

Thank you, holy shit this is helpful!

[@decker434]

Thank you very much.

[@romeeettolsachschnellberg9681]

Thank you soooo much, you dear!

[@AdanSensei]

Super!

Awesome!

[@nguyenminhkien1588]

You're a fucking legend

[@wagnerbaldin8651]

Thank you so much!!!!!!

[@jwmacmillan]

Mind blown

[@quangnguyen-zj6xq]

Thank you

[@Rozmarynka19]

Nice, guy! :)

[@YUSUFREFAIY]

Thanks very much

[@karlangelo_c]

senk you for this

[@tahep3906]

wow, I didn't know the anki has that automatically importing audio feature, in the past I had spent much time doing that process manually, now the Anki is better choice for me than Memrise!

[@thelensky]

thanks dude

[@hryuhryu6204]

Bagus banget!

[@ethancena8108]

Thanks

[@caomeikk]

perfect!!!!!!!!!!!!!!!!!!!!!!!!

[@fikretcamlalp9819]

it is supper thanks

[@mrtvocich]

Why can't be all the guides as briliant as this one?

[@slicedtopieces]

Haha! 0:45 You aim to better than your friend in Indonesian. It reminds me of the movie, _The Other Guys._ “Did you learn Indonesian ironically?” Anyway, thanks a lot for the video. Very, very useful.

[@juacarlosdeleon5745]

cool

[@viacheslavkiselev3125]

legit genius from 7 years ago

[@AdamSchelenbergCom]

Thank you for the tut. I was wondering how I can do this.

[@Paroissien]

the mp3 folder is here : C:\Users\JohnSmith\AppData\Roaming\Anki2\addons\awesometts\.cache ..... don't batch create mp3 but let them be (automatically) created as you study one by one so that there is at least a second between each, then use FileRenamer to name them with incremented numbers, after having clicked on 'date of creation' sorting.

[@alirezaabbasimoshaei8726]

you are pefecccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccct

[@graj0]

This was very useful, but on my windows PC that little notebook isn't anywhere to be seen in June 2023. I eventually found that clicking on "saved" (between History and Contribute, at the bottom of the screen), the saved items appear on the right as in the video, then there's an icon which looks like a black flag with a white cross (between sort and three dots near top) to click so you can export to Google sheets.

[@user-wt2nv7vw6g]

Thank you very much. Could anybody say how to get dictionary entry automatically?

[@ELSEGUIDORQUESIGUE1997]

I have a problem ,how can I put the word at the back, and the audio in the front?, I have been trying it and I cant do it

[@MarioAlejandro3]

Very useful tutorial thank you very much for your contribution, I would like to ask you a big favor, if you can help me with two questions, 1. It happens to me that I can not make anki cards that have a word in English, Audio, Image, and Meaning in Spanish, all this through the "media import" and the "Import", I think I have done all the steps but I have left clutter, or I duplicate the images, or the audios do not match the card in question, or do not appear the audios and or the cards. 2. When I synchronize the PC with the mobil after having created a deck (when I make manual test decks making card by card), the images are lost and also the audios, and I want to know how to do so that this does not happen .

[@olstearn]

Hi mario, Sorry for the late reply. Actually I have never ever used the media import functionality when manually creating a card. I would have thought it would put it in your media collection folder but it sounds like this is not happening if they are missing when you sync. You could try just sticking all the media (audio and images) into the media collection folder and see what happens. Perhaps the file paths are pointing there but the media is just missing. This will then get uploaded when you sync and should be accessible from any device. If you have duplicate images, you can always have a look at the cards html and remove the duplicate very easily. While you are there, you could check that the audio corresponds to the correct card.

[@RawthoughtTV]

THIS IS SO HELPFUL. Thank you. One weird thing though is that mine is adding one at a time then sleeping for 30 seconds between each card, so I think I'll be waiting a while for the audio to be added. Was yours instant or was it just edited down?

[@olstearn]

Hi Loki, Google are trying to discourage use of their TTS service, which may be why you're finding it slow. AwesomeTTS use a disclaimer saying that they do not recommend it for mass generation any more. Still, you can adjust how long it sleeps for, and how often it sleeps if, in Anki, you go to tools->AwesomeTTS and then under the MP3 tab, you will find the 'download throttling during batch processing' settings. Tweaking those should probably get you 10 or so between each 30 second wait.

[@RawthoughtTV]

Thanks a lot for that info! I can also see people talking about this online. However, I don't have access to any settings like that. I'm on a Mac, perhaps that's why.

[@joseycurtis633]

Excellent video, thank you. Most complete and thorough I could find. I was able to create and import an extensive Chinese vocabulary list complete with tone marks. One problem I had was Google Translate was not an audio option. I've seen some comments that Google has made this feature unavailable to Anki. None of the other available translators provided even adequate translation. Any suggestions?

[@olstearn]

hi josey, Google has recently stopped supporting third party apps like awesometts. This was a pain as it was the only one that did bahasa Indonesia too. Im sure the developers are working on implementing another service if they haven't already but it may be worth notifying them. Please share your anki deck with me and ill see if my tool for bahasa (see my latest video) will work for Chinese too.

[@joseycurtis633]

Thanks again for putting the time and effort into this topic. Very much appreciated by many I am sure. I suggested imTranslator to Anki as a replacement for Google. My deck is on desktop Anki. I'll try to create a shared deck. In the mean time as I go through my cards I record the Google translation from my phone. Slow but accurate.

[@l26wang]

Translate works directly from sheets now - support.google.com/docs/answer/3093331?hl=en

[@orlandonelthorpe9027]

Can all this be done with the Android version, Ankidroid? I find it much easier studying with my mobile. Thanks for an interesting video

[@yassersato4977]

why is it that when i change the formula from b1 to a1 only English texts pop up and no the Japanese text I wrote in?

[@ljt7844]

Thanks for this. Really helpful for setting up Anki deck quickly. However, I can't seem to get the audio to work for Khmer. Tried it with google translate and one or two of the others but no joy. Any ideas?

[@olstearn]

Hi Leon, I dont know any services which do khmer Im afraid. If you find a service which does it, let me know and I may be able to integrate it into a script I wrote which automatically adds audio to your deck (I did this while google temporarily discontinued their tts service).

[@lp3553]

Thanks for the video, maybe I missed something but I followed your steps roughly and I keep getting cards with only 1 field (i.e. the 2 columns aren't front and back but 2 different cards with only a front). Can you help me troubleshoot this?

[@olstearn]

Hi Luke, Head to the 6:40 Ish mark and just check that the import settings look like mine did, I.e. fields separated by tabs, one set to go to the front, the other to the back etc. Assuming that's right, go to your .txt document and ctrl +f a single tab character (so they will hopefully all be highlighted). You might find that you've pasted an extra column by accident, or there is just a tab out of place somewhere confusing the heck out of the import process. If you still have trouble share the txt document with me and I'll have a gander and try importing it myself. Good luck!

[@fabioricardo8946]

Hi friend! Thank you so much for the video!!! Very interesting and clear!!! I noticed you have in your cards a note field in which you put some information about the lesson, for example "The Indonesian Way Lesson 46". Between the main text and this note field, there are some space or blank lines. How can I do to insert these spaces? I tried it from many ways but I wasn't be able to do it. Thanks in advance! Regards Fábio

[@olstearn]

+fabio net net Hi Fabio, from the edit cards screen, which you can get to through tools -> manage types, you should be able to add a couple of line breaks () between your two fields. Here is the html from that deck, I hope it helps: {{English}} The Indonesian Way  Lesson {{Lesson}}

[@fabioricardo8946]

+olstearn , it has worked perfectly! It has helped a lot!!! Thank you again!!!

[@wandareger2197]

Hello. I would like to make my own word cards. I have typed a list of 50 words, I would like to have a simple sentence for each one. Is there any trick how I can get 50 sentences in one click? I don't want to copy one by one. :) #flashcard #anki #quizlet #dictionary #vocabulary

[@jsmetamorph]

Really fantastic! Thanks so much. I cannot use this for mandarin though as it would not let me save Chinese characters as an ANSI .txt file. Is there a way around it?

[@olstearn]

Hi Spoonbender, have you tried going through the process? Its possible that even though you cannot see the characters in notepad, the encoding is correct and it will work. Try importing the text file, see what happens and let me know how you get on.

[@jsmetamorph]

Thank you for your reply. I did not realise there was a difference between wordpad and notepad++. With notepad++ it works like a charm. Thanks.