Fix problems importing contacts to Outlook.com

We're sorry you're having trouble importing your contacts into Outlook.com. We'll help you fix the issue.

If you followed the instructions on how to import contacts to an Outlook.com account and had errors, please select one of the options:

Nothing is imported from a .csv contacts file

Use Excel to open your .csv contacts export file.

  • If data is corrupt or missing you can edit the .csv file manually.

  • If you don't see any data at all, run the export process again.

I get an error message that the format of the .csv file isn't correct

Try downloading this sample .csv file and copy the info from your .csv file into the appropriate columns in the sample .csv file.

There are a few things to remember when working with this sample .csv file:

  • Outlook requires the column headings in the first row, so don’t replace them with something else.

  • Make sure to save the file in .csv format. If you save the file in another format, you'll have to start over.

  • Try importing your .csv file with a few contacts to make sure you like the results. Afterwards, you can delete the imported contacts, add more to your .csv file, and import it again.

Nothing is imported from an Outlook for Windows .pst contacts file

See fix problems importing an Outlook .pst file for a list of common issues and solutions.

Need more help?

Community Forum button Contact Support button

Related Topics

What version of Outlook do I have?
Export contacts from Outlook.com to a CSV file
Export contacts from Outlook
Import and export Outlook email, contacts, and calendar
Add and remove group members in Outlook

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×