Data Import & Export

Fix Excel CSV Opens as One Column When Imported into Outlook

Camila MilosovichCamila Milosovich Nov 13, 2026 869 views

Question details

The user needs to export a CSV from a spreadsheet application that Outlook can map correctly instead of showing all contact fields in one column.

Fix Excel CSV Opens as One Column When Imported into Outlook
Product
WPS Office Spreadsheet / Microsoft Excel
Device & OS
not provided
Scenario
The user is preparing a contact list CSV in a spreadsheet and importing it into Outlook, but Outlook cannot map the contact fields.
Observed behavior
Outlook displays all CSV data in a single column because the spreadsheet exports a semicolon-separated CSV instead of a comma-separated CSV.
Before you start

Before changing separator settings, note your current decimal and thousands separators so you can restore them after the export.

Solution 1Recommended

Change the CSV separator in WPS Office Spreadsheets before exporting

Use this solution when the exported CSV opens as one column in Outlook because WPS Office wrote semicolon separators instead of commas.

CSV separators often follow Windows regional settings. If your region uses a comma as the decimal separator, spreadsheet applications may export semicolon-separated CSV files, which Outlook cannot map correctly.

1
Open the contact list in WPS Office Spreadsheets

Open the workbook containing the contacts or source data in WPS Office Spreadsheets.

2
Open Options and locate the separator settings

Click the Menu button in the upper-left corner, choose Options, and open the General and Save or Advanced section that shows decimal and thousands separators.

3
Set decimal and thousands separators

Clear the Use system separators check box, set the Decimal separator to a period (.) and the Thousands separator to a comma (,).

4
Export the CSV again

Go to Menu > Save As, choose CSV (Comma delimited) (*.csv) as the file type, enter a file name, and save the file.

5
Restore the original separator settings

Return to Options and re-enable Use system separators so other spreadsheets and applications keep their regional defaults.

Change the CSV separator in WPS Office Spreadsheets before exporting
Outlook import works: Outlook should now map the contact fields correctly because the CSV uses comma separators.
WPS Office Spreadsheet

Fix CSV separator issues for Outlook with WPS Office Spreadsheets

WPS Office Spreadsheets lets you adjust the CSV separator, export Outlook-compatible comma-delimited contact files, and reopen or edit Excel workbooks without disrupting your import workflow.

  1. 1. Open the contact list in WPS Office Spreadsheets: Launch WPS Office Spreadsheets and open the workbook containing the contacts or source data.
  2. 2. Adjust the separator settings: Click Menu > Options, clear Use system separators, set Decimal separator to period and Thousands separator to comma.
  3. 3. Export the file as comma-delimited CSV: Click Menu > Save As, choose CSV (Comma delimited) (*.csv), and save the file.
  4. 4. Import the CSV into Outlook: Open Outlook, start the Import and Export wizard, select the saved CSV, and map the contact fields.
  5. 5. Restore your previous separator defaults: In WPS Office Spreadsheets, return to Menu > Options and re-enable Use system separators.
Exports Outlook-compatible comma-separated CSV files with the correct separator.Keeps full compatibility with Microsoft Excel XLSX and CSV formats.Free, lightweight, and familiar Office-style spreadsheet editing.Lets you restore regional separator defaults after the export.
microsoft office alternative - wps office

Frequently Asked Questions

Why does my Excel CSV open as one column in Outlook?

Outlook expects a comma-separated CSV, but your regional settings may make Excel or WPS Office write a semicolon-separated CSV, so all fields remain in one column.

How do I change the CSV separator in WPS Office Spreadsheets?

Click the Menu button in the upper-left corner, choose Options, locate the separator settings, clear Use system separators, set decimal to a period and thousands to a comma, then export as CSV.

Does changing separator settings affect other files?

Yes, custom separator settings can affect other exports. Note the original settings and restore Use system separators after exporting the CSV.

Can I fix an existing semicolon CSV without re-exporting?

Yes, open the CSV in WPS Office Spreadsheets, press Ctrl+H to replace semicolons with commas, click Replace All, and save the file as CSV (Comma delimited).

What should I do if Outlook still cannot map contact fields?

Confirm the file is saved as CSV (Comma delimited), not CSV UTF-8 or semicolon-separated, and use Outlook's Import and Export wizard to map each column after selecting the file.