Favorite places of your favorite city
Home
Add to preferred sources on Google

CSV Delimiter Converter

Preview columns, identify separator ambiguity and convert CSV or TSV without changing cell values.

Files: 5 MiB maximum. Text: 5,000,000 UTF-16 units maximum. Maximum 2,000,000 cells.

A BOM may help some importers. Copied text never includes a transport BOM.

Converted text preview

Paste text or import a CSV, TSV or TXT file.

Cell values stay strings. Quoting and outer line endings may change. Spreadsheet apps may reinterpret values on import.

How to convert CSV separators

  1. Paste CSV text or import a CSV, TSV or TXT file.
  2. Check detected columns; choose the input separator if the sample is ambiguous.
  3. Choose an output separator, inspect warnings, then copy or download the complete result.

Features

  • Detects comma, semicolon, tab and pipe separators
  • Previews columns and warns about import risks
  • Preserves cell values while exporting CSV or TSV
  • Parses quoted separators and line breaks without splitting cells
  • Supports UTF-8 and UTF-16 input with explicit BOM handling
  • Pages the preview without truncating the exported file

Use cases

  • Convert semicolon CSV for a comma-based importer
  • Inspect a file that opens in one spreadsheet column
  • Convert TSV to CSV for another application
  • Check empty cells and quoted line breaks before import

What changes during conversion

A semicolon file such as name;note and 00123;"a;b" becomes comma-separated without changing 00123 or the quoted semicolon.

Quoted separators and line breaks stay inside cells. Blank records and empty fields are retained; outer line endings and quoting may change.

Headers are optional preview labels. Duplicate or empty names remain data. CSV does not force spreadsheet text types.

Privacy and file limits

Parsing runs in your browser. Files are limited to 5 MiB and source text to 5,000,000 UTF-16 units. Output is UTF-8.

Questions about CSV imports

The spreadsheet may expect another separator. Check the preview, choose the input separator, then export with the separator your importer expects.

No. Spreadsheet apps may execute formula-like values even when quoted. This tool warns and requires acknowledgement, but leaves every value unchanged.

The CSV keeps 00123 exactly. Spreadsheet import settings may still interpret it as a number; choose a text column when importing.

JSON to CSV Converter

Convert flat JSON records to delimited text with first-seen columns, original number spellings and explicit empty-value rules.

Open tool — JSON to CSV Converter

Compare Two CSV Files

Match rows by a key column and find added, removed and changed records.

Open tool — Compare Two CSV Files

CSV Duplicate Finder & Remover

Find exact duplicate CSV rows or repeated IDs. Review conflicting values, keep original data and download retained, removed and unresolved records.

Open tool — CSV Duplicate Finder & Remover

CSV Merger

Combine rows from several CSV files by exact column name. Preview alignment and download CSV with a merge report.

Open tool — CSV Merger

CSV to JSON Converter

Convert CSV text or UTF-8 files to JSON objects or arrays, keeping cells as strings without guessing data types.

Open tool — CSV to JSON Converter

CSV Splitter

Split a CSV by rows or exact file size. Keep headers and download each part.

Open tool — CSV Splitter
View all tools in this category