Free CSV to APKG Converter

Turn a CSV, TSV or plain text file of flashcards into an Anki .apkg deck. Paste or upload, download, import. No signup.

One card per row: front first, back second. A header row like Front,Back or Question,Answer is detected and skipped.

or
Delimiter

Preview (first 5 cards)

Paste text or upload a file to see a preview here.

How to convert a spreadsheet to .apkg

  1. Put the front of each card in column A and the back in column B, one card per row.
  2. In Google Sheets, click File, Download, Comma Separated Values (.csv). In Excel, click File, Save As and choose CSV UTF-8 (Comma delimited).
  3. Upload the file above, or copy the two columns and paste them into the box, then click Convert & Download .apkg.

CSV to APKG

Comma and semicolon separated files are read as proper CSV, so a back side wrapped in quotes can contain commas and line breaks. If the first row names the columns (Front and Back, Question and Answer, or Term and Definition), the converter uses those columns and ignores the rest, which is handy for exports with extra columns like tags or dates.

TSV to APKG

Tab separated files work the same way. Copying two columns straight out of Google Sheets or Excel gives you tab separated text, so pasting is often quicker than saving a file.

TXT to APKG

Plain text works if each line has a front and a back separated by a tab, comma, semicolon, or " - ". With the dash, only the first " - " on a line splits the card, so dashes inside the answer are safe.

Cloze cards

Wrap the hidden part in double curly braces: The capital of France is {{Paris}}. Each set of braces becomes its own cloze deletion. Anki syntax like {{c1::Paris}} is kept as it is. A second column on a cloze row becomes the Back Extra field.

What carries over

  • Text in the front and back columns, including line breaks inside quoted cells.
  • Accents and non-Latin scripts, as long as the file is saved as UTF-8.
  • HTML formatting and images don't. Tags are stripped so the cards show clean text.
  • Extra columns such as tags or dates are ignored.

Troubleshooting

  • Strange characters instead of accents: save as CSV UTF-8 in Excel rather than plain CSV.
  • Every card ends up on the front: choose the right delimiter instead of Auto-detect.
  • Your header row became a card: name the columns Front and Back so the converter recognises them.
  • Can't Anki import CSV itself? It can, through File then Import with field mapping. An .apkg skips the mapping step and opens the same way on AnkiDroid and AnkiMobile.

For every way to get cards into Anki, read the guide to importing flashcards into Anki. Moving from a specific app? Use the Quizlet to Anki converter or the Gizmo to Anki converter.

CSV to APKG Converter FAQs

Is this CSV to APKG converter free?

Yes. There's no signup, no watermark and no card limit beyond 2,000 cards per file.

What is an .apkg file?

An .apkg is an Anki deck package. It holds the cards and the deck in one file, so you can import it into Anki desktop, AnkiDroid or AnkiMobile without mapping fields.

Can I convert a TXT file to APKG?

Yes. Put one card per line with the front and back separated by a tab, comma, semicolon or a spaced dash, then upload the .txt file or paste its contents.

Does it support cloze deletions?

Yes. Any row containing text in double curly braces, like {{Paris}}, becomes an Anki cloze card. Existing Anki cloze syntax such as {{c1::Paris}} is kept.

How big can my file be?

Up to 1 MB and 2,000 cards per conversion. Split larger files into several decks.

Have the original PDF or lecture slides?

Converting copies over the cards you already have. StudyCards AI reads the source material and writes a fuller deck, then exports it to Anki in one click.

Generate a better deck with AI

You might also like these tools:

Spaced Repetition Calculator

Create an optimal study schedule

Flashcard ROI Calculator

See the time savings from using AI flashcards

Anatomy Flashcard Strategy

Create effective anatomy flashcards

Quizlet to Anki Converter

Convert Quizlet sets to a ready-to-import .apkg

Gizmo to Anki Converter

Paste Gizmo cards, download an .apkg

Brainscape to Anki Converter

Turn a Brainscape export into an Anki deck

StudySmarter to Anki Converter

Turn a StudySmarter CSV into an Anki deck

RemNote to Anki Converter

Turn RemNote flashcard syntax into Anki cards

Notion to Anki Converter

Turn a Notion database CSV into an Anki deck

Ready to take your studying to the next level?

StudyCards AI can automatically generate all the flashcards you need based on your specific needs.

Try StudyCards AI Free