Create Anki Cards Quickly using CSV

Note that this will work on Windows, Mac and Linux, just be sure to use a spreadsheet program that can create CSV files.
To create a card template, please reference this part of the anki manual: ankisrs.net/docs/manual.html#c...
If you want to add audio, please reference my other video on uploading Anki cards with here: • Quickly Create Audio f...

[@stoicfloor]

I feel so stupid creating cards one by one. This is SOOO CLEVER AND SO MUCH BETTER. Thank you very much. BTW, you've a very lovely mechanical keyboard haha

[@languagegirl1124]

The keyboard is loud and proud. Just moved it to my work a month or two ago and now it annoys my coworkers :)

[@andresvalera1430]

I literally downloaded a deck with almost all the vocabulary and one with all the kanji and then moved the cards one by one to the deck i wanted lol, this will be so much more easier

[@talesontables]

me too hahhaa

[@orugbanieli1893]

I must say that your voice and speech patterns are like music, very soothing to the soul. One tutorial I will always return to watch.

[@-mcenkner4345]

Nooo! I was waiting for you to show what the finished product looks like, esp. how the different column headings display... but you ended it! Darn!!!

[@-haruto1601]

You've literally saved my life... I've been trying to import a csv file for days and it finally worked (honesty I'm not even sure what the problem was in the first place, but it doesn't matter anymore) thanks thanks thanks thanks thanks :D

[@TheCubecrafer]

im still coming back again and again because this video is so good

[@MorrelEvet]

This is a great tutorial - love you delivery so calm

[@bluepresley9315]

Thanks for the great video. Can you do a quick video on how you were able to create the different fields for your deck? Or perhaps a link / resource to follow on how you did it? Thanks! Please keep them coming!

[@theochry6984]

The simplest video out there! Thanks!

[@paulus_germanus]

the best tutorial out there! your a legend, girl! Thank you ever so much!!!

[@languagegirl1124]

Thanks so much, glad it worked so well for you :)

[@dranneshirley]

I am lucky I stumbled here, this is going to be really useful and save my time. Thank you!!

[@user-uc9gi2xf8r]

I found myself with the need to create over 30k cards. No way I'd do it one by one. Thank you!

[@akuma-chandesu7443]

Freak, Woman, you are BLESSED. I am new to anki, Entirely. I came here from your AMAZING "Quickly Create Audio for your Anki Cards" video which is a LIFE saver on its own... but you.... YOU. This woman right here, everyone, LINKS UNDERNEATH EACH VIDEO, THE BASICS YOU SHOULD HAVE/NEED TO KNOWN COMING IN. I'm able to follow the trail back words from the video I WANTED to work with, without having to spend 500 Years searching for it. I can tell your time here with the flashcards creation, has really given you a view on the WORLD about how easy things could be in life for everyone. you make me so happy I could cry. Thank you you blessed woman.

[@dupirechristophe7703]

Well, you're gonna love it, this glorious piece of software is polyvalent and customizable like you wouldn't believe :) So many useful add-ons are in existence, Anki exists as smartphone apps that syncs with ankiweb and anki on your computer... and the text on the cards works with HTML, so it's basically programmable so to speak.

[@SantiYounger]

Excellent video, thank you, do you perhaps know if is there any way to have a 2 way sync between anki and google sheets? Thanks

[@infamismworldwild6248]

Thank you languagegirl this was a major time saver

[@okanbilgin]

Hey, Just wanted to thank you for the tutorial!

[@aliascomputer6420]

Amazing really cut short my work For those facing problem with Excel Use Google Spreadsheet and download in .csv format

[@trevorgustavgreen8148]

Unrelated to the video but, this in the first time I seen someone use Mint for their OS.

[@languagegirl1124]

