Guides
CSV File Won't Import? 6 Common Causes and How to Fix Them
Run through this checklist before retyping anything by hand — one of these six is almost always the culprit.
How to Remove Blank Rows from a CSV File
Blank rows breaking your import? Remove them in Excel, Google Sheets, Python, or automatically.
How to Fix CSV Headers with Spaces and Special Characters
Turn " Client Name " into client_name — in Excel, Sheets, Python, or one click.
How to Convert a CSV File to UTF-8 Encoding
Seeing é instead of é? Fix garbled characters by converting to UTF-8.
How to Remove Extra Spaces from CSV Cells
Stray spaces breaking lookups and imports? Trim leading and trailing whitespace in Excel, Google Sheets, Python, or one click.
How to Fix CSV Files with Ragged Rows (Uneven Columns)
Rows too short or too long break every CSV import. Fix them by hand in Excel, Google Sheets, or Python — or let CSV Cleaner align them automatically.
How to Fix Numbers Stored as Text in CSV Files
Numbers that look right but break SUM, FILTER, and VLOOKUP are almost always stored as text. Fix them in Excel, Google Sheets, or Python.
Why Excel Deletes Leading Zeros from CSV Files (and How to Stop It)
Product code 00127 opens as 127. A 16-digit order ID becomes 3.48E+15. The CSV is fine — Excel mangles it on open. Import so every character survives.
Why Your CSV Shows Garbage Characters in Excel (and How to Fix It)
Café becomes Café, José turns into José. The CSV is fine — Excel is reading it in the wrong encoding. Open it so every accent survives.
CSV Cleaner — Full User Guide
Everything our $9 CSV cleaning tool does, with real examples.