Notes on cleaning CSV files
Short, specific guides for the problems that show up in real exports. The cleaner itself stays on the home page and the tool pages.
2026-09-02 · 8 min
How to clean a CSV file
A practical sequence for inspecting a CSV, previewing cleanup, and downloading a new file without changing the original.
2026-09-08 · 7 min
How to remove duplicate rows in a CSV
Remove exact duplicate CSV rows while keeping the first or last copy, and avoid treating similar rows as the same.
2026-09-12 · 7 min
How to fix CSV encoding problems
Tell UTF-8 from Windows-1252, recognize the replacement character, and re-read a CSV without damaging accents.
2026-09-16 · 8 min
Why Excel changes CSV values
Why Excel drops leading zeros, rewrites dates, and shortens long IDs when it opens a CSV, and how to check the text first.
2026-09-20 · 6 min
How to handle missing data in a CSV
Tell empty cells from empty rows, see which columns are blank, and avoid filling values you do not actually know.
2026-09-24 · 8 min
What is CSV formula injection?
How spreadsheet formula injection works, what CleanCSV's opt-in prefix does, and the cases it does not cover.
2026-09-28 · 6 min
CSV vs TSV: what is the difference?
CSV and TSV are the same idea with a different delimiter. Here is when a tab is the better export and how quoting still applies.