Haha, a friend recommended it a while back and I've used Linux ever since. I now also have Ubuntu installed because I couldn't get VPN Gate working on my Mint OS :( but works fine on Ubuntu. Highly recommend VPN Gate if you want to watch Japanese netflix, it's the only service that works and it's actually free.

[@yasu_6th]

This video indirectly started me going into Linux. My computer recently crashed and I managed to save it using a USB drive with Linux mint on it!

[@shchadenko]

Wow, it's so cool and productive! I like it! Thank you!

[@shirpychirpy6962]

It's absolutely amazing. Really, thank you!

[@pandagro-svt6749]

Hi ! I'm looking to a way to export from excel or sheet to anki format akpg or other but with IMAGE.. Do you think it's possible ? Bests

[@DakotaAbroad]

Thanks for this! Is it possible to update and add to your flash card sets this way as well?

[@ukyamyam]

日本人です。暗記の使い方とっても分かり易かったです、ありがとうございます！

[@RodrigoSilva-uf8df]

Thank you. This video revolutionized my life

[@violinfire24]

Thank you every so much!! I was going to just use Quizlet, but love the customization of Anki. Without the hassle of entering in each card, I will surely be using Anki for my language studies. Thanks again!

[@languagegirl1124]

You're very welcome!

[@k.5425]

I've never used Quizlet before. What are the differences between quizlet and anki?

[@nydameth826]

@@k.5425 I've used both of them and I must say that Anki is much better. First and foremost, Quizlet does not shuffle/postpone your cards, meaning you have to remember which ones you want to revise and which not. Both of the programs work similarily in a way - you create flash cards, which then you can study. But yeah, I recommend using Anki especially if it is long-term studying :)

[@rachel29002]

Thanks, this was SO helpful. I've been trying to work our how to import language flashcards with a Hint field and this helped me no end.

[@tubatubeomy]

Thanks for this. I have 1200 words and it would take a lot of time to make it one by one.

[@LukeAvedon]

Wonderful. Thank you.

[@eyeojo]

Thank you very much for this! 🎉

[@user-zy1qx4iz1i]

So afther importing my .cvs document to anki,can i add other fields to my cards, like sound and images? or do i need* to do something else. I have many types of cards, how are they different from the one your choosed in your video? sorry for my english . Great video

[@languagegirl1124]

Yeah, as long as the card/note type has those fields. You can always add them later, or watch my other video on how to import them in mass.

[@jeffreyedwards5807]

Thank you for your video. It was quite helpful. I have been trying to reverse the process that you describe in order to export my Anki Japanese vocabulary deck into an Excel (CSV) file. Would you be able to offer any advice?

[@azimchoudhury502]

Would u recommend using anki for GCSE? Btw good video!!

[@cezarioabrantes5476]

Thank you very much for sharing this!!!!

[@swedishguyonyoutube4684]

Great video!

[@pablotorres6997]

Fantastic, thank you!

[@CabCandelarioLC]

Thanks dear friend!! I now understand how to do it!!!

[@nowaysir7576]

Based on your experience with Anki can u tell me please the best type of cards for language learning ? Basic / ....

[@edvaldocapingote1251]

Amazing. Thanks. Greetings from Brazil

[@xcollin8179]

PLEASE , I need to help! How do you do to have in a deck in first the new card (blue) and in second the due card (green or red) ? Because each time I click on the deck, I have in first the due card and after the new (3 days ago I always had the new in first) God bless you if you understand the problem. (sorry for my English, I am a French)

[@tigoc6592]

It's useful very much, thanks

[@kaoriexpress9995]

It seems like a lot of people who don't speak Japanese pronounce "Anki" as rhyming with "Yankee," but since you are using it for Japanese you might be interested to know that Anki is 暗記（あんき）, Japanese for memorization or learning by heart and the "a" is pronounced as "ahhh."　Setting that aside, though, this is a very helpful tutorial; thanks for making it!

[@languagegirl1124]

KaoriExpress999 I mean, we don't say things like tempura, sushi, fiancée, etc in native-to-original-language pronuncuation either. And nither do other countries. Think how Japan says things like tshirt, pants, earphones, high five, etc.

[@youngwood5704]

yeah it was really bothering me haha. On key is how it is pronounced.

[@calimon00]

@kaoriexpress999, thanks for this.

[@user-ik8xc3qw4p]

How is it possible for people to be so helpful?

[@josephautrey954]

I typically upload upwards of 100 cards at a time which can be time-consuming. I separate and organize them into smaller decks manually. For example, 100 cards into 10 separate decks with 10 cards in each deck. Is there a way I can import an excel spreadsheet into individual separate decks with a single import? Maybe uploading each card with the individual deck name such as: 1 Business Writting::01. Cover Letter & Resume::01. Cover Letter: 1st Impression 1 Business Writting::01. Cover Letter & Resume::02. Cover Letter: AIDA: Attention 1 Business Writting::01. Cover Letter & Resume::03. Cover Letter: AIDA: Interest . . .

[@pmisaacmorales2185]

Thanks a lot, very useful

[@williammievre2133]

Awesome !! Thank you

[@basho66]

Thank you for this - it will be super useful. However, I don't see the note type 'Japanese Basic (and reverse card)' in my list of Note Types. I may be missing something obvious but do I have to create this note type first? or can I import it?

[@k.5425]

Yh, you have to create it.

[@googlezzang5682]

Thank you so much!

[@anhnguyenhuy135]

Thank you so much It's useful

[@jessecruz6241]

Hello.I created the fields like "front, back & tags" but the tags don't appear when I want to study filtered decks. Help please.

[@alyssabarretto3059]

i ihave the same problem

[@alyssabarretto3059]

i figured it out. change the "fields separated by" to comma.

[@ricrui3]

Nice video :D

[@rangi500]

Thank you!

[@Wesmosis]

Thanks!

[@Project818Russia]

thank you soooo muuuuch! ;)

