CSV Fixer

Opened a CSV and it looks broken? Weird symbols, numbers turned into 1.2E+15, dates in the wrong order, missing leading zeros? Drop it below — we'll fix it. Nothing leaves your computer.

Drop a CSV here, or click to choose a file

Safe fixes (on by default) Trim extra spaces Fix blank / duplicate column names Remove empty rows and columns

Advanced — review before applying Turn 1.2E+15 back into the full number Restore leading zeros (pick a column) Put all dates in one format

Save with this separator Date format for the saved file Add a BOM so Excel shows accented characters correctly

Everything happens right here in your browser. Your file is never uploaded anywhere — no server ever sees it. The code is plain, unminified JavaScript: open your browser's developer tools and read every line if you want to.

Common CSV problems

Excel changed my CSV dates. Here's how to fix it.
Excel removed the leading zeros from my CSV (zip codes, IDs).