How to Fix Excel CSV Files Importing into Outlook as Empty Contacts
Question details
The user needs to understand why a CSV contact file edited in Excel imports into Outlook with empty or unmapped contact fields, and how to preserve delimiter, encoding, and text data.

- Product
- Microsoft Excel and Microsoft Outlook
- Device & OS
- not provided
- Scenario
- The user opens an Outlook-exported CSV contact list in Excel, edits or resaves it, then imports it back into Outlook.
- Observed behavior
- Outlook imports the rows but fails to map contact fields, leaving contacts empty because Excel changed delimiters, encoding, data types, or special characters.
Before reimporting, open the CSV in a plain text editor to identify the current delimiter and encoding, and keep a copy of the original contact file for comparison.
Reimport and save the CSV in WPS Spreadsheets with Text column format
Use this when you want to control the delimiter, encoding, and field types before importing the contact list into Outlook.
WPS Office Spreadsheets includes a CSV import dialog that lets you see how fields will be separated and forces contact columns to remain Text, preventing automatic data conversion.
In WPS Office Spreadsheets, click File > Open, select the Outlook CSV file, and choose the matching delimiter and encoding in the Text Import dialog.
In the preview, select each column that contains phone numbers, ZIP codes, dates, or special characters and set its Column data format to Text.
Click Finish, then verify that leading zeros, dates, phone numbers, and special characters are preserved in the spreadsheet.
Click File > Save As, choose CSV (Comma delimited) (*.csv), name the file, and save it.
Import the saved CSV into Outlook and confirm that one contact maps correctly before importing the complete file.

Use Microsoft Excel's Text Import Wizard to repair the CSV
Use this if you must stay in Microsoft Excel and need to re-open the CSV with delimiter, encoding, and Text format controls.
Prepare Outlook CSV Contact Files Correctly in WPS Spreadsheets
Use WPS Office Spreadsheets to open the Outlook CSV with the correct delimiter and encoding, set contact columns to Text, and save a clean CSV that Outlook can import without empty contact fields.
- 1. Open the CSV in WPS Spreadsheets: Launch WPS Office Spreadsheets, click File > Open, and select the Outlook-exported CSV file.
- 2. Choose delimiter and encoding: In the Text Import dialog, select the delimiter used by your file, such as comma, semicolon, or tab, and choose the correct encoding such as UTF-8.
- 3. Set contact columns to Text: For each column containing phone numbers, ZIP codes, or dates, set the column data format to Text, then click Finish.
- 4. Save as Outlook-compatible CSV: Review the data, click File > Save As, choose CSV (Comma delimited) (*.csv), and save the file.
- 5. Import into Outlook and verify: Import the saved CSV into Outlook and test with one contact before completing the import.

Frequently Asked Questions
Why does Outlook show empty contacts after importing a CSV that looks fine in Excel?
Excel may auto-convert values, change delimiters, or save with a different encoding. Open the CSV with WPS Spreadsheets by clicking File > Open, set contact columns to Text, and save it again as CSV so Outlook can map the fields.
Which delimiter should I use for Outlook contact CSV files?
Outlook usually accepts comma-delimited or semicolon-delimited CSV depending on regional settings. Check the original file in a text editor, choose the matching delimiter in WPS Spreadsheets, and keep it consistent when saving.
How do I stop Excel from dropping leading zeros in phone numbers or ZIP codes?
Use the import dialog instead of double-clicking the CSV. In WPS Spreadsheets, select the phone and ZIP columns and set the Column data format to Text before finishing the import.
Can I test the CSV before importing all contacts into Outlook?
Yes. Save the cleaned CSV, import it into Outlook, and check one contact. If fields appear correctly, import the complete file; if not, reopen the CSV and verify delimiter, encoding, and Text formatting.




