CSV to Anki deck, with sound on every card
Paste a word list or open a CSV, and download a ready .apkg deck: open the file and Anki adds the deck, with no import settings to get right. Add the MP3s, or the ZIP from Speecho, and each card plays its own sound. Free, no signup, nothing is uploaded.
- Notes
- -
- Cards
- -
- With sound
- -
- Deck size
- -
| # | Front | Back | Example | Sound |
|---|
Nothing is uploaded. The deck is built in this tab, from files that never leave your device.
Opening the deck in Anki
- Anki on a computer. Double-click the .apkg file, or choose File > Import in Anki and pick it. The deck shows up in your deck list with its sound.
- AnkiDroid. Open the downloaded file from your notifications or the Files app and choose AnkiDroid, or use Import in AnkiDroid's menu.
- AnkiMobile on iPhone and iPad. Open the file in the Files app or in Safari's downloads, and send it to AnkiMobile with the Share button.
What is inside the deck file
An .apkg is a small package Anki knows how to open: a database with your notes and cards, and the sound files beside it. This page writes it in the collection format that Anki on a computer, AnkiDroid and AnkiMobile all read. Each note holds the word, the translation, an example if you want one, and its sound; Anki makes one card per note, or two for both directions.
Each card gets its sound in this order: a [sound:...] column, as in the Anki CSV from Speecho's flashcard audio; then the number and the word in the file name (0001_lopen.mp3); then the word alone (lopen.mp3). Whatever is left over is listed before you build, so no card ends up with another word's sound. Need the list in another format first, for Quizlet or a spreadsheet? The flashcard converter does that.
Questions
How do I make an Anki deck from a CSV?
Open the CSV here or paste its rows, check the preview, give the deck a name and press Build the deck. You get one .apkg file: open it and Anki adds the deck, with no import dialog to fill in. The first column becomes the front of each card and the second the back.
How do I add audio to the cards?
Add the sound files below the list: MP3s, or a ZIP of them. If they come from Speecho, use the Anki CSV as the list and the ZIP as the sound, and every card finds its file through the CSV's [sound:...] column. Your own files work too when they are named after the word (lopen.mp3) or numbered in list order (0001.mp3). Cards and files that found no partner are listed before the deck is built.
Will the deck work in AnkiDroid and AnkiMobile?
The file is a standard .apkg in the collection format that Anki on a computer, AnkiDroid and AnkiMobile all import, sound included. On a phone, open the downloaded file with the app, or use its Import command.
What happens if I import the same deck again?
Cards are recognised by their word and translation, so importing an updated deck adds the new cards and leaves the ones you already have as they are, with their review history. A card whose translation you changed counts as a new card.
Which lists can I use?
A CSV or TSV, a Quizlet export, an Anki text export, two columns pasted from a spreadsheet, or lines typed as word - translation, word: translation or word = translation. Numbering, blank lines and duplicates are cleaned up, and lines without a translation are shown and left out.
What does the third column do?
With Third column as an example on the back ticked, a third column (an example sentence, a reading, a note) shows under the translation in smaller type. A [sound:...] column is never shown as text: it becomes the card's sound.
How many cards can a deck have?
A deck without sound can hold thousands of cards. With sound, the files are kept in memory while the deck is built, so a deck takes sound for up to 1,000 cards on a computer and 200 on a phone; split a longer list into several decks.
Are my files uploaded?
No. The list is read, the sound is matched and the deck is written in this browser tab. The only thing the page downloads is the deck builder itself (SQLite for the web, under 1 MB), when you press Build the deck.