Make a Parseable CSV Consistent
A file may look like a spreadsheet export but use tabs or semicolons between fields. Another may contain commas inside names or descriptions that need quotes to keep each value in one column. This formatter reads supported delimited text and writes a comma-separated CSV with consistent line breaks and quotes where the values need them.
It standardizes the file’s structure; it does not rewrite the data itself. Names, numbers, punctuation, and empty fields stay as parsed. Review the output before using it in another program.
Item;Description;Price Notebook;"Pocket, ruled";4.50 Pen;Blue;1.20
Item,Description,Price Notebook,"Pocket, ruled",4.50 Pen,Blue,1.20
The comma inside "Pocket, ruled" stays part of the description because the field is quoted. Quotes are added to output values when commas, quotation marks, or line breaks require them.
What the Formatter Normalizes
The tool detects a common separator from the first non-empty line: comma, tab, semicolon, or pipe. It then parses the records and writes them as comma-separated values, using CRLF line breaks. A TSV or semicolon-separated file therefore downloads as CSV.
Quoted fields are read as a single value even when they contain a delimiter or a line break. A doubled quote inside a quoted value is treated as a literal quote and escaped again in the output. Completely empty physical lines are skipped during parsing.
This is useful when a receiving system expects comma-separated CSV, or when you want consistent quoting before sharing a file. It does not trim spaces, normalize dates, convert number formats, or change column names.
Use the Preview to Check the Result
Drop a CSV, TSV, or text file into the upload area, select one with Browse CSV File, or paste delimited text into the box. Choose Fix CSV Formatting to create the preview. Check that the fields still line up as expected, then select Download Cleaned CSV.
The summary shows data-row and column counts before and after parsing. The preview is shortened at about 7,000 characters for long files, while the download contains the complete output. Processing happens in your browser, and the original file is not overwritten.
Know What It Cannot Repair
The input needs balanced quotation marks. If a quoted field is left open, the tool stops and shows an error instead of exporting a partial result. Correct the quote in the source text and try again.
Rows with different numbers of fields are not padded, truncated, or matched to the header. A malformed value is not inferred or corrected, and the tool does not validate a table schema. If rows must have a specific number of columns, check the result with the CSV Validator.
Keep in mind that automatic delimiter detection uses the first non-empty line. If the file mixes separators or that line does not represent the rest of the data, inspect the preview closely. This page does not offer a manual delimiter selector.
FIX CSV FORMATTING FAQ
Questions Before You Reformat a CSV
Will the output keep my original delimiter?
No. Supported comma, tab, semicolon, and pipe-delimited inputs are written as comma-separated CSV.
Does it add quotes around every field?
No. It adds quotes only when a value contains a comma, quote, or line break that needs escaping. Embedded quotes are escaped in the output.
Can it fix an unclosed quote?
No. An unclosed quoted field stops processing and produces an error. Close the quote in your input, then run the formatter again.
Will it make every row the same width?
No. It preserves each parsed row as-is and does not add or remove fields to match the header.
Can I use TSV or paste text?
Yes. Open CSV, TSV, or TXT files up to 50 MB, or paste delimited text. The result downloads as a comma-separated CSV.
Does it change values such as dates or numbers?
No. It reformats delimiters, quotes, and line endings. It does not convert dates, numbers, or other cell values.
Are my files uploaded?
No. The file is read and processed in your browser; its contents are not sent to a server.
Saving and Sharing the Reformatted File
The result is a new .csv download. Spreadsheet styling, formulas, and multiple worksheets are not part of CSV text, so use a spreadsheet format when those features need to travel with the file. Large files may take longer to process depending on your device.
Related CSV Tools
Use the CSV Validator to inspect file structure, the CSV Delimiter Converter when you need a specific output separator, or the CSV Cleaner for common data cleanup.