Fixing Broken CSVs: A Practical Cleanup Checklist

CSV files are simple in theory and chaotic in practice. A single extra comma, mismatched quotes, or missing value can break imports and corrupt datasets. This checklist helps you repair CSVs quickly and safely, using repeatable steps that work across spreadsheets, exports, and logs.

Step 1: Confirm the delimiter

CSV technically means comma-separated, but many exports use semicolons or tabs. Open a sample and identify the most consistent delimiter. If it varies, normalize it with the Change CSV Delimiter tool.

Step 2: Fix inconsistent quotes

Quotes are often the source of column drift. If some rows use double quotes and others do not, standardize them. You can remove quotes entirely with Remove CSV Quotes or enforce them withAdd CSV Quotes.

Step 3: Detect missing columns

Uneven column counts cause downstream failures. Use Find Incomplete CSV Records to identify broken rows, then fix them with Fill Incomplete CSV Records.

Step 4: Normalize whitespace

Leading and trailing spaces turn into hidden data quality issues. Trim columns withTrim CSV Columns to ensure values match exactly in lookups and joins.

Step 5: Validate the final file

Run a final check using CSV Validator. You want every row to have the same number of columns and consistent quoting rules.

Recommended cleanup order

• Detect delimiter
• Normalize or remove quotes
• Find and fill incomplete rows
• Trim columns
• Validate

When to convert CSV to another format

If the data contains nested objects or arrays, CSV will be fragile. Consider converting to JSON using CSV to JSON to preserve structure and prevent data loss.