CSV Formatter
Turn a ragged export into a consistent, parser-friendly CSV. The formatter re-encodes your file with the delimiter you want, normalizes quoting around fields that need it, optionally cleans whitespace, and downloads a clean, standards-compliant file.
[ Interactive Workspace ]
CSV Formatter
Upload a CSV to normalise delimiters, quoting and whitespace, then download a clean file.
100% client-side
No upload · No storage
Refresh or close the tab and your cleaned dataset is gone — download your file to keep it.
Parsing rows, detecting delimiters and profiling columns in your browser.
file.csv
Encoding notice
Data Quality Score
–
–
Points deducted from 100 for each problem found. Hover rows or see the report for details.
Columns
| Column | Type | Empty | Unique |
|---|
Detected problems & fixes
Duplicate options
Columns to match on:
Rows that will be removed (first 25):
Whitespace options
Format options
First 25 rows
Cleaning history
How to use it
Three steps
- 1Upload your CSVDrop the file onto the workspace above. The delimiter and encoding are auto-detected.
- 2Choose the output formatPick the output delimiter — comma, semicolon, tab or pipe — and tick the whitespace fix if needed.
- 3DownloadClick “Download formatted file”. Quoted fields with embedded delimiters are handled correctly throughout.
Example use cases
- Converting European semicolon-delimited exports into standard comma CSVs
- Turning a comma CSV into a tab-separated file for warehouse loaders
- Fixing files where fields with embedded commas are not properly quoted
- Normalizing a CSV exported by one tool so another tool can parse it reliably
FAQ