CSV File Opens in One Column in Excel? Here's the Fix

You double-click a CSV, Excel opens it, and every row's data is jammed into column A as one long comma-filled string. The file isn't broken, your data is fine. Excel is just reading it with the wrong separator. Here's why it happens and three ways to fix it.

Why Excel Crams Everything Into One Column

When you double-click a CSV, Excel splits columns using the list separator from your Windows Regional settings, not necessarily the comma in the file. In North America that separator is usually a comma, but in many European locales it's a semicolon. If the file uses commas and your Excel expects semicolons (or vice versa), Excel never finds a separator it recognizes and dumps the whole row into one cell.

Fix 1: Text to Columns (Quickest)

If the file is already open with everything in column A, select that column, then go to Data > Text to Columns. Choose Delimited, click Next, tick the delimiter your file actually uses (usually Comma), and click Finish. Excel splits the data into proper columns instantly.

Fix 2: Import With Get Data (Most Reliable)

Instead of double-clicking the file, open a blank workbook and use Data > Get Data > From Text/CSV. Excel shows a preview where you can explicitly set the delimiter and the file's encoding before importing. This avoids the regional-settings guesswork entirely and is the most dependable method for files from other systems.

Fix 3: Set the Separator Inside the File

Excel honors a special hint on the first line of a CSV. Open the file in a plain text editor and add a separator declaration as the very first line, above the headers.

sep=,
name,email,total
Jane Doe,jane@example.com,42.00

# Use sep=; if your file is semicolon-delimited

The Faster Way: Normalize the Delimiter First

If you're constantly fighting comma-versus-semicolon files, normalize them up front. PipeSheets detects the delimiter automatically and exports a clean, standard comma-delimited UTF-8 CSV that opens correctly in Excel, Google Sheets, and any import wizard, no Text to Columns dance required.