How SheetCombine Detects & Converts Comma CSV, European Semicolon CSV, TSV & Pipes
Understand why European Excel opens comma-separated CSV files inside a single broken column, how SheetCombine counts delimiters outside quotes, and how to switch delimiters cleanly.
Interactive Tool Included
Skip manual formulas or run this workflow directly on your file in local browser memory.
Quick Steps Overview
- 1
Paste or open any delimited file
SheetCombine removes leading UTF-8 BOM bytes () and inspects the first 5 lines of your input file or clipboard paste.
- 2
Delimiter sniffer counts unquoted separators
Using quote-aware scanning, the parser counts tabs, commas, semicolons, and pipes strictly outside double-quoted strings so addresses like "Paris, France" do not mislead detection.
- 3
Normalize cleanly and switch output format
View aligned columns immediately in the grid, clean extra whitespace or accents, and download either RFC-4180 Comma CSV, European Semicolon CSV (;), TSV, JSON, or native .xlsx.
One of the most common spreadsheet failures happens across regional settings: a US CRM exports a comma-separated CSV, and opening it on a French, German, or Spanish version of Microsoft Excel dumps every row into Column A. Here is how SheetCombine solves CSV delimiters automatically.
Quote-Aware Delimiter Auto-Detection
When you drop or paste text into SheetCombine Clean CSV, parseTextToMatrix samples up to the first five lines while tracking quote state ("..."). It counts unquoted occurrences of four separators in order:
| Detected Separator | Format Name | Typical Source |
|---|---|---|
Tab (\t) | TSV | Clipboard copy from Excel / Google Sheets |
Semicolon (;) | Semicolon CSV | French & European ERP / Excel exports |
Pipe (|) | Pipe-Delimited | Bank, healthcare, and EDI text feeds |
Comma (,) | CSV | Standard US / RFC-4180 API & Stripe exports |
Converting Directly to Semicolon CSV or Native .XLSX
Once parsed cleanly into cells, you can export directly to native .xlsx (which opens identically in every Excel locale regardless of Windows regional settings), standard Comma CSV, or Semicolon CSV inside SheetCombine FR tools and our companion Firefox/Edge extension popup.
Run It Yourself — Zero Server Uploads
Ready to process your own workbook?
Every transform runs in your local browser memory. Paste data, import .xlsx / .csv / .md, apply styles, and export clean results immediately.
Frequently Asked Questions
Why does Excel put an entire CSV row into column A in France or Europe?▼
Locales that use the comma (",") as the decimal separator (such as 12,50 EUR in France, Germany, Spain, and Italy) default desktop Excel to expecting semicolons (";") between CSV columns.
Why does counting commas inside quotes break naive CSV splitters?▼
A naive string split breaks inside values like "Acme Corp, Inc.". SheetCombine tracks quote boundaries character by character during both delimiter detection and RFC-4180 parsing.
Where can I convert French/European semicolon CSV directly?▼
Use SheetCombine French converter pages /fr/xml-en-csv/, /fr/conversion-json-excel/, or /fr/convertisseur-csv-json/, or open any file in Clean CSV to switch delimiter formats cleanly.
More Spreadsheet Guides
View All Guides →Convertir XML en CSV et Excel (FR)
Parseur XML local compatible avec le separateur point-virgule pour Excel.
Outil FRConvertisseur CSV en JSON (FR)
Detecte automatiquement virgules ou point-virgules et exporte en JSON propre.
Data CleaningFix Dropped Leading Zeros in Excel CSVs
Prevent desktop Excel auto-formatting from deleting 02134 postal prefixes.
