Fix Excel CSV Opens as One Column When Imported into Outlook
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.

- 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 changing separator settings, note your current decimal and thousands separators so you can restore them after the export.
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.
Open the workbook containing the contacts or source data in WPS Office Spreadsheets.
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.
Clear the Use system separators check box, set the Decimal separator to a period (.) and the Thousands separator to a comma (,).
Go to Menu > Save As, choose CSV (Comma delimited) (*.csv) as the file type, enter a file name, and save the file.
Return to Options and re-enable Use system separators so other spreadsheets and applications keep their regional defaults.

Change the Windows regional list separator to a comma
Use this solution when you want to fix the underlying regional setting that causes semicolon-separated CSV exports.
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. Open the contact list in WPS Office Spreadsheets: Launch WPS Office Spreadsheets and open the workbook containing the contacts or source data.
- 2. Adjust the separator settings: Click Menu > Options, clear Use system separators, set Decimal separator to period and Thousands separator to comma.
- 3. Export the file as comma-delimited CSV: Click Menu > Save As, choose CSV (Comma delimited) (*.csv), and save the file.
- 4. Import the CSV into Outlook: Open Outlook, start the Import and Export wizard, select the saved CSV, and map the contact fields.
- 5. Restore your previous separator defaults: In WPS Office Spreadsheets, return to Menu > Options and re-enable Use system separators.

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.




