Google Sheets to Anki — turn spreadsheet rows into flashcards

Download your sheet as .csv or .xlsx, upload it, and download a .apkg deck. Each row becomes a card, columns you pick.

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

Do I need a Google Sheets add-on or plugin?

No. You export the sheet as a .csv or .xlsx from the built-in File → Download menu and upload that file. There's nothing to install in Sheets or in Anki.

Which export format should I choose, .csv or .xlsx?

Either works. .csv is the simplest — plain text, one row per card. Choose .xlsx if your sheet already has the columns arranged the way you want and you'd rather keep the spreadsheet structure. Both land as the same deck.

Can I pick which columns become the front and back?

Yes. After upload you map columns to the card's front and back, so it doesn't matter which order they sit in your sheet. Extra columns can be left out or kept as notes.

Does each row really become one card?

Yes — one row in, one card out. A 200-row vocabulary sheet gives you a 200-card deck.

Can I convert an Excel file the same way?

Yes. The .xlsx path is identical whether the file came from Google Sheets or Excel.

Related