Import from CSV

Bulk import flashcards from CSV files into Quantilo.


CSV import lets you bulk-create cards from spreadsheets or other flashcard apps.

CSV Format

Your CSV file should have two columns:

  1. Front — The question or prompt
  2. Back — The answer

Basic Example

front,back
What is the capital of France?,Paris
What year did WWII end?,1945
Who wrote Romeo and Juliet?,William Shakespeare

With Topics

Add a third column to organize cards into topics:

front,back,topic
What is H2O?,Water,Chemistry
What is NaCl?,Salt,Chemistry
What is the powerhouse of the cell?,Mitochondria,Biology

Importing Your File

  1. Click "Import""From CSV"
  2. Upload your CSV file
  3. Map columns to fields:
    • Select which column is the front
    • Select which column is the back
    • (Optional) Select topic column
  4. Preview the import
  5. Click "Import"

Export from Other Apps

From Anki

  1. In Anki, go to FileExport
  2. Select your deck
  3. Choose "Notes in Plain Text"
  4. Check "Include tags" if desired
  5. Export and import to Quantilo

From Quizlet

  1. Open your Quizlet set
  2. Click the three dots → Export
  3. Choose comma as the separator
  4. Copy to a .csv file
  5. Import to Quantilo

From Excel/Google Sheets

  1. Ensure columns are named front and back
  2. FileDownloadCSV
  3. Import to Quantilo

Handling Special Characters

Commas in Content

If your content contains commas, wrap the field in quotes:

front,back
"What is 1, 2, 3?","The first three numbers"

Quotes in Content

Escape quotes by doubling them:

front,back
"Who said ""To be or not to be""?",Shakespeare

Multi-line Content

For line breaks, use quotes:

front,back
"What are the three states of matter?","1. Solid
2. Liquid
3. Gas"

Best Practices

  1. Clean your data first — Fix typos before importing
  2. Use consistent formatting — Same style across all cards
  3. Preview before importing — Check the preview for issues
  4. Start small — Test with a few cards first
  5. Keep backups — Save your CSV file for reference

Troubleshooting

Import fails

  • Check for encoding issues (use UTF-8)
  • Ensure proper quoting for special characters
  • Verify column count matches all rows

Cards look wrong

  • Check the column mapping
  • Look for mismatched quotes
  • Ensure no extra columns