How to clean a CSV without spreadsheet formula risks
CSV is simple until a file moves between spreadsheets, exports, and scripts. Extra spaces, duplicate rows, inconsistent headers, and missing values can quietly turn one column into several different fields.
What a safe cleanup can automate
CSV Cleanup detects comma, tab, semicolon, and pipe-delimited files; trims cells; normalizes headers to stable lowercase identifiers; turns common empty-value labels into blank cells; and removes exact duplicate rows. It changes only unambiguous dates such as 2026/09/06 to ISO format.
Spreadsheet safety
A CSV cell beginning with =, +, -, or @ can become a formula when a spreadsheet opens it. The tool prefixes those cells with an apostrophe so a download is data, not a command.
Limits
- Input
- 48 KB of UTF-8 CSV text
- Rows
- 1,000 data rows
- Columns
- 100
- Storage
- Processed only in the request
It refuses mismatched row widths and duplicate normalized headers rather than guessing how to align data.
Clean a CSV now or read how Operloom credits work.