CSV file opens in one column in Excel: why, and how to fix it
Short answer
Excel splits a CSV on your region's list separator — a semicolon in most decimal-comma countries, a comma elsewhere. When the file uses the other one, every row lands in column A. Fix it by importing instead of double-clicking (Data › From Text/CSV, then pick the delimiter), by splitting with Text to Columns, or by converting the file once with the free CSV fixer, which runs in your browser.
Why does everything land in column A?
CSV means “comma-separated values”, but there is no single standard separator. When you double-click a CSV, Excel doesn't look at the file to decide: it uses the list separator of your computer's region. Where the comma is the decimal separator — Germany, Poland, France, Italy, Spain, Brazil and many others — the list separator is a semicolon, because 4,50 already uses the comma. A file written as Item,Price then has no semicolons to split on, and each line stays whole in the first column.
The same happens the other way round: a semicolon file from a European system, opened in the US or UK, also lands in one column.
How to tell which separator a file uses: open it in a plain-text editor (Notepad, TextEdit, or the Files app's preview). Commas between values mean a comma file; semicolons mean a semicolon file.
Fix 1: import instead of double-clicking
Importing lets you choose the separator, so it works for any file:
- Excel for Windows (Microsoft 365, 2016 and later): Data › From Text/CSV, pick the file, choose the Delimiter in the preview (Comma, Semicolon, Tab), check the File Origin is 65001: Unicode (UTF-8), then Load.
- Excel for Mac (Microsoft 365): Data › Get Data (Power Query) › From Text/CSV, pick the file, choose the delimiter, then Load. Older Mac versions: File › Import, choose CSV file and Delimited.
- Google Sheets: File › Import › Upload; under Separator type choose Detect automatically or the right one.
- Numbers on a Mac: open the file; if it lands in one column, select the table and choose Format › Adjust Import Settings to pick the delimiter.
Importing also lets you set a column's type to Text before it loads, which protects codes with leading zeros (see leading zeros and barcodes).
Fix 2: split what's already in column A
If the file is open and everything sits in column A: select column A, choose Data › Text to Columns, pick Delimited, tick the separator the file uses (Comma or Semicolon), and finish. Values in quotes that contain the separator are kept together.
Fix 3: make the file open right on a double-click
- Convert the separator: the free CSV fixer reads the file in your browser — nothing is uploaded — detects its separator and saves a copy with commas or semicolons, plus a UTF-8 marker so accents show correctly.
- Add a
sep=line: a first line readingsep=,(orsep=;) tells Excel the separator for that file. Other apps show it as a row, so use it only for files meant for Excel.
Fix 4: change the Windows list separator (last resort)
On Windows, the List separator is in Control Panel › Region › Additional settings…. Changing it to a comma makes every comma CSV open in columns — but it applies to every program, and Excel will then also save CSV files with commas. Prefer fixes 1–3.
When the CSV came from QuickScan
QuickScan writes its CSV for the region your iPhone is set to: semicolons where the decimal separator is a comma, commas elsewhere, with a UTF-8 marker so accents survive. Opened on a computer set to the same region, it splits correctly. If the computer uses a different region, import it (fix 1) — or export Excel (.xlsx) instead: an .xlsx file has no separator at all, so it can't land in one column. See CSV or Excel: which to export.
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
Why does my CSV open in one column in Excel?
Excel splits a CSV on your region's list separator. In regions where the decimal separator is a comma (most of Europe, much of South America), that separator is a semicolon — so a comma-separated file isn't split and every row lands in column A.
How do I open a CSV with columns automatically?
Use Data > From Text/CSV (Windows) or Data > Get Data > From Text/CSV (Mac, Microsoft 365) and choose the delimiter, or convert the file to your region's separator once with a CSV fixer. Double-clicking always uses the region's separator.
Does 'sep=,' on the first line work?
In Excel, yes: a first line of sep=, or sep=; tells Excel the separator for that file. Other apps (Numbers, Google Sheets, databases) treat it as an ordinary row, so only use it for files meant for Excel.
Will changing the Windows list separator fix it?
Yes, but for every program on the computer, and it changes how Excel writes CSV files too. Importing with From Text/CSV, or fixing the one file, is usually safer.