CSV Formatter
Re-delimit CSV data and pad ragged rows to a consistent column count.
Fixes two common CSV export problems in one pass: switches between comma, semicolon, tab, and pipe delimiters (useful since some locales export semicolon-delimited "CSV" by default), and pads any row that's missing trailing columns so every row has the same width.
Example: A semicolon-delimited row with output set to comma-delimited gets re-delimited to commas, and a ragged row missing a trailing column gets padded with an empty field so every row lines up.
How it works
- Paste CSV, semicolon-, tab-, or pipe-delimited data
- Pick the input and output delimiters
- Cleaned, consistently-delimited data appears instantly, on your device
Frequently asked questions
Why would a CSV file use semicolons instead of commas?
Locales that use a comma as the decimal separator (much of Europe) have Excel default to semicolon-delimited exports instead, to avoid ambiguity with decimal numbers — this tool handles both.
Is my text uploaded anywhere?
No — CSV Formatter runs entirely in your browser using JavaScript/WebAssembly. Your text is never sent to a server.
Does this remove or add quotes around fields, or just change the delimiter?
Existing quoted fields are preserved through the delimiter change; new quotes are only added where required, like a field that itself contains the new delimiter character.