CSV opens in one column in Excel: how to fix the delimiter

What you see

You double-click a .csv file and Excel shows every row squeezed into column A: "name;city;amount" in one cell, with the separators still visible. Sorting and formulas are useless, and Text to Columns is the only thing that seems to help. The file is fine; Excel just split it on the wrong character.

Why Excel puts a CSV in one column

A CSV file has no header that says which character separates the fields. "Comma-separated" is the name, but Excel does not look for commas: when you double-click a .csv it uses the list separator of your Windows region. In countries that write decimals with a comma (most of Europe, and several Arabic locales) that separator is a semicolon, so a file with commas lands in one column. The reverse happens too: a file exported with semicolons opens in one column on an English PC.

Tab-separated files (.tsv and .tab) and pipe-separated exports hit the same wall, because Excel only splits them if you go through the import dialog.

Fix 1: let the viewer detect the separator, then save a copy Excel understands

OpenAnyDoc reads the file in your browser and nothing is uploaded:

• Open the CSV viewer and drop the file on the page. The delimiter (comma, semicolon, tab or pipe) is detected for you, and the status bar at the bottom shows which one it found. If the columns still look wrong, click the delimiter in the status bar and pick another.
• Press Download, or choose "Download options" in the More menu to pick the delimiter yourself: semicolon for a PC that writes decimals with a comma, comma for one that uses a point.
• Double-click the downloaded copy. Excel now splits it where you expect. For a .tsv or .tab file use the TSV viewer, which does the same with tabs.

Fix 2: import instead of double-clicking

In Excel go to Data, then Get Data, From File, From Text/CSV (older versions: Data, From Text). The preview shows the data with a Delimiter box: choose comma, semicolon, tab or a custom character, then Load. Excel reads the file correctly every time, but you have to do it for every file, and the result is a workbook, not the CSV itself.

If the data is already in one column, select it and use Data, then Text to Columns, choose Delimited, tick the separator, and finish. That fixes the sheet in front of you without reopening the file.

Fix 3: tell Excel the separator inside the file

Excel honours a first line that reads sep=; (or sep=, sep=| and so on). Add it above the header and Excel splits the file on that character when double-clicked. It is an Excel-only trick: other programs show the line as data, so use it for files meant only for Excel.

The lasting fix for one PC is the region setting: Windows Settings, Time & language, Language & region, Administrative language settings, Additional settings, List separator. Change it only if every file you open uses the same separator.

Quotes, line breaks and numbers

A field that contains the separator itself, a line break or a quote must be wrapped in double quotes ("Riyadh, KSA"), with inner quotes doubled. A file that does this correctly survives any of the fixes above; one that does not will also break in the viewer, which then shows the uneven rows so you can see where. Leading zeros (postal codes, IDs) are a separate problem: Excel drops them when it guesses a number, while the viewer keeps them as written.

Still in one column?

Write to support@openanydoc.com and paste the first two lines of the file (no personal data). The separator is usually visible right there.