Tooltivav1.0

CSV Delimiter Converter & Fixer

Change column separators between comma, semicolon, tab, and pipe. Auto-detects delimiters and preserves quoted strings.

100% Client-Side Privacy:Your files and text are processed strictly in your local browser memory. No data is ever transmitted to or stored on any server.

No tabular data to preview yet.

Paste data or upload a file to preview structured rows and columns.

The European Semicolon Dilemma

If your CSV opens in a single column in Microsoft Excel or Google Sheets, your operating system is likely configured for European regional formats. Because many European locales use commas (,) as decimal separators (e.g., 10,50 €), Excel defaults to semicolons (;) as column dividers. Converting standard comma-separated files to semicolons fixes column splitting instantly.

RFC 4180 Quote Preservation

Naive "find and replace" tools ruin data by replacing commas inside addresses, full names, and descriptions (such as "Acme, Inc."). Tooltiva uses standard RFC 4180 parsing to distinguish literal commas inside quoted strings from actual field separators, keeping your data intact.

How to Change a CSV Delimiter Online

  1. Input your file: Paste raw text or upload your CSV, TSV, or TXT file into the editor above.
  2. Verify source separator: Tooltiva automatically detects whether your file is separated by commas, semicolons, tabs, or pipes.
  3. Select target separator: Choose your desired output delimiter (e.g., Semicolon for Excel, Tab for TSV, Pipe for database ingestion).
  4. Inspect preview: Verify row counts, column alignments, and warning banners in the live Table Preview.
  5. Export result: Click "Copy Result" or "Download .CSV" to save your clean, reformatted file.

Frequently Asked Questions

Excel relies on regional operating system settings. In many European countries, the list separator is a semicolon (;) because commas are used as decimal points. If you open a standard comma-separated CSV on such a system, Excel fails to split the columns. Using Tooltiva's Delimiter Converter to change commas to semicolons resolves this instantly.

Related Utilities

CSV ⇄ JSON Converter

Two-way tabular to structured data conversion.

JSON Formatter & Auto-Fixer

Validate, beautify, and repair broken syntax.