Repair CSV problems
Check a CSV for shifted columns, broken quotes, and duplicates
Find uneven rows, blank lines, exact duplicates, and broken quotes, then apply only the repairs you select to a new CSV.
CSV processing stays in your browserCSV data, file names, headers, and cell values are not sent outside your browser.
How it works
Repair only the problems you choose
- 1Use the number of column names to find short rows and extra columns.
- 2Stop on broken quotes without creating a partial result.
- 3Keep the original unchanged and save selected repairs in a separate CSV.
How to repair a CSV
- 1Choose a CSV and how it should be read.
- 2Review each problem, its reason, and nearby rows.
- 3Select repairs, check the counts, and save a new CSV.
Use the tool that fits the issue
Garbled text, unnecessary columns, duplicates, and oversized files each have a suitable tool.
Inspect a CSVOpen and review every row and column in the CSV.Convert encoding & formatFix garbled text or BOM issues by changing the text encoding.Select columnsRemove unnecessary columns and reorder the rest.Remove duplicatesResolve repeated IDs before comparing or importing.Split by rows or sizeSplit a file that is too large for Excel by rows or target size.
Open the right tool from this guide
After identifying the cause, inspect or compare your file locally without an upload.
Sources
CSV encoding compatibility matrixSee what the official documentation says about CSV encodings in Excel, Power Query / Power BI, Tableau, BigQuery and Google Sheets.CSV import limits databaseCSV requirements are scattered across help centers. This table puts the limits and useful pre-processing steps in one place.