I am in the process of making my Glossika German into Anki.
After all the lengthy conversion and editing, I now have 3000 picture (image#.jpg) and 6000 audio files (audio - #.mp3). The audio of English is in odd number, while the German in even number.
I plan to have in one flashcard -
Front - one picture and one English audio
Back - one German audio.
No text as it is in both as I user picture instead .
How do I make it into Excel file so it will be imported successfully in Anki?
ANKI - How to make a spreadsheet containing audio and images (Glossika)?
-
- White Belt
- Posts: 28
- Joined: Thu Sep 22, 2016 8:17 am
- Languages: Malay (N) English (C1) German (A2)
- x 11
ANKI - How to make a spreadsheet containing audio and images (Glossika)?
Last edited by ibrahimovic on Tue Oct 18, 2016 11:58 am, edited 2 times in total.
0 x
- rdearman
- Site Admin
- Posts: 7255
- Joined: Thu May 14, 2015 4:18 pm
- Location: United Kingdom
- Languages: English (N)
- Language Log: viewtopic.php?f=15&t=1836
- x 23248
- Contact:
Re: ANKI - How to make a spreadsheet containing audio and images (Glossika)?
ibrahimovic wrote:I am in the process of making my Glossika German into Anki.
After all the lengthy conversion and editing, I now have 3000 picture (image#.jpg) and 6000 audio files (audio - #.mp3). The audio of English is in odd number, while the German in even number.
I plan to have in one flashcard -
Front - one picture and one English audio
Back - one German audio.
No text as it is in both as I user picture instead .
How do I make it into Excel file so it will be imported successfully in Anki?
You can't have an "Excel" file. The format must be a tab separated value file. You can learn about importing TSV files on the anki support forum here: https://ankiapp.freshdesk.com/support/solutions/articles/5000051548-can-i-import-decks-from-spreadsheets-tsv-csv-
You need to have created a template card for the import and just tell anki which field maps to which field on your cards. THen you have to move the pictures and the audio into your media collection.
2 x
: Read 150 books in 2024
My YouTube Channel
The Autodidactic Podcast
My Author's Newsletter
I post on this forum with mobile devices, so excuse short msgs and typos.
My YouTube Channel
The Autodidactic Podcast
My Author's Newsletter
I post on this forum with mobile devices, so excuse short msgs and typos.
- klvik
- Orange Belt
- Posts: 177
- Joined: Wed Jul 13, 2016 8:40 pm
- Location: United States
- Languages: English (N) Spanish (Intermediate)
- Language Log: viewtopic.php?f=15&t=3149
- x 441
Re: ANKI - How to make a spreadsheet containing audio and images (Glossika)?
This is what I do:
1. Organize you spreadsheet so that each Anki note is a line and each Anki field is a column. The columns should be organized in the same order as the fields in your Anki template.
2. If you are adding more than one tag per note, put them all in the same column separated by a space. If a tag consists of more than one word, link then together using an underscore, such Harry_Potter, Glossika_sentences.
3. When you are ready to import into Anki, save a copy of your spreadsheet as a tab delimited text file.
Save as > Text (tab delimited).
Note: I find it useful to change the file name so that I don’t mix up the Excel version and the text version.
4. You now need to change the character coding of the text file to UTF-8. I use Notepad to do this.
File > Save as > Change encoding from ANSI to UTF-8
5. Import the tab delimited file into Anki using the ‘import file’ button on the main page.
Note: You will need to manual copy all of the media files into the Anki media folder.
1. Organize you spreadsheet so that each Anki note is a line and each Anki field is a column. The columns should be organized in the same order as the fields in your Anki template.
2. If you are adding more than one tag per note, put them all in the same column separated by a space. If a tag consists of more than one word, link then together using an underscore, such Harry_Potter, Glossika_sentences.
3. When you are ready to import into Anki, save a copy of your spreadsheet as a tab delimited text file.
Save as > Text (tab delimited).
Note: I find it useful to change the file name so that I don’t mix up the Excel version and the text version.
4. You now need to change the character coding of the text file to UTF-8. I use Notepad to do this.
File > Save as > Change encoding from ANSI to UTF-8
5. Import the tab delimited file into Anki using the ‘import file’ button on the main page.
Note: You will need to manual copy all of the media files into the Anki media folder.
2 x
January 5, 2020
2020 Output Challenge speaking:
2020 Output Challenge speaking:
-
- Posts: 1
- Joined: Wed Jan 31, 2018 9:03 pm
- Languages: English (N)
Re: ANKI - How to make a spreadsheet containing audio and images (Glossika)?
If you export the spreadsheet as a .csv file I could write you a script to make the Anki deck.
Incidentally, I've been scouring the Internet for just such an Anki German Glossika deck, I would be so grateful if you could share that spreadsheet/edited audio!
Incidentally, I've been scouring the Internet for just such an Anki German Glossika deck, I would be so grateful if you could share that spreadsheet/edited audio!
0 x
Return to “Technical Support and Feature Requests”
Who is online
Users browsing this forum: No registered users and 2 guests