Quickly Create Audio for your Anki Cards

** Please note your Anki file locations may have changed, check the manual for the most updated location for your OS: apps.ankiweb.net/docs/manual.... **
This technique should work on Windows, Mac and Linux.
You will need to have a CSV file with the card data you want to upload before you can add audio fields. If you haven't done that yet, reference this video: • Create Anki Cards Quic...
Shortcut to create a tag: CTRL + B
If you hear no sound but you know you saved the audio in the right place, you have named your audio field wrong. Check formatting and capitalization.
Let me know if you have any questions!

[@guilhermexmath]

at 5:00 she has to press ok several times in order to export the audio. I found a way to avoid it, which may be helpful for you guys. go to edit > preferences > import/export and finally uncheck Show Metadata tags editor before export, now just click ok and you're good to go :)

[@riuk4500]

Thank you very much, sir. I just saved 128 clicks.

[@UrzDADDY]

Thank you very much. Saved me 607 clicks

[@HaNamJa-1]

Mmm a golden finishing touch to this tut

[@ChrisCrook]

Brilliant tutorial! Anki with audio is basically my Rosetta Stone for learning languages, this tutorial made it sooooo much easier to create flashcards from podcasts!

[@stoicfloor]

You're a genius! I've been playing with importing cards using CSV and I LOVE THIS METHOD! Thank you very very much and wish you all the best with your Japanese study!

[@2Cool4Games]

You're really cool! I didn't know that Anki could do all of this stuff! Thank you so much languagegirl. Have the best day, learning any language, any time, anywhere.

[@dimwitsadvocate6264]

Wow! This lady is smart and VERY helpful! This is the best Audacity tutorial I've seen for getting bits of language.

[@guycrosgrove9429]

Absolutely amazing video. You have maximized the integration of importing full Anki decks with audio using free Programs. I have used audacity for many things, but it never occurred to utilize in this way or excel for that matter. Most of all you seamlessly provided detailed process from A to Z. You include all the nuances of everything you are using for the process. You have a great way providing the detailed process, wonderfully, Thank you very much

[@KTP12275]

7 years later and I still go back to this video, incredible!

[@NukeMarine]

Thanks for this video. I am going to hiring iTalki tutors to read Tae Kim sentences and will definitely use this to quickly make the individual files.

[@gyogyuza]

Thank you thank you thank you so much for this and your tutorial on how to create cards using CSV. This had saved me so much time - I feel silly that I had been slowly making my cards one by one 😔😳 These tutorials are amazing!!!

[@ranjithmkumar]

Wow. This gem of a video is ahead of its time.

[@Lucas_Simoni]

I wish every tutorial was narrated by your sweet voice. 🙃😊 Make more videos!

[@nikikinz]

Great tutorial. I would like to share a discovery that i made whilst creating my sound files using the sound analyser in Audacity. It is not necessary to rename the tags as you delete the one's you don't want. Just delete the unwanted tags and leave the others as they are and export them just as you did. Audacity will automatically name the files, in order, as you want. I haven't tested with files with more than 99 saves, this could be a problem, but I think you'll find this tip well worth exploring. Once again, an excellent tutorial and I hope to see more of your videos.

[@gekotagirl]

Wow it's so cool that you're using the exact same programs and methods that I'm using. Interesting to see you using linux mint!

[@__donez__]

Wow, this was extremely helpful!

[@KienNguyen-uv7wj]

thank you, ideal cut, split sound with audacity

[@zhonghuawang6975]

It's so helpful. Thanks a lot!

[@melik5398]

SO helpful! Thanks very much!!

[@noahelhardt5589]

Great tutorial. Thanks!

[@paperjourni8964]

Wow that was helpful, thank you!!!

[@itmemo8617]

Great video, and under Linux 👍👍👍 Bravo!

[@stoicfloor]

THIS IS INGENIOUS! I've been using Anki for YEARS and I didn't know I can create cards this way... OMG! I could have saved myself A WHOLE LOT OF TIME if I knew this earlier! But I am very happy I have found this video which makes learning Korean easier:) BTW, I have a tip for you. Don't do English - Japanese translation. Using images to represent the Japanese vocabulary is a lot better. This helps with memory and avoid always having to think in English then to Japanese. Cheers and thank you very much:)

[@languagegirl1124]

Thanks so much Dragon! I converted to J-J cards probably about 8 or 10 months ago and it has dramatically improved my language skills. It helped that I got out of textbooks too. Glad we're in the same boat here, maybe I'll make a video about how I easily make J-J cards too :)

[@RobertGenito]

You know what's awesome about Audacity now? You do not have to re-serialize the label numbers after you delete other labels. Basically, Audacity will automatically put the label numbers in order for you during export :D

[@alanoliveira5744]