[@keithstarkey5584]

Nice. Thanks very much.

[@haseebpavaratty6249]

Thank You so much :)

[@zeynepipek2902]

THANK YOU. I have been looking for something like this for a long time. Just another question: If I e. g. wanted to use this method for uploading cloze deletion cards, would that also work? And could I create a new spreadsheet for each import or would it have to be a new excel workbook?

[@languagegirl1124]

I can't see why you couldn't upload cloze cards like that, if you used the right annotation and card type. Just starting to have fun with cloze cards myself! You should be able to create a new spredsheet, and then when you export just follow the prompts that tell you that you can only do it with the active worksheet.

[@zeynepipek2902]

@@languagegirl1124 Thanks a lot for your reply ❤️

[@strikerguimaraes]

It'll be cool if there was a was to send your translation from a translator to Anki... I tried using the templetes but no dice so far lol

[@hamcam97]

Oh man I love you so much

[@FirmanSyah-fj1no]

Thanks you, but how to fill sound field automaticly?

[@auntiecarol]

I remember watching this about four or five years ago (not too many Linux using youtubers with female sounding voices out there), and I thought "Nah, part of the learning process is in taking the time to make cards individually". Now I'm looking at a bunch of data I half-know and bulk importing makes more sense. So have two thanks: one from olde timey me, and one from now me!

[@edmel144]

Nice vid.

[@JCServant1]

How do you insert a code for the character? I want the characters to be a certain font size but I only know how to do it one by one with this code 受益

[@keithstarkey5584]

Thanks much!

[@ASmith-hb4ed]

awesome!!

[@Nada83292]

Thanks a lot

[@alanouds.alzahrani3882]

hi thanks for this helpful video! but how do i get the languages option? I wanna do flashcards for Spanish. Thanks

[@languagegirl1124]

Not sure what you mean. This technique will work just fine with Spanish too :) no need to change anything

[@kevineherwindo1134]

It still takes a long time because you still need to type each word one by one in the spreadsheet

[@aceroyplatadeluna]

or you could copy/paste into your spreadsheet from an existing list (online, etc)

[@Ronin1134]

