Back to blog
6 min read 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 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.

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).
  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
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.

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) 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.

Get the free plugin on WordPress.org.

Dmitriy
About author

Dmitriy

WordPress Developer with 15+ years of commercial experience. Elite Author on ThemeForest and creator of custom WordPress plugins. Passionate about clean code, performance optimization, and building useful tools for the WordPress community.

JOIN THE CONVERSATION

Comments 0

Have a question or a tip to share? Leave it below.

Leave a comment

Your email address will not be published. Required fields are marked *

We store your name, email and comment to show and moderate it; your email is never published. Spam protection is provided by Cloudflare Turnstile and profile pictures by Gravatar. See our Privacy Policy.


Try the plugin with no risks!

New users get 1 month with access to all premium features. Experience the most powerful WordPress data engine today.

Download Now
Get PRO for FREE