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.

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.

SMS Character Counter & Segment Calculator

See how your message is encoded, where its segments end and what it may cost. Your text stays in your browser.

Open toolSMS Character Counter & Segment Calculator

Social Media Character Counter

Check platform-specific limits and split posts without losing text.

Open toolSocial Media Character Counter

Character Counter

Count characters, words, sentences and paragraphs. Check word density, reading time and UTF-8 size, all in your browser.

Open toolCharacter Counter

Text Size Calculator

Compare text encodings and payload sizes in your browser.

Open toolText Size Calculator

PDF Text Cleaner

Fix line breaks and spacing in text copied from a PDF. Preserve your original and review ambiguous hyphens before copying the cleaned text.

Open toolPDF Text Cleaner

Fancy Text Converter

Convert supported fancy Unicode letters to normal text locally. Keep case, accents, emoji and your original text.

Open toolFancy Text Converter

Garbled Text Fixer

Fix garbled text and repair broken accents with a browser-based mojibake fixer. Review each possible UTF-8 reversal before applying it.

Open toolGarbled Text Fixer

Gmail Clipping Checker

Measure email HTML bytes in UTF-8, compare them with an advisory 102,000-byte Gmail reference, and inspect size contributors locally.

Open toolGmail Clipping Checker

Compare Two CSV Files

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

Open toolCompare Two CSV Files