... and on Linux too. I love it.

[@chaoqiangxi2393]

thanks very much

[@mr2011vincent1]

4:56 why can’t I create multi field mapping and you can do?

[@dmanakell]

Anki newbie here. How do they look like after importing into Anki?

[@cesardantas1713]

I didn't get to import both cards and audio using LibreOffice Calc. I got only import the text. Please, can you help me? Thanks

[@languagegirl1124]

Cesar, check out the other video I have on this channel to figure out how to import audio. You have to have the audio files in the media folder (I might have the wrong name) and then import the flashcard text into Anki.

[@joey6280]

I'm wandering if i can do that when studying foreign literatures

[@sabrinastyblova]

thank you for this video. does anyone know how to save the csv file in excel correctly?

[@ma_niz]

oh my god thank you so much

[@dupirechristophe7703]

Is there any way, or add-on to do the opposite though? Namely; exporting an Anki deck from Anki into text csv format. Because I create my cards with my computer, but I rehearse them with my smartphone in which I tweak them, add hints, correct typos (etc) on the go... and therefore my (backup) source text CSV file on my computer isn't up to date.

[@languagegirl1124]

File > Export Export Format: Notes in plain *.txt Exports the cards as a tab-delineated file. Anything that can read a comma-delineated file (which is the type of file I make in my video) should be able to read tab-delineated files too.

[@dupirechristophe7703]

@@languagegirl1124Oh but of course, it's delimited by commas OO It opens loads of possibilities... Thanks a tonne for responding so fast, you're a Menschess :) BTW, I found this way of creating cards simply the best, you can have your back ups on a external hdd in a simple to use format (nothing anki fancy that only anki can read), you can update it easily, you can create a reversed deck by simply switching the two first column and not having a messy normal+reversed deck or having to retype the whole freaking deck in reverse.

[@Mel-qr5ob]

do you know what language setting we use if we've got Maori characters? (ā ē ī ō ū)

[@rainmon1]

I imported a CSV spreadsheet, and ANKI listed the number of files imported, but when i try to study it, it says Congratulations and that I've completed the study for today. I clicked Tools/ Check Database from the top menu and got the following message: "Found 297 new cards with a due number >= 1,000,000 - consider repositioning them in the Browse screen. Database rebuilt and optimized." So is it somehow set to review the cards every 1 million days? As far as "repositioning them in the Browse screen", I don't know how to do that. Any suggestions?

[@I3tienneI]