WOW! You saved me! ありがとうございます！

[@ShannonDaily]

Thank you for posting this. By the way, you are my vocal doppelganger! You sound just like me. :O

[@dekad5200]

awesome, liked and subscribed

[@oliverlovelltas]

Omg you're the best!

[@mohammadhosseinhadwyn7188]

hey thank u very welll , it was very useful , I was looking for such a this tutorial... God bless u

[@marothro]

very helpful thank you

[@user-jy9gm4ih6s]

THANK YOU

[@robertholland3966]

Thank you for the awesome tutorial! On a Mac (and Linux), if you want to generate a quick list of sound files or any other filename just open the terminal and type: ls -al *.mp3|awk '{print"[sound:"$9"]"}' > List_of_Files.txt That will make a new file called List_of_Files.txt that has the files listed in the sound format and you can just paste into your spreadsheet sound column. It works great if you have several hundred files that do not have the same naming convention. You can also change the .mp3 part to whatever file extension you want (.ogg, .wav, etc).

[@languagegirl1124]

You're awesome! I'm always looking for ways to make my life easier and using terminal commands is a great way to do that. I will have to try this on my next set of audio files (which I might make soon - got some N2 material I want to drill in!)

[@YSEVERYNAMETAKENGOD]

@Larry David should be able to just change the .mp3 to jpg or png or whatever format the images are saved in

[@anton.encours]

You should not really parse ls output (potentially dangerous). Instead, just use printf command.

[@user-nt1uq2ds3j]

Thanks for the help! Turns out my only issue was not adding {{Audio}} to back template lol.

[@victorlundberg7355]

the fomula seems to have changed the "," to a ";" in the text function, just so y'all know, it didn't work for me with a "," using libreoffice, I also found it easier to slice the audio using wavepad instead of audacity

[@mikecccc987]

She uses LibreOffice Calc and Audacity very effectively. This shit bussin.

[@trunghoang7605]

OMG it's very useful

[@faboxbkn]

muchas gracias!

[@quangnguyen-zj6xq]

thank you so much

[@sergeyvarner2951]

Great ! Thanks )

[@xuanthanhmai706]

awesome, thank

[@Justusperthes]

This is great! I came here to learn how to get audio from a spreadsheet into Anki, but accidentally learnt that I could make Audacity split my audio automatically, too. I've been doing it manually up until now :|

[@languagegirl1124]

The funny thing is, I was dabbling in doing this again and had to watch my own video... glad it helped :)

[@LukeAvedon]

Very impressive. Do you know how to add images, on mass, to anki cards via csv? is it a similar notation to the sound files? thank you again!

[@cleofaspintolimalima1627]

I like this channel, by the way app anki too ,so I from Brazil

[@DreamyAbaddon]

Hmmm, I've been using ElementaryOS for years, I might give LinuxMint a shot after watching this tutorial. I like to try a new distro.

[@amxhd1]

Can you please tell how you make the sound number auto number and auto fill. I want to do that with images.Thank you.

[@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 .

[@MohamedAhmed-of4ie]

"sound finder" has been replaced by "label sounds" in newer audacity versions. any idea how to set it up to get the same results as shown here!

[@Peru-fc3bi]

Amazing tutorial very helpful! It will save me so much time. I like to take an audio sentence have it play at normal speed on a loop then -40 tempo in audacity a few times, then -30 a few times and so on (so that I can shadow the audio at reduced speed) and improve pronunciation as part of an anki card. Is there any way to create such a file efficiently in Audacity? At the moment I'm manually copying and pasting each different speed section in Audacity. It would be amazing if Audacity could do this for me...

[@jaymata1218]

holy fuck this broke my brain

[@suegreenwood5609]

Thank you for your clear instructions. Is there a reason why you did not save the sound files directly into the ANKI collection.media folder.

[@dupirechristophe7703]

How do you do if you want to input an audio file for both language? :)

[@Daniel_Cooley]

Could you link your anki deck? I'm trying to learn Japanese but the 3 decks I've downloaded either are way too advanced like full sentences and even paragraphs or they dont have audio files.

[@pasibrzuch212]

what settings would you use for sentence flashcards?

[@quangnguyen-zj6xq]

great

[@carmeljj]

Thank you languagegirl. This is absolutely fantastic! I have one technical problem though. In Audacity, when I delete a label, the next tab takes me back to the beginning instead of the next label. I'm guessing this might me in preferences or somewhere, but I can't find how to make it go to the next label. Can any one help me please?

[@languagegirl1124]

Honestly I don't know, that's pretty weird. What OS do you use?

[@mohammadhosseinhadwyn7188]

