CSVCSV Dock

CSV guide

Fix a CSV That Opens in One Column in Excel

When Excel puts an entire CSV row in column A, the file often uses a different delimiter from the one Excel expects. Regional settings commonly make semicolon-delimited and comma-delimited files behave differently. Detecting the actual separator and checking quoted values is safer than replacing every comma or semicolon as plain text.

Detect the CSV delimiter

Step by step

  1. Open the CSV in the viewer and note the detected delimiter and column count.
  2. If the preview still shows one column, try comma, semicolon, tab and pipe manually until the expected headers appear.
  3. Inspect a row containing punctuation or quoted text to confirm that delimiters inside a value remain in one cell.
  4. Export a repaired CSV with the delimiter required by Excel or import the original through Excel's From Text/CSV workflow and choose that delimiter explicitly.

Check the result

  • Compare the previewed header count with the number of columns expected from the source system.
  • Check at least one quoted value containing a comma, semicolon or line break before accepting the parse.
  • Reopen the exported file in the target Excel environment because regional list-separator settings can differ between computers.

Common pitfalls

  • Changing the filename extension does not change the delimiter stored in the file.
  • A global find-and-replace can corrupt delimiters that legitimately occur inside quoted values.
  • The Excel-specific sep= hint may be interpreted as a data row by other CSV consumers.

Download the example

The public sample contains synthetic data only. Download the test input and open it in the linked tool.

Expected outcomes and file checksums are published in the versioned CSV edge-case dataset.

Privacy boundary

Files selected in the workbench are processed locally. A public URL is requested directly by the browser and must permit cross-origin access. No server proxy is used by the MVP.