---
title: "Exported CSV Opens in One Column in Excel: Delimiter Fixes"
url: "https://wpimportexport.com/csv-opens-in-one-column-excel-delimiter/"
description: "Exported CSV opens in one column in Excel? Why the list separator matters, and how to export with a semicolon, tab or XLSX instead."
type: post
published: 2026-11-09T06:06:00+00:00
modified: 2026-11-14T10:42:40+00:00
categories: ["Export Guides", "Tutorials"]
tags: ["CSV import", "Import Export by RockStarLab", "WordPress export"]
docs_topics: ["Data, formats and functions", "Export guides"]
---

# Exported CSV Opens in One Column in Excel: Delimiter Fixes

You export posts or products from WordPress, double-click the CSV, and Excel puts everything into column A: `ID,post_title,post_date` in one cell, every row the same. Nothing is wrong with the data. Excel expected a different separator between the columns. [Import Export by RockStarLab](https://wordpress.org/plugins/import-export-by-rockstarlab/) can export a file that opens correctly, and a file you already have can still be opened the right way.

**Free:** CSV export with comma, semicolon, tab, pipe or a custom delimiter, and XLSX export, for posts, pages, comments and media. **PRO:** the same for WooCommerce data, users, terms and custom post types.

## Short Answer

- If your Excel uses a semicolon as the list separator (common where a comma is the decimal separator, as in Germany, France, Italy, Spain or Brazil), export with **Delimiter: Semicolon** in step 4.
- Or export to **XLSX**: an Excel workbook has no delimiter at all.
- For a CSV you already have, open it with **Data → From Text/CSV** in Excel and choose the delimiter there.

Exports only read your content, so you don’t need a backup for them.

## Why Excel shows one column

“CSV” means comma-separated values, but Excel doesn’t always split on commas. When you double-click a CSV, Excel splits each line on the **list separator** from your system’s regional settings. In regions where a comma is the decimal separator (1,5 instead of 1.5), the list separator is usually a semicolon. Excel then finds no semicolons in a comma file and leaves each line in one cell. See [how Excel’s CSV delimiter depends on regional settings](https://ablebits.com/office-addins-blog/change-excel-csv-delimiter).

The same file, comma-separated:

```
ID,post_title,post_date
1863,"How We Source Green Coffee","2026-10-14 09:00:00"
1861,"Five Single-Origin Coffees to Try This Winter","2026-10-13 09:00:00"
1857,"Meet the Team Behind the Beans","2026-10-12 09:00:00"
```

and semicolon-separated:

```
ID;post_title;post_date
1863;"How We Source Green Coffee";"2026-10-14 09:00:00"
1861;"Five Single-Origin Coffees to Try This Winter";"2026-10-13 09:00:00"
1857;"Meet the Team Behind the Beans";"2026-10-12 09:00:00"
```

Text with commas inside, such as a title “Coffee, Tea and Cocoa”, is enclosed in double quotes, so it stays in one cell with either separator.

## Fix 1: Export with the separator your Excel expects

1. Go to **Import Export → Export**, choose the content type, filters and columns as usual.
2. In step 4, choose **CSV**.
3. Set **Delimiter** to **Semicolon** if your Excel uses semicolons, or keep **Comma** if it uses commas.
4. If the file has accents or emojis, also tick **UTF-8 BOM** (see [broken characters in an exported CSV](https://wpimportexport.com/csv-utf-8-bom-excel-broken-characters/)).
5. Click **Start Export** and download the file.

![Export step 4, CSV Options: Delimiter set to Semicolon, Include Header Row checked, UTF-8 BOM unchecked](https://wpimportexport.com/wp-content/uploads/2026/11/01-delimiter-semicolon.webp)

_Semicolon for Excel with a semicolon list separator._

Other options in the same list:

- **Tab** saves a .tsv file. Google Merchant Center and many other systems expect tab-separated files; in Excel, open them with **Data → From Text/CSV**.
- **Pipe** (|) is useful for text with many commas and semicolons, for example for other systems that read the file.
- **Custom** takes any separator of up to 10 characters, such as `;;` or `|~|`, if the receiving system asks for one.

To find out which separator your Excel expects, look at a formula with several arguments: if Excel writes `=SUM(A1;B1)`, it expects semicolons.

## Fix 2: Export to XLSX

If the file is only for Excel users, choose **XLSX** in step 4. A workbook has real columns, so the regional settings don’t matter, and dates and numbers arrive as cells. For very large exports (tens of thousands of rows) CSV is lighter for the server; see [exporting a large site without timeouts](https://wpimportexport.com/export-large-wordpress-site-without-timeouts/).

## Fix 3: Open an existing CSV correctly

For a file you already have:

1. In Excel, open a blank workbook and go to **Data → From Text/CSV**.
2. Select the file. Excel shows a preview.
3. Choose the **Delimiter** (Comma, Semicolon, Tab) until the preview shows separate columns. Set **File Origin** to **65001: Unicode (UTF-8)** if accents look wrong.
4. Click **Load**.

Google Sheets asks for the separator during **File → Import** (**Separator type: Detect automatically**), so this problem is mostly an Excel one.

## Importing the file back

If someone edits the export in Excel and saves it, it may come back with semicolons. When you import it with Import Export by RockStarLab, the importer notices a file without commas in the header row and uses the semicolon, tab or pipe instead, so the preview shows the right columns. If a file mixes separators, choose the **Delimiter** in the import settings yourself.

## With an AI agent

An AI agent connected through the WordPress MCP Adapter (see [connecting Claude Code to WordPress](https://wpimportexport.com/connect-claude-code-to-wordpress-mcp/)) passes the separator in `format_options.csv_delimiter` when it calls `rsl-ie/export-start`, for example `";"` or `"\t"`. A prompt:

```
Export all published posts with ID, title and date to a CSV that opens
correctly in Excel with German regional settings, and tell me which
separator you used.
```

In our run, the agent chose the semicolon because German Excel uses it as the list separator, and added the UTF-8 BOM for umlauts. The job exported 74 posts, and the file began with `ID;post_title;post_date`.

## FAQ

### Why does the same CSV open fine on my colleague’s computer?

Their regional settings use a different list separator. A comma file opens correctly where the list separator is a comma, and in one column where it’s a semicolon.

### Which format is safest for everyone?

XLSX. A workbook opens with the same columns in every region. If it must be CSV, ask which separator the receiver’s Excel uses.

### Will a comma inside a title split the cell?

No. Text is enclosed in double quotes, so commas or semicolons inside a value stay in that cell.

### Can I change Excel’s list separator?

Yes, in the regional settings of Windows or in Excel’s options for decimal and thousands separators, but that changes it for every file and formula. Exporting with the right separator is simpler.

### Does the import read semicolon files?

Yes. It picks the separator from the header row when the file has no commas there, or you can choose it in the import settings.

## Related Guides

- [Broken Characters and Emojis in an Exported CSV: UTF-8 and BOM for Excel](https://wpimportexport.com/csv-utf-8-bom-excel-broken-characters/)
- [WordPress CSV Posts Export: Export Blog Posts to CSV, Excel, JSON, XML, and ODS](https://wpimportexport.com/wordpress-csv-posts-export/)
- [How to Export WooCommerce Products for Google Merchant Center](https://wpimportexport.com/export-woocommerce-products-google-merchant-center/)
- [Excel Shows #### or Wrong Dates, Lost Leading Zeros and Scientific Notation: Fixing an Exported CSV](https://wpimportexport.com/excel-leading-zeros-dates-scientific-notation-csv/)

Get the free plugin on [WordPress.org](https://wordpress.org/plugins/import-export-by-rockstarlab/).
