Can it convert between comma, semicolon, and tab delimiters?

Yes. Select the input delimiter and the desired output delimiter to reformat the CSV. This is useful for converting European semicolon CSVs to standard comma CSVs.

What does "normalise whitespace" do in CSV?

It trims leading and trailing spaces from each field value. This is useful when CSV data was exported with extra padding spaces.

What validation does it perform?

The formatter checks that all rows have the same number of columns as the header row and flags any rows that have too few or too many fields.

CSV Formatter Tool

The CSV Formatter cleans and standardises CSV data — normalise whitespace in fields, ensure consistent quoting, change the delimiter from comma to semicolon or tab, and validate that all rows have the same column count. Useful before importing CSV into databases or spreadsheet applications.

CSV Input

Input delimiter

Output delimiter

Trim whitespaceQuote all fields

Clean and standardise CSV files before import to avoid parsing errors and column mismatches.

Frequently Asked Questions

Related Tools

Markdown to HTML

Convert Markdown to HTML instantly.

HTML to Markdown

Convert HTML markup to clean Markdown syntax.

CSV to JSON

Convert CSV data into a JSON array of objects.

JSON to CSV

Flatten a JSON array of objects into a CSV spreadsheet.

XML to JSON

Convert XML documents to a JSON representation.

JSON to XML

Convert a JSON object or array to an XML document.