Contact Problems

How to Fix Excel CSV Files Importing into Outlook as Empty Contacts

Aamir Naveed AkramAamir Naveed Akram Nov 13, 2026 869 views

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.

How to Fix Excel CSV Files Importing into Outlook as Empty Contacts
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 you start

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.

Solution 1Recommended

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.

1
Open the CSV through the import dialog

In WPS Office Spreadsheets, click File > Open, select the Outlook CSV file, and choose the matching delimiter and encoding in the Text Import dialog.

2
Set contact fields to Text

In the preview, select each column that contains phone numbers, ZIP codes, dates, or special characters and set its Column data format to Text.

3
Review the contact data

Click Finish, then verify that leading zeros, dates, phone numbers, and special characters are preserved in the spreadsheet.

4
Save as Outlook-compatible CSV

Click File > Save As, choose CSV (Comma delimited) (*.csv), name the file, and save it.

5
Test with one contact in Outlook

Import the saved CSV into Outlook and confirm that one contact maps correctly before importing the complete file.

Reimport and save the CSV in WPS Spreadsheets with Text column format
Fields map correctly: Using Text as the column data format prevents leading zeros and date or phone number values from being converted during import.

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. 1. Open the CSV in WPS Spreadsheets: Launch WPS Office Spreadsheets, click File > Open, and select the Outlook-exported CSV file.
  2. 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. 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. 4. Save as Outlook-compatible CSV: Review the data, click File > Save As, choose CSV (Comma delimited) (*.csv), and save the file.
  5. 5. Import into Outlook and verify: Import the saved CSV into Outlook and test with one contact before completing the import.
Preserve leading zeros, dates, phone numbers, and special characters in contact fieldsControl CSV delimiter and encoding before importing into OutlookFull compatibility with Microsoft Excel CSV and Outlook contact import formatsFree, lightweight spreadsheet interface that feels familiar to Excel users
microsoft office alternative - wps office

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.