How to Import Flashcards From Anki, Quizlet or a Spreadsheet

The knojo team4 min read

TL;DR

knojo imports plain CSV or TSV: the first column is the question, the second is the answer, and extra columns are ignored. Comma, semicolon and tab files all work and the delimiter is detected automatically, so Anki's tab-separated export, a Quizlet export and a Google Sheets CSV all import as-is. A 'question,answer' header row is skipped for you. One import handles up to 500 rows; split anything larger into several files.

Switching study apps usually means retyping everything, which is why most people don't switch. You shouldn't have to. If your cards exist anywhere as a table — an Anki export, a Quizlet set, a spreadsheet, a text file you keep meaning to tidy up — they can come across in one step.

What the file needs to look like

Two columns. First is the question, second is the answer. Anything after the second column is ignored, so you don't need to strip out tags, deck names or extra metadata before importing.

question,answer
What is the capital of France?,Paris
What is the capital of Japan?,Tokyo

The header row is optional. If the first line reads `question,answer` — or `front,back`, or `term,definition` — it's recognised and skipped rather than imported as a card. The delimiter is detected automatically, so comma, semicolon and tab files all work without you converting anything. That matters more than it sounds: Anki exports tab-separated, and spreadsheets in much of Europe export semicolons.

Quotes and commas are fine

A question containing a comma just needs to be wrapped in double quotes, the way every spreadsheet already writes it. Multi-line answers inside quotes are supported too.

Exporting from Anki

  1. Open the deck you want, then choose Export from the deck's gear menu (or File → Export).
  2. Set the export format to Notes in Plain Text (.txt). This produces a tab-separated file, which knojo reads directly — no conversion needed.
  3. Select the single deck rather than the whole collection, so you get one subject per file.
  4. Turn off the HTML and media options if offered. Cards full of `<div>` tags import as literal markup.
  5. Import the resulting `.txt` into knojo. The first two fields of each note become the question and answer.

About .apkg files

An .apkg is Anki's own package format — a zipped database, not a table — so it can't be imported directly. Export as plain text instead; it takes the same number of clicks.

Exporting from Quizlet

Quizlet's export gives you a block of text rather than a file: open the set, find the export option in its menu, and choose how terms and definitions should be separated. Pick comma or tab for the term/definition separator, and a new line between cards. Copy the result and paste it straight into knojo's import screen — there's a paste box next to the file picker precisely for this.

Exporting from Google Sheets or Excel

Put questions in column A and answers in column B, then File → Download → Comma-separated values (.csv) in Sheets, or Save As → CSV in Excel. Any further columns you keep for your own bookkeeping are ignored on import, so there's no need to delete them first.

Importing into knojo

  1. Create or pick the goal the cards belong to — imports always land in one goal, which keeps subjects from bleeding into each other.
  2. Choose the file, or paste the text.
  3. Tap Preview cards. You'll see how many cards are ready and how many rows were skipped, with the reason for each.
  4. Check a few of the previewed cards. This is the moment to notice that an export brought over formatting you don't want.
  5. Tap Import cards. They enter the goal's review queue from the next session.

What gets skipped, and why

The preview tells you exactly what didn't make it, rather than silently importing fewer cards than you expected. There are four reasons a row is dropped.

ReasonWhat it meansFix
IncompleteThe question is under 3 characters, or the answer is blank after trimming.Fill in the missing side, or drop the row.
Too longThe question exceeds 240 characters, or the answer exceeds 800.Usually a sign the card is doing too much — split it.
DuplicateThe same question already appeared earlier in the same file.Nothing to do; keeping one copy is what you want.
Over the 500-row limitOne import handles 500 rows at most.Split the file and import the parts one after another.
Skip reasons shown in the import preview.

The "too long" limit is worth taking as feedback rather than an obstacle. An answer over 800 characters is almost never a flashcard — it's a paragraph that should become three or four separate cards. See how to make flashcards that actually work for how to split them.

If a past import came out short

Versions before 1.0.3 had a bug where a file containing an unmatched double quote could silently drop every row after it — the import simply finished with fewer cards and reported them as one skipped row. It's fixed in 1.0.3. On that version or later, re-importing the same file brings in the rest; anything already there is recognised as a duplicate rather than doubled.

What happens after the import

Imported cards don't arrive all at once in your review queue. Each goal has a daily pace, so new cards drip in a few at a time alongside the reviews that are due — which is the point. Five hundred cards landing in one session would be a wall; a handful a day is a habit. The scheduling follows the same spaced repetition logic as cards you write yourself.

If your deck came from Anki, it's worth reading why a simpler spaced repetition setup often works better before you rebuild your old settings. Most of what makes Anki hard is configuration you probably don't need.

Start with one deck

Import your most important subject first and live with it for a week before moving everything. It's much easier to fix a formatting habit on 40 cards than on 400.

Frequently asked questions

What CSV format does knojo accept?+

Two columns: the first is the question, the second is the answer. Extra columns are ignored. Comma, semicolon and tab-separated files all work and the delimiter is detected automatically. A header row such as 'question,answer', 'front,back' or 'term,definition' is recognised and skipped.

Can I import an Anki .apkg file directly?+

No — an .apkg is a zipped database rather than a table. Export the deck as 'Notes in Plain Text (.txt)' instead, which produces a tab-separated file that imports directly. Turn off the HTML option if offered, or your cards will arrive full of markup.

How many cards can I import at once?+

Up to 500 rows per import. Larger files should be split and imported one after another. Separately, free accounts have a total card allowance — the import screen tells you how many more will fit before you confirm.

Why were some of my rows skipped?+

Four reasons, all shown in the preview: the row was incomplete (question under 3 characters or a blank answer), too long (question over 240 characters or answer over 800), a duplicate of an earlier question in the same file, or beyond the 500-row limit.

Will re-importing the same file create duplicate cards?+

Duplicate questions within a single file are skipped automatically, so re-importing a file that previously imported incompletely brings in the missing cards rather than doubling what's already there.

Put this into practice with knojo.

Turn your notes into a five-minute daily review queue and keep what you learn. Launching soon on iOS and Android.

Coming soon on iOS & Android
Download on the App StoreGet it on Google Play