Hello first I thank u for your tutorial but I had a question : imagine that I have 200 sentences(not word ) , 200 pics (related to sentences) and 200 audio (of sentences). half of them is front side (100), half of them is back side .(other 100) how can I import them quickly to anki ? it think it is similar to your tutrial but I don't know how to do it ? thank u . waiting for your your answer , dear . bye .

[@anguszh]

Is it possible to rename all the fragment in numerical order automatically?

[@PhamQuang]

hi Languagegirl, are there any ways to quickly import audio files into cards that are already made in Anki? You're so smart

[@languagegirl1124]

Nothing like replying 3 months later! You can export any deck you have as a "Notes in Plain Text (.txt)". Open the file in Excel/Libreoffice, and make sure that it opens correctly. If you're having issues, open the file in text editor and copy/paste into Excel, and once you've pasted it use the excel function "Text to Columns" on the "Data" ribbon (google fo rmore info!). Once you've done that, then you should have a file that looks really close to what I have in my youtube video. Add the audio column, follow the steps above, and then when you import it back into Anki, make sure to click the option called "Update Existing Notes when first field matches". This will then only add that new audio column, assuming you didn't change anything else. Hope that helps! I've definitely done this before with some other types of cards and it usually works just fine.

[@koreanenglish2932]

My audio files name are saved as the sentences themselves can you help ?

[@carmeljj]

Another problem. I'm using open office. I wonder if that is my mistake, not excel. I put in this formula ="[sound:171007-"&TEXT(J2,"00")&".mp3]" and I get Err:508. When I looked this up it refers to brackets etc that don't match up. Any suggestions will be greatly appreciated.

[@carmeljj]

I solved this one by getting LibraOffice.

[@caffeinefreemtndew]

for images, the parentheses are only needed if there is a space in your file name

[@caffeinefreemtndew]

found this out because I discovered the parentheses weren't needed... until some of my cards wouldn't work, and I was able to view the source code for the image in my card, and it turned out anki was automatically putting parentheses for me, but it was also putting them in any spaces that occurred in the file name, which screwed it up.

[@dr.hishmnasr]

what is the app that you are using (audio editor)?

[@jameseamonncollins1131]

Is there any way this wouldn't work on a Chromebook?

[@conspromos]

Hello! Awesome tutorial, thanks a lot! I have followed te steps and check it all several times, but my audio files don't play. For them to play I have to insert them one by one manually inside Anki, by clicking on "Edit" when studying each card. I think I might be missing something, but can't find the issue. Can you help? Thanks a lot!

[@lan9409]

I have the same problem unable to find Anki media directory. I can't find it in the suggested Anki's default: /Users/MAC/Application Support/Anki/User 1/collection.media I tried Spotlight "Anki" but no media directory

[@languagegirl1124]

You are either not putting your audio in the right file location, or the name for the audio file is wrong. Please make sure you put the audio files in the most recent location, as documented here apps.ankiweb.net/docs/manual.html#files Always check capitalization, spaces, etc with the naming of your audio file in your spreadsheet.

[@xladysynari]

@@lan9409 I know this is 3 years later, but for anyone else having this issue.. While in C:\, click View tab and make sure Hidden Items is checked. The Collection.Media folder should be under C:\Users\(username)\AppData\Roaming\Anki2\User 1\collection.media.

[@user-wn1ti6cr5s]

Maybe someone have script or any idea how to execute tts app on every column and write name of file to second column?

[@bardooh6808]

Hello. Im using Anki and added Audio recently to my Deck. When i explore a Card, i have the xxxx.mp3 at the Audio field but if i see the Card i don´t have the {{Audio}} there and of course i have no sound. I have cheked Audio ON automatically and when i see the answer but still no luck. I manually added {{Audio}} into a card and it works! But i have 2000+ cards... i can´t add 1 by 1... Any idea? Sorry about my english :)

[@languagegirl1124]

You need to add {{Audio}} to the card template. Take a card with the template you use in the browser and hit "Cards...". You should have an editor pop up with a front and back card, as well as the formatting behind it. Add {{Audio}} to either the front or the back of the card, and then it will be effective for all of those notes that use this card template. Read more about editing cards here: ankisrs.net/docs/manual.html#cards-and-templates

[@bardooh6808]

Oh Thanks!!! It works but i have a new problem now. Im studing Arabic and im spanish. When i see Arabic side i ear sound, thats nice. But now when i see spanish side i ear sound too in arabic before uncover the flashcard. In the field of Reverse i dont have {{Audio}}

[@baotranhung5752]

Hi. Please tell me how to convert excel to audio mp3 file quickly. Thank you so much.

[@gsdvanvv6273]

Can not convert from Excel file (sheet) to audio mp3

[@lucaspinheirodesouza]

When I write the function and press enter appear Erro:501. Please, help me. What does that means?

[@stoicfloor]

Can you show us the formula you've entered and names for you sound files?

