CSV to Anki Converter

Supported files

You can open CSV, TSV, or Excel (.xlsx) files, or paste cells copied straight from Excel, Google Sheets, or Numbers. The delimiter is detected automatically, and the preview shows exactly how the rows were split before you import.

Quoted fields with commas or line breaks inside them are handled, so definitions that contain commas won't be split.

Check the preview

After loading the file, check the preview. The first column becomes the front and the second the back. If your sheet has extra columns such as an ID or private notes, delete them in the spreadsheet first, or remove them in the editor.

If the first row is a header like "Term, Definition", delete that card so it doesn't end up in the deck. Then add tags in the editor if you want them; tags are included in the .apkg.

Choose a card type

• Basic – one card per row.
• Basic and reversed – a card in each direction.
• Cloze – if a column contains {{c1::...}} markup, it becomes an Anki cloze note.

Images that you add in our editor afterwards are packed into the .apkg along with the cards.

Download and import

Click Download .apkg and open the file in Anki (File → Import, or double-click). The deck name, note type, and tags come through. The file is created in your browser; your spreadsheet isn't uploaded anywhere.

Prefer to stay in the browser? Study the same deck here with spaced repetition, or print it.

The same spreadsheet can become several things. Export a printable PDF, a Quizlet-importable text file, or a JSON backup, or study it right here. You can also go the other way: export any deck as CSV to edit it in a spreadsheet, then import it again.

Tips for clean spreadsheets

• Keep one card per row and one idea per card.
• Keep extra columns (IDs, private notes) out of the file, or delete them first.
• Save as UTF-8 CSV if you work with accents or non-Latin scripts; .xlsx files avoid the encoding issue entirely.
• Remove empty rows at the bottom of the sheet.

Example: a vocabulary spreadsheet

Suppose you keep Spanish vocabulary in a spreadsheet with two columns: Spanish word and English meaning. Save it as .xlsx or UTF-8 CSV and open it here, or select the two columns in your spreadsheet app and paste them. Each row becomes a card with Spanish on the front and English on the back.

Choose the reverse card type if you also want English-to-Spanish cards; Anki will then show each word in both directions. Add tags such as "chapter-3" in the editor so you can filter later in Anki. If you want pronunciation, the browser's text-to-speech works here while you study, though Anki uses its own audio settings.

The same approach works for a list of chemical elements and symbols, a table of medications and their classes, historical dates and events, or any other two-column list. Before exporting, a minute spent fixing typos is worth it — fixing them in the spreadsheet means the next export is clean too.