Back
Unable to import CSV - "CSV header mismatch"
Having some troubles importing a CSV.
CSV header mismatch. Missing attribute: 'name' | Unexpected attribute: 'name'
CSV data:
name,category,venue
Sock Creatures,Creative Corner,VVqBAy8JEYQx
TL;DR
Developers having trouble importing CSV encounter "CSV header mismatch" error due to missing or unexpected attributes like 'name'. The error message could be more informative.
**Solution:** Check CSV file for correct headers, ensure no hidden characters or extra spaces, and correct any mismatches between headers and data.After turning to python to create a script - It helped me see the error. It may be worth making the error a little more useful there as it confused me without digging into it more.
scottrobinson@Mac csvimport % uv run python3 main.py ❌ Error inserting row: {'\ufeffname': 'Sock Creatures', 'category': 'Creative Corner', 'venue': 'VVqBAy8JEYQx'}