where do I get these note types from? p.s. my programming skills = 0 :(

[@cindypendulot863]

Can i create Deck and sub-decks similar to what you did for Anki Cards ?

[@labassador6678]

Please see here: kzbin.info/www/bejne/iF67n5lve6aMapI

[@sikkun4552]

Can easily just use a text editor, put commas between each item and save it as a .csv. The CSV just mean its comma separated...excel just happens to be able to read them. By using Tabs, you technically made a .tsv file (tab separated)...but the OS doesn't care you can give it whatever extension you want.

[@languagegirl1124]

Yep- I actually use that method now (except with tabs) when I want to upload full sentences into Anki. Downside is it is prone to errors (you may miss a field and have Anki just boot out the whole line), and you can't do any automated processing on the fields, or quick populate any cells (e.g. tags). Both have their upsides and downsides for sure!

[@honefone]

ありがとうございますうう! !

[@karifurai8479]

すげー！これが日本語ですね！

[@miriamaltman1317]

This is really helpful. But I still can't seem to import even though I went through all these steps. I used both commas and tabs

[@languagegirl1124]

What's the error that you're getting?

[@heathertoomey7068]

Thank you! I couldn't figure out how to get it working when I tried from reading other sources. Didn;t know I had to delete the row where I put field names. Also, I like your voice. It reminds me of me!! XD

[@geniusssmit2305]

I don't get it. 0 notes added, 0 notes updated, 0 notes unchanged. One or more notes were not imported, because they didn't generate any cards. This can happen when you have empty fields or when you have not mapped the content in the text file to the correct fields. Error. Can you help me?

[@languagegirl1124]

Your file is blank for some reason. You need to open it up after saving it and check...

[@rexsales2246]

is there any way to print your flashcards directly from your anki?

[@languagegirl1124]

Try these two extensions. I haven't used either so I can't help if they're not working: ankiweb.net/shared/info/1025789669 ankiweb.net/shared/info/556159936

[@rickytan3432]

i cannot find the .txt file after click import ?

[@andreasgrunder7003]

Hi language girl I like your idea of using a spreadsheet as input. I will pursue this idea and use a spreadsheet as master template. What fascinated me as well: how could you switch the keyboard from english to japanese so quickly? If the keypad is drawn like on a mobile then I can understand it. But what if you have a hardwired keyboard? How do you know which key stands for what?

[@k.5425]

Yh, I wonder about that too

[@michellesmirnova4471]

I personally have a “normal” romanji keyboard and whenever you type it with Roman letters you get the hiragana that shows up, or you can type in katakana, and usually the kanji option shows up underneath so you can click it If you have Roman letters it’s pretty easy to type in hiragana I’m assuming this person also has that

[@sukheshpd]

any way to batch import images?

[@jlmarevalo]

Hi I tried this but I am getting an error from Anki that it's not a UTF-8 format? I don't have that option in my excel. I have UTF-16. Can you please advise? Thanks!

[@languagegirl1124]

Sorry for the late response. In that case, you can copy-paste the whole excel document, then paste into notepad. Then save as a UTF-8 .txt file and import that.

[@motionon]

Could you do this video but shorter? Perhaps just 3 cards and then play them on Anki? I wanna do cards to learn German. Pronunciation, image, spelling and example sentence. How would you go about it? Thank you!

[@languagegirl1124]

If I have time, Carlos, I will definitely consider it! Busy studying for a Japanese exam for the rest of the year :)

[@alyssabarretto3059]

Hi ! just wanted to say thank you for posting this video. I just tried importing the file as .csv, but Anki is only showing 1 field :( can you please help me? I don't know what to do now

[@nguyenduong1978]

Choose "Fields separated by: Comma" not "by:Tab". It worked with my computer. Hope it will solve your problem 😉

[@alyssabarretto3059]

@@nguyenduong1978 thanks!

[@nowaysir7576]

hello ! please i have a problem . when i import to anki only the first field shows ( i have 4 fields) any ideas please ? ( anki only recognize the firs field and the other collums does not show on anki please help i did exactly like you )

[@alyssabarretto3059]

me too i have this problem

[@alyssabarretto3059]

i figured it out. change the "fields separated by" to comma.

[@nowaysir7576]

@@alyssabarretto3059 wow it worked !!! Thank you

[@alyssabarretto3059]

@@nowaysir7576 yeah np glad to help!

[@ocongan6195]

ok, thanks

[@tubatubeomy]

When I imported the csv I don't know why the existing fields I have just shows front and back when importing even if I have multiple fields in that deck?

[@languagegirl1124]

Check the card type before importing - you could be importing to the right deck but the wrong card type :)

[@tubatubeomy]

@@languagegirl1124 My problem was already solved I just deleted that deck and made my own fields before importing the csv.

[@aceroyplatadeluna]

extremely helpful! どうもありがとうございます

[@Ridleyslayer1102]

I followoed all the steps but the reversed card created is always a copy of the regular card. How can I fix ?this

[@languagegirl1124]

Use a different note type that does not have reverse cards. See info here: apps.ankiweb.net/docs/manual.html#note-types

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

[@EastWindCommunity1973]

Thanks, languagegirl.

[@andreasgrunder7003]

you don't have to delete the header in the csv file. Just comment it with #

[@oliverkhoo]

How do you switch profiles on a web base Anki?

[@languagegirl1124]

Can't you just log out and log in with the new profile (should be a different email)