Why Your CSV File Shows in One Column (and How to Fix It)

You double-click a CSV file. Excel opens it. Every row is squashed into column A. The data’s there, but it’s unusable. Sound familiar?

This is the most common CSV problem on the internet. The cause is almost never the file — it’s a mismatch between the file’s delimiter and Excel’s expected delimiter. Here’s why it happens, and three ways to fix it.

The cause: locale mismatch

CSV stands for “comma-separated values,” but Excel doesn’t actually require commas. It uses your operating system’s list separator setting, which depends on your region:

• US, UK, Australia, India: comma ,
• France, Germany, Spain, Italy, Brazil: semicolon ;
• Some custom corporate setups: tab \t or pipe |

If your file uses commas but Excel expects semicolons (or vice versa), Excel reads the entire row as a single field. Hence: one column.

Fix #1: Convert the delimiter (fastest)

Drop your file into our free CSV delimiter converter. It auto-detects the current delimiter, you pick the one Excel expects, and you download the fixed file. Twenty seconds, no install.

Fix #2: Use Excel’s import wizard

Instead of double-clicking the file, open Excel first, then:

1. Go to Data → From Text/CSV.
2. Pick your file. Excel previews it and shows the detected delimiter.
3. If the preview looks wrong, change the delimiter dropdown.
4. Click Load.

The wizard ignores your locale setting and uses whatever you choose. Slower but doesn’t require any conversion.

Fix #3: Change your system list separator

Permanent fix if you frequently work with files of one specific format:

• Windows: Control Panel → Region → Additional settings → List separator. Change to comma or semicolon as needed.
• Mac: System Settings → Language & Region → Region.

Restart Excel after the change. Beware: this affects every CSV opened on your machine.

Bonus: how to avoid it in the future

If you generate CSVs yourself, save them with the explicit format CSV UTF-8 (Comma delimited) (*.csv) in Excel — not just “CSV”. The explicit version uses commas regardless of locale, so your files open consistently anywhere in the world.