SPARKPOND / GUIDE
Why a CSV Opens in One Column and How to Fix It
A CSV usually opens in one column because the file delimiter differs from the delimiter expected by the spreadsheet application.
Problem symptoms
- The header appears as one long cell.
- Commas or semicolons remain visible in every row.
Why it happens
- Regional spreadsheet settings expect semicolons.
- The extension is CSV but the content uses tabs or pipes.
Example before and after
Before
name;email;country Ada;ada@example.com;FR
After
name,email,country Ada,ada@example.com,FR
Procedure
- Inspect the first rows in a text editor.
- Identify the delimiter outside quoted values.
- Open Change CSV Delimiter, confirm the source and choose the target.
- Preview columns before download.
Common mistakes
- Using global Find and Replace, which also changes punctuation inside values.
- Renaming the file without re-serializing it.
Other possible solutions
- Use the spreadsheet import dialog and choose the delimiter manually.
Important limitations
- Mixed malformed delimiters may require repairing the source rows first.
Related guides
CSV Comma vs Semicolon: Which Delimiter Should You Use?
Both formats are valid delimited text; compatibility with the destination matters more than the extension.
How to Fix UTF-8 and Windows-1252 CSV Encoding
Garbled text appears when bytes are decoded with a different character encoding from the one used to create the file.