Fix Your CSV Error

Free, tested fixes for the exact error message you're stuck on right now, not a rephrased copy of the official docs. Find your software below, or search the error text on this page.

Looking for general best practices instead of a specific error? See the CSV guides.

Free tool

Not sure what's wrong? Paste your CSV into the Linter

Get a line-by-line syntax report, field-count mismatches, unclosed quotes, BOM, mixed line endings, in seconds. No upload, no sign-up.

Open CSV Lint

Spreadsheets

Excel: Accented Characters Broken (UTF-8)

"José" shows up as "JosÃ©". Why it happens and the free fix.

Fix It

Excel: CSV Opens in a Single Column

Wrong delimiter detection. Fix it without touching your Windows region settings.

Fix It

Google Sheets: Columns Misaligned / Everything in Column A

Unescaped quotes and delimiter mismatches, diagnosed and fixed.

Fix It

Python / Pandas

pandas.errors.ParserError: Expected X Fields, Saw Y

The exact cause of ragged CSV rows, and the on_bad_lines fix.

Fix It

Ecommerce & Import Tools

Shopify: CSV Import Failed, Error on Line 1

Invisible BOM characters, curly quotes, and mixed line endings.

Fix It

Notion: CSV Import Creates Duplicate Rows

Why "Import" always adds rows, and how "Merge with CSV" fixes it.

Fix It

BI & AI Tools

Power BI: Legacy CSV Import Deprecated (2026)

What changes, and how to fix type-detection errors in the new experience.

Fix It

ChatGPT: CSV Upload Failed or Won't Load

File size and token limits, and how to split a large CSV so it actually works.

Fix It