Skip to content

CSVRefineClient-Side
Workspace

Tools

CSV Duplicate RemoverEmpty Row & Column RemoverWhitespace CleanerCSV ValidatorCSV Data ProfilerCSV FormatterCSV MergerCSV SplitterPrivacy & Processing

Language

Theme

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.

Refresh or close the tab and your cleaned dataset is gone — download your file to keep it.

Never uploadedProcessed in-memoryDiscarded when you leave

How to use it

Three steps

  1. 1Upload your CSVDrop the file onto the workspace above. The delimiter and encoding are auto-detected.
  2. 2Choose the output formatPick the output delimiter — comma, semicolon, tab or pipe — and tick the whitespace fix if needed.
  3. 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

What is csv format?
CSV — comma-separated values — is a plain-text format: one record per line, fields separated by a delimiter and quoted when they contain it. It stores values only, never styling, so a csv format file opens the same everywhere.CSV Health Check →
What is a csv file format?
The csv file format (RFC 4180) is lines of delimiter-separated fields, usually with a header row. Quotes wrap fields containing the delimiter, embedded newlines or quotes; everything else is plain text — which is why csv files are tiny and portable.CSV Formatter →
Does csv save formatting?
No — csv cannot save formatting. Bold, fonts, colours, column widths, merged cells, number formatting and formulas are not stored in a csv file. If you need those, keep an .xlsx copy and export a csv alongside it.Excel to CSV Converter →
Do csv files save formatting?
They do not. CSV deliberately has no styling concept; the colours you see after opening a csv in a spreadsheet are the spreadsheet applying its own defaults, not stored formatting.Excel to CSV Converter →
How to keep formatting in csv file?
There is no formatting to keep in csv — it never existed in the file. What you can keep is your data exactly: export a copy to csv and keep the styled .xlsx as the master. Working with a csv that looks odd? Inspect it here first.CSV Health Check →
How to save formatting in csv file?
You cannot save spreadsheet formatting in a csv file. What survives is text — including leading zeros, as long as the consumer reads the column as text. “Save as … CSV UTF-8” is the reliable choice when your app offers it.CSV Health Check →
Why does csv file not save formatting?
Because csv is a data interchange format, not a document format. It carries values between systems; layout and styling are deliberately excluded so files stay small, universal and friendly to diff and version control.CSV Formatter →
What is csv formatting?
CSV formatting usually means making a file consistent: the right delimiter, correct quoting, a clean encoding and tidy whitespace — the practical csv formatting guidelines behind this tool. The formatter is a working csv formatting example — upload your file and compare the before and after.CSV Formatter →
How to save csv with semicolon delimiter?
Export with semicolons in the source app (European Excel locales do this natively), or convert here: upload a comma file, choose semicolon as the output, and fields containing semicolons are quoted automatically.CSV Formatter →
What delimiter to use for csv?
Comma by default (RFC 4180). Use semicolon where comma is the decimal separator (most European Excel), tab when values contain many commas, pipe for log-style data. The Health Check auto-detects and names the delimiter in any file.CSV Health Check →
How to check delimiter in csv file?
The Health Check byte-sniffs the file and shows the detected delimiter (and encoding) on upload — the seven bytes rule, quote-aware. Quick manual check: open the file in a text editor and look at the separator on the first line.CSV Health Check →
How to change delimiter in csv?
Upload it — the formatter detects the current delimiter (comma, semicolon, tab, pipe or colon), lets you choose the output, rewrites quoting correctly and hands back a valid csv.CSV Formatter →
How to find delimiter in csv file?
The analysis panel displays the detected delimiter and lets you override it — essential for semicolon files that render as one long column in Excel or import as a single field.CSV Health Check →
What is a delimiter in csv file?
The delimiter is the single character separating one field from the next — comma in most csv files, semicolon, tab or pipe elsewhere. Fields containing the delimiter are wrapped in double quotes so the file still parses correctly.CSV Formatter →
What is csv delimiter?
The same character: the separator between fields. Next question people ask — how to change csv delimiter to semicolon: the formatter below does it in one click, and the Health Check names yours on upload.CSV Formatter →
How to change csv delimiter to semicolon?
Upload the file, choose Semicolon as the output delimiter in the formatter, and download. Excel in comma-decimal regions then opens every column correctly — no one-long-column problem.CSV Formatter →