Tools
CSV Fixer: CSV Opens in One Column
Drop a CSV that Excel shows in one column or with garbled accents. See the detected delimiter and encoding, why Excel gets it wrong, and download a corrected file. Your data stays on your device — nothing is uploaded.
Drop a CSV file here
or
Your file stays on this device: it is read and fixed in your browser and never uploaded.
Why a CSV opens in one column
A CSV file is plain text, and Excel has to guess two things before it can show it as a table: which character separates the columns, and which encoding turns the bytes into letters. Excel does not look at the file to decide. It uses the list separator from your Windows regional settings (a comma in the US and UK, a semicolon in Germany, France and much of Europe) and, for a file without a byte order mark, your old ANSI code page.
So a semicolon file from a European system lands entirely in column A on an English PC, a tab-separated export does the same, and a UTF-8 file without a BOM turns é into é. Files saved by older Windows programs in Windows-1252 show � in Google Sheets and on a Mac, and UTF-16 exports confuse almost everything.
This tool reads the raw bytes, detects the encoding (UTF-8, UTF-8 with BOM, Windows-1252, UTF-16 LE/BE) and the delimiter (comma, semicolon, tab or pipe), shows the table it found, explains in plain words what would go wrong, and writes a corrected copy. Quoted cells keep their commas, quotes and line breaks, ragged rows stay as they are, and nothing is changed without a visible warning.
Everything runs in your browser. The file is never uploaded, so it is safe to use with customer lists, invoices and other private data. Large files (100,000 rows, 10 MB and more) are processed in a background worker so the page stays responsive.
Worked example
A European export with semicolons, decimal commas and Windows-1252 accents, before and after fixing with the default "Excel, comma regions" settings (UTF-8 with BOM, comma, CRLF).
Product;Price;Qty
Crème brûlée;4,50 €;3
Gadget, large;12,25 €;10Excel on an English PC puts each line in column A and shows the accents as junk.
Product,Price,Qty
Crème brûlée,"4,50 €",3
"Gadget, large","12,25 €",10Cells that contain a comma are quoted, so the decimal commas stay inside their cells.
import csv
with open('orders-fixed.csv', newline='', encoding='utf-8-sig') as f:
for row in csv.reader(f):
print(row)utf-8-sig skips the BOM; newline="" keeps line breaks inside quoted cells intact.
Frequently asked questions
Why does my CSV open in one column in Excel?
The file uses a different separator from your Excel list separator. A semicolon or tab file opened on a PC set to commas (or a comma file on a PC set to semicolons) is not split, so each row lands in column A. Convert the delimiter here, or change the list separator in your regional settings.
Why do accents show as é or � in Excel?
The encoding was guessed wrong. Excel reads a UTF-8 file without a byte order mark as ANSI, which turns é into é, while a Windows-1252 file read as UTF-8 shows �. Saving as UTF-8 with BOM makes Excel read accents correctly.
Which settings should I pick for Excel?
UTF-8 with BOM, CRLF line endings and the delimiter that matches your Excel list separator: comma in the US and UK, semicolon in most of continental Europe. The two Excel buttons above the output settings set exactly that.
Is my file uploaded anywhere?
No. The file is read and converted in your browser, in a background worker. Nothing is sent to a server, and closing the tab discards it.
What happens to commas, quotes and line breaks inside cells?
They are kept. Quoted cells are parsed by the CSV rules (RFC 4180), so a comma or line break inside quotes stays in the cell, and quotes are doubled again when the file is written.
What if a character cannot be saved in Windows-1252?
Windows-1252 has no emoji and no non-Latin scripts. If you choose it and the data contains such characters, the tool tells you how many and where, and writes them as ?. Choose UTF-8 to keep them.