ANKI - How to make a spreadsheet containing audio and images (Glossika)?

Discuss technical problems and features here
ibrahimovic
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)?

Postby ibrahimovic » Tue Oct 18, 2016 11:49 am

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?
Last edited by ibrahimovic on Tue Oct 18, 2016 11:58 am, edited 2 times in total.
0 x

User avatar
rdearman
Site Admin
Posts: 4800
Joined: Thu May 14, 2015 4:18 pm
Location: United Kingdom
Languages: English (N)
Language Log: viewtopic.php?f=15&t=1836
x 11535
Contact:

Re: ANKI - How to make a spreadsheet containing audio and images (Glossika)?

Postby rdearman » Tue Oct 18, 2016 2:31 pm

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

User avatar
klvik
Orange Belt
Posts: 167
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 405

Re: ANKI - How to make a spreadsheet containing audio and images (Glossika)?

Postby klvik » Tue Oct 18, 2016 4:33 pm

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.
2 x
February 16, 2019
2x Super Challenge pages: 6145 / 10000
2x Super Challenge minutes: 11340 / 18000
Output Challenge speaking: 570 / 3000
Half Output Challenge writing: 5100 / 25000

justinsilvestre
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)?

Postby justinsilvestre » Wed Jan 31, 2018 9:06 pm

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!
0 x


Return to “Technical Support and Feature Requests”

Who is online

Users browsing this forum: No registered users and 0 guests