CSV to Anki — import spreadsheets as flashcard decks

Drop a .csv file and get a .apkg deck. Column A becomes the front, everything after A joins into the back. Works with Excel exports too.

How it works

1. Drop your file

Notion export, PDF, Word, Markdown, or a Quizlet export.

2. 2anki builds your deck

Usually a few seconds. Bigger files take a minute.

3. Open it in Anki

Double-click the .apkg file. Your cards are ready to study.

Supported formats

What you actually get in Anki

Cloze deletions stay clickable

{{c1::...}} becomes a real Anki cloze card, not plain text.

Images render in the card

Embedded images come across and display on the front or back.

Tags carry over

Strikethrough in Notion or a tag column in CSV attaches to every card in the deck.

Correct note types

Basic, Cloze, and front/back map to the right Anki note type so import is clean.

No junk in your cards

No empty backs, no stray #, *, or $ characters left over from your notes.

Common questions

What format does the CSV need to be in?

Column A is the front. Everything after A is joined into the back with spaces. Use a 2-column file for the cleanest result. A header row is detected and skipped automatically. UTF-8 encoding works best for accented characters and CJK text.

Can I import an Excel .xlsx file directly?

Yes — upload the .xlsx file and we convert it. If the spreadsheet has multiple sheets, the first sheet is used. A header row that looks like labels (short non-numeric text in every column) is detected and skipped.

How do I name the deck?

The deck name comes from the filename — rename the file before uploading and the deck will match. You can also rename the deck inside Anki after importing.

Where do tags come from?

v1 doesn't add tags from CSV columns. To tag cards, edit them in Anki after import, or paste the deck through Notion where strikethrough text becomes a tag on every card.

Related