CSV fixer: make a CSV open correctly in Excel
Everything in one column, é instead of é, or numbers stuck as text? Load the CSV here, pick what's wrong, and save a copy that opens correctly — the file never leaves your device.
Drop a CSV file here, or
It's read by this page in your browser. Nothing is uploaded.
Add a file or paste text to see a preview.
How to use it
- Drop the CSV onto the box (or paste its text). The separator is detected for you.
- If accents look wrong in the preview, change the file's text encoding.
- If the numbers use the other decimal separator than your Excel, convert them.
- Choose how to save: commas or semicolons, to match your Excel — keep the UTF-8 marker on.
- Download the fixed copy and double-click it, or copy the rows and paste them into a sheet.
Why CSV files open wrong
A CSV doesn't say which separator, encoding or decimal style it uses, so Excel applies your computer's region settings. The full explanations: CSV opens in one column, garbled accents, decimal comma vs point and leading zeros.
For tables on paper
These tools fix text and files. To turn a photo of a printed table into a spreadsheet in one step — rows, columns and empty cells in place, unsure cells highlighted — use QuickScan on your iPhone. It reads the photo on the device, too.
On a computer? Point your iPhone's camera at the code to open QuickScan in the App Store.
3 free exports, then a one-time unlock. No subscription.
Questions
Is my file uploaded?
No. The page reads the file with your browser's own file reader and builds the fixed copy locally. You can load the page, switch off Wi-Fi, and it still works.
Which separator should I choose?
The one your Excel expects on a double-click: commas in the US, UK and other decimal-point regions; semicolons where the decimal separator is a comma (most of Europe).
Why convert decimals?
A file written with decimal commas (4,50) opened in a decimal-point Excel arrives as text, and the other way round. Converting makes the numbers readable as numbers in your Excel.
Does it change codes like 00123?
No. Decimal conversion only touches values that are clearly numbers; codes with leading zeros, dates and text are left as they are. Excel may still strip zeros when it opens a CSV — see the leading zeros guide.