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:
- Front — The question or prompt
- 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
- Click "Import" → "From CSV"
- Upload your CSV file
- Map columns to fields:
- Select which column is the front
- Select which column is the back
- (Optional) Select topic column
- Preview the import
- Click "Import"
Export from Other Apps
From Anki
- In Anki, go to File → Export
- Select your deck
- Choose "Notes in Plain Text"
- Check "Include tags" if desired
- Export and import to Quantilo
From Quizlet
- Open your Quizlet set
- Click the three dots → Export
- Choose comma as the separator
- Copy to a
.csvfile - Import to Quantilo
From Excel/Google Sheets
- Ensure columns are named
frontandback - File → Download → CSV
- 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
- Clean your data first — Fix typos before importing
- Use consistent formatting — Same style across all cards
- Preview before importing — Check the preview for issues
- Start small — Test with a few cards first
- 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