Flashcard Maker from CSV, Excel, Google Sheets, or PDF Text

Make printable double-sided flashcards from a CSV or TSV file, rows pasted from Excel or Google Sheets, a pipe-delimited list, or text copied from a PDF. Study in the browser and export for Anki.

Back pages mirror columns for two-sided printing.

Show one browser card at a time.

Import source
Import format

Cards

Front Back Hint Tags Actions

Printable deck

6 valid cards, 1 page

US Letter, 3 by 3, 2.500in by 3.333in cards

Export

valid cards = rows with front and back text; duplex backs mirror each row How?

How these cards are prepared

The tool trims rows, ignores empty rows, and keeps rows with both front and back text for print and export. CSV and TSV import follow RFC 4180 (quoted fields, doubled quotes, UTF-8). Spreadsheet clipboards are tab-separated, so a cell is quoted only for a tab, newline, or quote, never a comma. Auto detect checks tab, comma, and semicolon before pipe, so a pipe list whose definitions contain commas needs the Pipe format selected; Lines mode starts a new card at each blank line and joins the remaining lines of a block into the back. The Anki copy escapes the ampersand and angle brackets so #html:true renders inequalities and ampersands correctly. Print dimensions come from the selected page size, margin, and card grid.

Formula: valid cards = rows with front and back text; duplex backs mirror each row

Sources

  1. Anki Manual, Importing text files. Anki. Retrieved .
  2. Anki Manual, Exporting. Anki. Retrieved .
  3. RFC 4180, Common Format and MIME Type for CSV Files. IETF. Retrieved .
  4. Twenty rules of formulating knowledge. SuperMemo. Retrieved .

Method last reviewed