Fix problems importing contacts to

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

If you followed the instructions on how to import contacts to an 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?

Note: You will need to sign in first to get support. If you can't sign in, go to Account support.

You can also try the Microsoft Virtual Agent.

Related Topics

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

A subscription to make the most of your time

Need more help?

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.