CSV Tools
CSV Formatter
Normalize a CSV export without changing its cell values. The formatter writes consistent quoting and record line endings after checking headers and row widths.
✓ Every tool runs in your browser. We do not upload your input or output.
Keyboard shortcuts
Ctrl/⌘ + Enter: process
Ctrl/⌘ + Shift + F: full screen
Esc: exit full screen
Ctrl/⌘ + F in editor: search
How to use
- Paste a CSV table, upload a .csv file, or load the sample.
- Select the input delimiter: comma, semicolon, or tab.
- Review the normalized output and fix any reported header, quote, or row-width error.
- Copy or download the resulting CSV when the table looks correct.
Examples
Normalize a short export
Unneeded quotes are removed, a comma inside a cell stays quoted, and record endings become consistent.
name,notes "Avery","one,two" Morgan,ready
name,notes Avery,"one,two" Morgan,ready
Format semicolon-separated data
The selected delimiter is used for both parsing and output.
id;label 1;"A;B"
id;label 1;"A;B"
Clean up a table for review
CSV files from different systems often use different line endings and quoting styles. Some exports quote every cell, while others quote only cells that need it. That variation can make a diff noisy even when the data is unchanged. The CSV formatter parses the table and writes it with a consistent rule: a cell is quoted when it contains the selected delimiter, a quotation mark, or a line break. Quotation marks inside a quoted cell are doubled.
Choose the delimiter before processing. Commas, semicolons, and tabs are supported. The tool does not guess which one your file uses because a wrong guess can still produce text that looks plausible. Confirm that the output header has the number of columns you expect. The formatter checks unique, nonempty headers and requires every data row to have the same number of fields.
Review the result before importing
Formatting changes the representation of a table, not the meaning of its cells. For example, "Avery" may become Avery, while "Avery, Jr" stays quoted. Blank physical lines between records are skipped. Record endings are normalized to CRLF, and a UTF-8 byte order mark at the start is omitted. These changes can help make an export easier to compare or pass to another tool.
CSV has no built-in type declarations. An identifier such as 0012 stays as four characters in the output, but a spreadsheet may later display it as a number. Check the destination’s import settings when exact text matters. The formatter runs in your browser, and the input and output panels keep their height even for a large file.
Frequently asked questions
Will formatting change my data values?
Cell text is preserved. The formatter may remove unnecessary quotes, normalize record endings, and omit blank physical lines.
Can it switch a comma file to semicolons?
The delimiter selector describes the input and output format together. It does not infer or translate between delimiters.
Does it accept multiline cells?
Yes. A line break inside a quoted field remains part of that cell.
Why does a short row fail?
Every data row must have the same field count as the header. The error points to the row's starting line.
Does it add missing headers?
No. Supply one nonempty, unique name per column before formatting.