4 min read
CSV opening as a single column in Excel? Comma, semicolon, and how to choose
You double-click a CSV file and instead of a clean table, everything piles up in column A. This classic isn't a bug: it's a convention gap between Excels around the world. Here's the two-minute explanation, and how ExcelifyXML handles it for you.
Why your CSV opens as a single column
In France (and much of Europe), the comma is the decimal separator: €12,50. French Excel therefore can't also use it to separate columns — it expects a SEMICOLON. An English-locale Excel expects a comma.
The result: a comma CSV opened in a French Excel (or the reverse) shows everything in one column. The file isn't broken — it just speaks the other convention.
What ExcelifyXML does by default
The generated CSV follows the site language's convention: semicolon when you use ExcelifyXML in French, comma in English. It also ships a UTF-8 BOM, the invisible marker that guarantees accented characters display correctly in Excel on double-click.
In the vast majority of cases you have nothing to do: the file opens cleanly, columns and accents included.
Changing the separator: Advanced options
- On the Upload page, drop your XML file.
- Below the selected file, click “Advanced options” to unfold the panel.
- Under “CSV separator”, pick Semicolon (;) for French/European Excel, or Comma (,) for English Excel and data tools (scripts, pandas…).
- Transform: the downloaded bundle uses your choice.
File already downloaded? Two fixes without re-transforming
- In Excel: select column A, then Data → Text to Columns → Delimited → tick the right separator. The table rebuilds without touching the file.
- In LibreOffice or Google Sheets: use the import flow (both detect or let you pick the separator on open).
What about reconstruction?
It doesn't matter: the Reconstruction page auto-detects the separator (comma, semicolon or tab) and the BOM. Whatever spreadsheet re-saved your CSV and whatever its convention, the rebuilt XML is identical.
Transform your XML with the right separator for your spreadsheet:
Transform a file