[@lucaspinheirodesouza]

I used this ="[sound:ch15-"&TEXTO(D1;"00")&".mp3]" formula and it worked. I think it's because I use the calc in portuguese language and I have to type "texto"(portuguese) instead of "text"(english) and I used ; instead of , in the (D1;"00"). What you think?

[@philly_Will]

I also received error:501. Formula I entered: =”[sound:pronunciation_es_algo.mp3]”

[@davidagiraldo]

Amazing. You. are. amazing. How easy is it to add images to the cvs file? Do you have a video on this?

[@stoianmirela1792]

Daveed Alonso Can you please help me with this? I tried two hours today with no results. I am so frustrated because I think this is so helpful, but I don't know what am I doing wrong. It's very unclear for me how this function reach the MP3 files from the folder I created. Please, if you see this and have some time maybe you can explain to me step by step.

[@languagegirl1124]

It looks like the file locations updated, please look at this article on the Anki help doc: apps.ankiweb.net/docs/manual.html#files Look for your collection.media folder (or something similarly named!)

[@languagegirl1124]

I do not - if I find a good way I will definitely make a video and post it!

[@d42]

4:45 whats wrong with .wav files?

[@carlosponcedeleon7044]

Perdon pero la fórmula siguiente : ="[sound:ch1-"&texto(&textI2,"00")&".mp3] no me funciona, que pongo mal? gracias.

[@maxeamaya]

por alguna razon la formula no funciona si se copia y pega, segundo después de la casilla de formato, (text , tenes que poner punto y coma en lugar de solo coma. espero resuelvas

[@carlosponcedeleon7044]

@@maxeamaya Max muchas gracias por la repuesta !!!

[@Rebecca-bz6ph]

Does this still work in 2020?

[@nowaysir7576]

hi ! i have a problem . when i write in russian libreoffice keep changing it to this : ????? ??? ?? ?? . any ideas ? thanks .

[@languagegirl1124]

Try using Google Docs instead and save and download as a CSV

[@nowaysir7576]

@@languagegirl1124 worked thanks !

[@lukaskreft8673]

Linux Mint! Yay!

[@mr2011vincent1]

It looks like the tutorial are applicable for Linux. Is it the same for windows?

[@languagegirl1124]

Audacity works he same in Windows!

[@mostafasafary1128]

Tanks for this video! Anki has a option to import zip files. Do you know how the format should be for that? Specially for audio files.

[@danbrownlie]

I found that the name of the labels actually doesn't seem to matter,

[@caffeinefreemtndew]

I'm going nuts, everything is right, the file name, the mp3s are good, they're in the folder with all my other media... but the audio doesn't work. The card doesn't show any text, doesn't play audio. If I drag the file in, it works, and looks exactly the same...

[@caffeinefreemtndew]

there was an identical media folder on my hardrive that wasn't actually connected with anki. Had to use the address/link in the manual to get to my media folder because only the duplicate one came up on search.

[@blackmartini7684]

This is such a time saver. You are amazing 😍 are you single?

[@brayan6925]

linux_mint.mp4

[@agnel14]

Can we use this method for images as well? I wanted to add images and sounds together. I tried using but it didn't work. I tried using Media Import as shown in this video: kzbin.info/www/bejne/rYatk2OXltaKZ7M Then exporting the file into text. After which editing the fields and importing it back in with the "Update existing notes if first fields matches" But new cards are created instead of the older cards being updated. Is there a way? Your a Genius by the way! You saved me a ton of time.

[@cauxxx2454]

You are on linux ! Do you believe in love at the first glance ?

[@SunnyPickles92]

hahahaha. Doing the same thing

[@LoscoeLad]

so quiet.. don't be shy!

[@jalimani-_-]

the QUICK formula : ="["&(,"")&"]" you need to type "text" yourself otherwise the formula doesn't work enjooooooooooooooooooooooooooooooooooooy

[@jalimani-_-]

="[sound:"&(,"")&"]"

[@peggyedgar9777]

I 'm sorry but you more or less missed out how to start and simply assumed it as knowledge

[@baxtube270761]

The argument is very interesting so I appreciate your effort but understand you for not american people is very hard. May be your speech more linear, with less inflection?

[@clacclackerson3678]

This is very true. Languagegirl, your videos are great but your vocal delivery is very uneven volume and tempo-wise. It make it quite hard to follow what you're saying, and I'm a native English speaker! Thanks!

[@dandana4647]

Nemonemini f

[@jamesmurraylegal]

Rubbish explanation - you needed to anticipate that the person viewing knows nothing and has nothing. you are not talking to your target audience and so it must be Idiot-Proof You ASSUME we know what is Audacity ! You ASSUME we know what is Excel ! Suggest you plan your explanation so it begins at the beginning and ends at the end.