CSV to Excel: Fix a CSV File That Opens in One Column
Why a CSV lands in column A when you open it in Excel, three ways to split it into columns, and the leading zeros, dates and accents to check after.
- Excel
- CSV
- Reporting Workflows

On this page
You download an export from your CRM, your shop or your bank, double-click the CSV, and every row lands in column A as one long line of text with commas in it. The same question fills Excel forums, in English and in French Microsoft Tech Community. The file is fine. Excel split it with the wrong separator. The fix is to import the file instead of opening it: DataFrom Text/CSV, pick the delimiter, and load. Below are three fixes, from fastest to most durable, then the side effects that can still skew your totals.
Why does a CSV file open in one column in Excel?
Because the file uses one separator and your computer expects another. When you double-click a CSV, Excel splits each line with the list separator from your Windows regional settings. In France, Germany and much of Europe that separator is a semicolon, so a comma-separated file stays in one column.
Microsoft's own page says it plainly: when you open a .csv file, Excel "uses the current default data format settings to interpret how to import each column of data" Microsoft Support. Nothing asks you which separator the file uses. The reverse also happens. A semicolon file from a French tool opens in one column on an English-language computer.
To see which case you have, open the CSV in Notepad or TextEdit and look at the first line. If the column names are separated by commas, the file is comma-separated. If you see semicolons or tabs, that's the delimiter to pick in the fixes below.
How do you convert a CSV to Excel with the right columns?
Import it instead of opening it. On the Data tab, select From Text/CSV, choose the file and select Import. Excel previews the table and guesses the delimiter. If the preview still shows one column, pick the right one under Delimiter, then select Load.
The full routine, in a blank workbook:
- Select DataFrom Text/CSV in the Get & Transform Data group.
- Choose the file and select Import.
- Check File Origin. For a file with accents or symbols, pick 65001: Unicode (UTF-8).
- Check Delimiter: comma, semicolon, tab or custom. The preview updates as you change it.
- Check Data Type Detection. It reads the first 200 rows by default. Pick "Do not detect data types" if you have IDs with leading zeros, then set the types yourself.
- Select Load. To save it as an Excel file, use FileSave As and pick Excel Workbook (.xlsx).
Power Query, the engine behind this dialog, tries to infer the delimiter and supports comma, semicolon, tab, colon, space, equals sign and custom delimiters Microsoft Learn. The file stays linked to the workbook. When you get next month's export, save it over the old one and select DataRefresh All. To stack several monthly files, read how to merge Excel and CSV files with Power Query.
How do you split a column that's already open?
Use Text to Columns. Select column A, then DataText to Columns, choose Delimited, tick the separator the file uses, and select Finish. This works on data that is already in the sheet, and it is the quickest fix for a one-off file.
Step 3 of the wizard matters more than it looks. It lets you set each column's format to General, Text or Date before the split Microsoft Support. Set an ID or postcode column to Text there, or Excel drops its leading zeros.
Text to Columns has two limits. It writes over the columns to the right of your selection, so insert empty columns first if there is data there. It also has no memory. Next month you repeat every click, which is why the import route above is better for a file you get every month.
Should you change the list separator in Windows?
Only if every CSV you handle uses the same separator. In Windows 11, search for Region settings, open the additional settings and type a comma in the List separator box. Microsoft warns that after this change, all programs use the new character Microsoft Support.
That is the catch. In a French or German setup, the semicolon list separator lives alongside the comma as decimal separator. Change one without the other and formulas, other programs and the CSV files you save can change behavior. A colleague with default settings then opens your exports in one column. Importing through DataFrom Text/CSV fixes the file without touching the computer, so try that first.
What else goes wrong when you open a CSV in Excel?
Even when the columns split, Excel converts some values as it opens the file. Leading zeros vanish from IDs and postcodes, long numbers turn into scientific notation, and codes that look like dates become dates. Accents can also break when the file is UTF-8 and Excel reads it with another character set.
Four checks after any CSV import:
- Leading zeros. In the From Text/CSV import, pick "Do not detect data types" (step 5 above) and the zeros stay. For a CSV you open or paste, Excel for Microsoft 365 and Excel 2024 let you turn off "Remove leading zeros and convert to number" in FileOptionsDataAutomatic Data Conversion. That setting doesn't change Power Query imports Microsoft Support. The same panel controls long numbers and date-like values.
- Long numbers. Excel keeps 15 digits, so a 16-digit card or order number loses its last digits. Import that column as Text Microsoft Support.
- Dates. A UK export read with US settings turns 22/03/2026 into text or an error. In the import, set the column type with the locale it was made in.
- Totals. Compare the row count and one total in Excel with the source tool. A mismatch often means a separator inside a field, such as a comma in an address that was not quoted.
In Google Sheets, FileImport lets you choose the separator (detect automatically, tab, comma or custom) before the data lands in the sheet Google Docs Editors Help.
Where does Glow Reports fit?
Glow Reports takes the CSV file as you upload it, without opening it in Excel first. It detects whether the file uses commas, semicolons or tabs, so an American export and a French one both arrive in columns. You upload one or several CSV or Excel files and ask for the report in plain language.
The AI writes the SQL that reads and counts the rows, builds the charts and drafts the text. The SQL sits under each figure, so you can check that an ID column was kept as text or that every row was counted, and edit the query if not. Reports export to PDF and stay in the workspace. The free plan gives 300 credits once, and a report costs 100 credits.
If the CSV is the start of a monthly routine, read why monthly reports in Excel eat your week.
Common questions
How do I open a CSV file in Excel without losing the columns?
Don't double-click it. Open a blank workbook, select DataFrom Text/CSV, pick the file, check the Delimiter in the preview and select Load.
Why does my CSV use semicolons instead of commas?
The tool that made it follows a regional setting where the comma is the decimal separator, as in France. A semicolon keeps the decimals intact. Pick Semicolon as the delimiter when you import it.
How do I convert a CSV to Excel for good?
Import it with DataFrom Text/CSV, check the columns, then select FileSave As and choose Excel Workbook (.xlsx). The .xlsx file keeps the columns and the formats.
Do I need Excel to use Glow Reports?
No. You upload the CSV or Excel file as it is and ask for the report. Check the SQL under the first figure to confirm the columns were read as you expect.
I am a product engineer and the founder of Glow Reports. I spent more than 6 years building products in tech, data and cybersecurity, for large groups, startups and SMEs. In most organizations I saw data treated as a technical topic, when it drives business decisions. I built the reporting tool I was looking for, so the people who run small and mid-sized organizations can read their own numbers without a data team.
More from El Mehdi BenaneUpload your CSV or Excel files to Glow Reports and get a report with the SQL behind each figure.
Keep reading
Ad Hoc Reporting Requests: How to Cut the Queue So Business Teams Answer Their Own QuestionsEl Mehdi Benane, 4 min read
How to Calculate Days Between Two Dates in Excel, and Fix DATEDIF #NUM!El Mehdi Benane, 4 min read
XLOOKUP vs VLOOKUP vs INDEX MATCH: Which One to Use on Your ExportsEl Mehdi Benane, 4 min read