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.
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.
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
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
Thanks for sharing. I'm learning all of this in my late 20s going after my bachelors. It feels like a big weight lifted off my shoulders, knowing that my studying is going to be efficient. It makes me more hopeful knowing that this stuff has been out since 2016 because people back then are now in much better positions (I hope). I use to always bash my head against the wall when I was 19-20 thinking how the heck am I going to learn all of this stuff through my college years and still ace my exams. Hence, me dropping out. But now taking some time to learn about Anki I got my whole Anki optimized and ready to go. I think I found out about Anki through some productivity TH-camrs but I turned a blind eye to it because it seemed too rigid for me and so I quit it back in 2018 but now that my workload is picking up I decided to humble myself and educate myself on how to actually use it. I thought it was too rigid and the user interface too unappealing. But anyways, thanks for posting this. I learned about this .csv method from another video and your video confirmed how easy it is to upload these types of flashcards onto Anki.
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!
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.
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
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.
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 )
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!
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!
@@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 :)
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!
Do you know, you have an amazing voice, so sweet and incredible pronunciation?, I am a native Spanish speaker and I perfectly understand every single word from you.. and by the way, thanks for this tutorial, best regards from Madrid... :-)
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.
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?
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?
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.
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!
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.
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.
@@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.
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?
You actually don't have to worry about whether or not you have used the delimiter in your document, because upon exporting a cell that has the delimited in it, it will be put in quotation marks automatically! So you can use comma as your delimiter even if you have used commas!
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!
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.
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
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
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 . . .
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?
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.
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?
Can someone please show me how to use anki?? I'm desperate!! I put a lot of hard work into making my cards and I think I pressed the wrong button that changed all my card types and now all my cards look weird. Can someone please walk me through it via a zoom session or something. I totally need all my cards. I'm literally crying right now because it looks like I messed up all my hard work.
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)
I didn't get it to work. Using Windows 10. When I performed what this video instructed, I received a message "Empty first field" for as many rows I have in my spreadsheet. My first fields are not empty. The Anki manual says regarding "Anki Excel Sync" - "Currently does not work with Anki v2.1.25+." I have what is probably the latest version (Version 2.1.43 (0fbae6bc)). Maybe Anki has been downgraded and no longer supports spreadsheet input. I keep all flashcard data in an Excel spreadsheet. If I can't get Anki to work with a spreadsheet, then Anki is useless. Does anyone have a solution?
Try copy pasting your excel spreadsheet (only the filled out cells of course) into Notepad. Save the file as a . txt but make sure to change the encoding to UTF-8 if you're working with asian characters. Then import the file into Anki. It should detect the text properly... This is the method I use on Windows 10. Let me know if it works!
@@languagegirl1124 No Asian characters, but I have Spanish characters. I'll try this and see if it works. Thank you SO much for your kindness. I'll let you know how it goes.
@@dimwitsadvocate6264 this is really weird as I've done this just recently myself. It says the first field is blank, right? Maybe try a test document? Just write something like: 1,2,3 4,5,6 7,8,9 Into Notepad and try to upload that. You're going to try to see if all files are bad or maybe the excel file you have has a blank or something else wrong...
@@languagegirl1124 Yes, this is certainly weird. For each row in my spreadsheet, Anki gives the message, "Empty first field". Then the end of the result says, "16 notes unchanged", and the deck is blank. I'm using mostly tab delimited as some of my fields may someday have a comma in them. If I make a file like you suggest, I assume I'd have to make the import comma delimited.
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?
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
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?
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
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!
So, you need to have the headers already configured in Anki! What If i am choosing to learn something like say Sanskrit? That would not be feasible here, would it?
Depending on the script you're using, UTF-8 may support. I would give it a go and see if you can save files and upload them without it turning to junk in Anki.
Pretty late response, but I don't see why a similar process wouldn't work for Sanskrit. You just need to create the deck name and note type in advance in anki, then following these same steps would do it. Devanagari script (including Sanskrit unique letters) does exist in Unicode, no problems there either.
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
I use a Japanese IME where I can switch between typing in Japanese and English by pressing ctrl+space. I believe on Windows you can do the same thing on that IME by going Ctrl+"~" (don't quote me on this)
Thanks so much for the reply! I live abroad and am constantly switching back and forth between two scripts - never even thought there was a quick way to do it until I saw you!
Windows 10 - switch between keyboards using the windows Key + Space Bar. Provided you already have another language keyboard set up through your control panel
Not an option in Excel unfortunately. What you can do is copy/paste the cells from Excel to Notepad, and then save and make sure you use UTF-8 encoding when saving if you're plugging in Japanese/Chinese/etc.
@@tenaibms Totally did! I do sentences on the front, and then a j-j definition on the back (plus furigana on the sentence). I had to stop doing anki for about 9 months after starting a new job, but now I'm back on track :) I might have to make a video on how to catch up on a huge backlog (hint: suspend cards... lots and lots of them lol)
@@languagegirl1124 Awesome! I haven't yet switched to j-j, but I plan to eventually. Also Anki is not as useful once you're fluent. By the way, do you have discord? I'd love to talk to you more about this, as well as some stuff about pitch accent :D
Hi, Very good video overall but there is no "Text CSV" in excel. "CSV(MS-DOS)" and "Text (MS-DOS)" and these formats not letting me to choose unicode (UTF-8). Anyway i just exported and imported successfully but fonts are "??????" help pls? Thanks
What version of Excel do you have? You might want to try saving as a Unicode (.txt) file type too. If you continue to have problems, you can use Open Office which is what I use in this video.
+Tsomi Moots If you name the images properly, put them in the media folder, and create a column with this in it with the name of the file in it it should work:
Hm, you deleted the images - you will have to send them again before I can help! but you should be able to do a function like ="", where A2 is the cell location for the name of the file and you edit the file type at the end (or omit it all together).
![How To Use Anki Like A Pro [Full Step-By-Step Walkthrough]](http://i.ytimg.com/vi/WmPx333n5UQ/mqdefault.jpg)
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.
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.
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
The keyboard is loud and proud. Just moved it to my work a month or two ago and now it annoys my coworkers :)
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
me too hahhaa
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.
I found myself with the need to create over 30k cards. No way I'd do it one by one. Thank you!
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!!!
0:16 that hit me directly. I made about 590 cards one by one before looking for another way
im still coming back again and again because this video is so good
The simplest video out there! Thanks!
日本人です。暗記の使い方とっても分かり易かったです、ありがとうございます！
Thanks for sharing. I'm learning all of this in my late 20s going after my bachelors. It feels like a big weight lifted off my shoulders, knowing that my studying is going to be efficient. It makes me more hopeful knowing that this stuff has been out since 2016 because people back then are now in much better positions (I hope). I use to always bash my head against the wall when I was 19-20 thinking how the heck am I going to learn all of this stuff through my college years and still ace my exams. Hence, me dropping out. But now taking some time to learn about Anki I got my whole Anki optimized and ready to go. I think I found out about Anki through some productivity TH-camrs but I turned a blind eye to it because it seemed too rigid for me and so I quit it back in 2018 but now that my workload is picking up I decided to humble myself and educate myself on how to actually use it. I thought it was too rigid and the user interface too unappealing. But anyways, thanks for posting this. I learned about this .csv method from another video and your video confirmed how easy it is to upload these types of flashcards onto Anki.
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!
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.
yeah it was really bothering me haha. On key is how it is pronounced.
@kaoriexpress999, thanks for this.
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.
How is it possible for people to be so helpful?
Amazing
really cut short my work
For those facing problem with Excel
Use Google Spreadsheet and download in .csv format
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
Unrelated to the video but, this in the first time I seen someone use Mint for their OS.
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.
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!
This is a great tutorial - love you delivery so calm
the best tutorial out there! your a legend, girl! Thank you ever so much!!!
Thanks so much, glad it worked so well for you :)
Thank you languagegirl this was a major time saver
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 )
me too i have this problem
i figured it out. change the "fields separated by" to comma.
@@alyssabarretto3059 wow it worked !!! Thank you
@@nowaysir7576 yeah np glad to help!
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!
Thank you. This video revolutionized my life
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!
You're very welcome!
I've never used Quizlet before.
What are the differences between quizlet and anki?
@@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 :)
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!
I am lucky I stumbled here, this is going to be really useful and save my time. Thank you!!
Do you know, you have an amazing voice, so sweet and incredible pronunciation?, I am a native Spanish speaker and I perfectly understand every single word from you.. and by the way, thanks for this tutorial, best regards from Madrid... :-)
GrosterCocina You are super nice :) I'm glad you think so, good pronunciation is very important!!
4:56 why can’t I create multi field mapping and you can do?
Hello.I created the fields like "front, back & tags" but the tags don't appear when I want to study filtered decks. Help please.
i ihave the same problem
i figured it out. change the "fields separated by" to comma.
What about the multiple tags?
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
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
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.
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
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?
Thanks for this. I have 1200 words and it would take a lot of time to make it one by one.
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?
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.
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!
Amazing. Thanks. Greetings from Brazil
Thanks you, but how to fill sound field automaticly?
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.
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.
@@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.
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?
Your file is blank for some reason. You need to open it up after saving it and check...
Wow, it's so cool and productive! I like it! Thank you!
Thank you very much for this! 🎉
I'm wandering if i can do that when studying foreign literatures
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 受益
do you know what language setting we use if we've got Maori characters?
(ā ē ī ō ū)
You actually don't have to worry about whether or not you have used the delimiter in your document, because upon exporting a cell that has the delimited in it, it will be put in quotation marks automatically!
So you can use comma as your delimiter even if you have used commas!
It still takes a long time because you still need to type each word one by one in the spreadsheet
or you could copy/paste into your spreadsheet from an existing list (online, etc)
Anki newbie here. How do they look like after importing into Anki?
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!
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.
It's absolutely amazing. Really, thank you!
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
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.
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
Thank you very much for sharing this!!!!
it's most cenrtainly not showing the same "edit filter options" setting in excel and it's slowly been driving me mad
any way to batch import images?
PLEASE, i look for a method to extract cards to Excel by media
all methods which i find only extract cards without media.
If you're trying to export cards to Excel, there is no way to export with media attached. Sorry.
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
.
.
.
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?
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.
@@languagegirl1124 Thanks a lot for your reply ❤️
Based on your experience with Anki can u tell me please the best type of cards for language learning ? Basic / ....
Hey, Just wanted to thank you for the tutorial!
Can i create Deck and sub-decks similar to what you did for Anki Cards ?
Please see here: th-cam.com/video/R-Xnf9FAY40/w-d-xo.html
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?
Check the card type before importing - you could be importing to the right deck but the wrong card type :)
@@languagegirl1124 My problem was already solved I just deleted that deck and made my own fields before importing the csv.
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
where are the created flashcards at the end?
You specify the deck when importing- so check that deck!
i cannot find the .txt file after click import ?
Can someone please show me how to use anki?? I'm desperate!! I put a lot of hard work into making my cards and I think I pressed the wrong button that changed all my card types and now all my cards look weird. Can someone please walk me through it via a zoom session or something. I totally need all my cards. I'm literally crying right now because it looks like I messed up all my hard work.
I followoed all the steps but the reversed card created is always a copy of the regular card. How can I fix ?this
Use a different note type that does not have reverse cards. See info here: apps.ankiweb.net/docs/manual.html#note-types
you don't have to delete the header in the csv file. Just comment it with #
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)
I didn't get it to work. Using Windows 10. When I performed what this video instructed, I received a message "Empty first field" for as many rows I have in my spreadsheet. My first fields are not empty.
The Anki manual says regarding "Anki Excel Sync" - "Currently does not work with Anki v2.1.25+." I have what is probably the latest version (Version 2.1.43 (0fbae6bc)). Maybe Anki has been downgraded and no longer supports spreadsheet input.
I keep all flashcard data in an Excel spreadsheet. If I can't get Anki to work with a spreadsheet, then Anki is useless. Does anyone have a solution?
Try copy pasting your excel spreadsheet (only the filled out cells of course) into Notepad. Save the file as a . txt but make sure to change the encoding to UTF-8 if you're working with asian characters. Then import the file into Anki. It should detect the text properly... This is the method I use on Windows 10. Let me know if it works!
@@languagegirl1124 No Asian characters, but I have Spanish characters. I'll try this and see if it works. Thank you SO much for your kindness. I'll let you know how it goes.
@@languagegirl1124 That failed also. When I paste it, it is tab delimited which should work fine. Very frustrating. Yes, UTF-8.
@@dimwitsadvocate6264 this is really weird as I've done this just recently myself. It says the first field is blank, right?
Maybe try a test document?
Just write something like:
1,2,3
4,5,6
7,8,9
Into Notepad and try to upload that. You're going to try to see if all files are bad or maybe the excel file you have has a blank or something else wrong...
@@languagegirl1124 Yes, this is certainly weird. For each row in my spreadsheet, Anki gives the message, "Empty first field". Then the end of the result says, "16 notes unchanged", and the deck is blank. I'm using mostly tab delimited as some of my fields may someday have a comma in them. If I make a file like you suggest, I assume I'd have to make the import comma delimited.
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?
Yh, you have to create it.
where do I get these note types from? p.s. my programming skills = 0 :(
It's useful very much, thanks
How do you switch profiles on a web base Anki?
Can't you just log out and log in with the new profile (should be a different email)
Thanks for this! Is it possible to update and add to your flash card sets this way as well?
thank you for this video. does anyone know how to save the csv file in excel correctly?
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
Choose "Fields separated by: Comma" not "by:Tab". It worked with my computer. Hope it will solve your problem 😉
@@nguyenduong1978 thanks!
hi thanks for this helpful video! but how do i get the languages option? I wanna do flashcards for Spanish. Thanks
Not sure what you mean. This technique will work just fine with Spanish too :) no need to change anything
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?
Yh, I wonder about that too
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
Why so blurry?
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!
If I have time, Carlos, I will definitely consider it! Busy studying for a Japanese exam for the rest of the year :)
Oh man I love you so much
Wonderful. Thank you.
Thanks a lot, very useful
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
What's the error that you're getting?
So, you need to have the headers already configured in Anki!
What If i am choosing to learn something like say Sanskrit?
That would not be feasible here, would it?
Depending on the script you're using, UTF-8 may support. I would give it a go and see if you can save files and upload them without it turning to junk in Anki.
Pretty late response, but I don't see why a similar process wouldn't work for Sanskrit. You just need to create the deck name and note type in advance in anki, then following these same steps would do it. Devanagari script (including Sanskrit unique letters) does exist in Unicode, no problems there either.
Would u recommend using anki for GCSE? Btw good video!!
is there any way to print your flashcards directly from your anki?
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
Great video!
how do you switch so quickly between typing english and japanese?
I use a Japanese IME where I can switch between typing in Japanese and English by pressing ctrl+space. I believe on Windows you can do the same thing on that IME by going Ctrl+"~" (don't quote me on this)
Thanks so much for the reply! I live abroad and am constantly switching back and forth between two scripts - never even thought there was a quick way to do it until I saw you!
Windows 10 - switch between keyboards using the windows Key + Space Bar. Provided you already have another language keyboard set up through your control panel
use Shift + Alt or Shift + Ctrl
Actually, I think it's Windows Key+Space
Thanks dear friend!! I now understand how to do it!!!
Nice video :D
i can't find text csv :(
Not an option in Excel unfortunately. What you can do is copy/paste the cells from Excel to Notepad, and then save and make sure you use UTF-8 encoding when saving if you're plugging in Japanese/Chinese/etc.
How to do this on mobile
Sorry, you cannot import CSV files on the android version of Anki. I am not sure about the iphone version.
Just so you know your definition of Utf-8 is completely wrong, other then that great tutorial
louis Roensch probably was. All I know is bad things happen when you don't use it!
Can you add audios as well?
Yes, check out my other video titled "Quickly Create Audio for your Anki Cards
"
Thanks! Assuming this youtube channel isn't abandoned, how has your 日本語 study gone? Also nice Linux Mint.
WOW this is an old comment.
I now work in Japan, in Japanese, and studying for N1. Definitely didn't imagine any of that happening but here I am!
@@languagegirl1124 Woah you replied!
Sounds like they went well haha in the end haha, did you ever transition to sentence cards?
@@tenaibms Totally did! I do sentences on the front, and then a j-j definition on the back (plus furigana on the sentence). I had to stop doing anki for about 9 months after starting a new job, but now I'm back on track :)
I might have to make a video on how to catch up on a huge backlog (hint: suspend cards... lots and lots of them lol)
@@languagegirl1124 Awesome! I haven't yet switched to j-j, but I plan to eventually.
Also Anki is not as useful once you're fluent.
By the way, do you have discord? I'd love to talk to you more about this, as well as some stuff about pitch accent :D
Hi, Very good video overall but there is no "Text CSV" in excel. "CSV(MS-DOS)" and "Text (MS-DOS)" and these formats not letting me to choose unicode (UTF-8). Anyway i just exported and imported successfully but fonts are "??????" help pls? Thanks
What version of Excel do you have? You might want to try saving as a Unicode (.txt) file type too. If you continue to have problems, you can use Open Office which is what I use in this video.
ok i used Open Office and it works fine :D thanks. But can i add images through Open Office?
+Tsomi Moots If you name the images properly, put them in the media folder, and create a column with this in it with the name of the file in it it should work:
like this? unsee.cc/nozugabe/
but when i import to anki it has 3 category and shows only 2 like this unsee.cc/saporuzi/
Hm, you deleted the images - you will have to send them again before I can help! but you should be able to do a function like ="", where A2 is the cell location for the name of the file and you edit the file type at the end (or omit it all together).
... and on Linux too. I love it.
Fantastic, thank you!