Separators and accents
Fix CSV separators and broken accents
A file from another country or an older system opens in one column, or its accents look like é. Table shows how it read the file, and you can read it again another way.
Open workspaceWhen this helps
Use this when every row lands in one column, when columns are split in the wrong places, or when names with accents look garbled.
For example
A task you can finish here
A semicolon-separated export from a German system, in Windows-1252: Table detects the semicolons and the encoding, shows the first lines, and saves a UTF-8 CSV with commas that Excel opens with its umlauts.
The workflow
Three clear steps
- 01
Open the file
Files shows the encoding, the separator and the quote Table detected, with the first lines as read.
- 02
Correct what is wrong
Choose another encoding or separator (comma, semicolon, tab, pipe or none); the file is read again. Repair accents fixes text that was converted twice.
- 03
Save as UTF-8
Save a CSV with commas or semicolons, CRLF line endings and a BOM so Excel reads the accents; each can be changed.
Your files and the public site
Open files only in the separate Table workspace. Its processing runs in your browser; this public site does not receive your files, their names, what they contain or any setting.Read the privacy information.
Questions
Why does Excel show one column?
Excel uses the separator of your region’s settings. Saving with the separator your Excel expects (often a semicolon in Europe) fixes it.
What are formula-like cells?
Cells starting with =, +, - or @ can run as formulas when a spreadsheet opens a CSV. Save counts them, and Make them text puts an apostrophe (') before each if you choose.
Ready to make the copy?
Your files stay unchanged.
Open workspace