CSV Formatter Converter
Clean up delimiters, quoting and ragged rows.
CSV
Cleaned CSV
About the CSV Formatter converter
CSV files arrive broken in predictable ways: semicolons where commas were expected, spaces after every delimiter, inconsistent quoting, and rows missing their last few columns.
This tool re-parses the file and writes it out cleanly, applying RFC 4180 quoting so the result imports without argument.
Switching delimiters
Converting semicolon-separated data to comma-separated is not a find-and-replace — any value that contains a comma has to gain quotes in the process. Because the file is parsed first, that happens correctly.
Ragged rows
A row with fewer fields than the header breaks strict importers. Padding fills the missing cells with empty values so every row has the same width.
Frequently asked questions
Does trimming affect quoted values?
Spaces outside the quotes are removed; whatever is inside them is preserved exactly.
Can I produce a TSV file?
Yes — set the output delimiter to Tab.