Import contacts into Outlook Web App
You can import contacts to Outlook Web App from Gmail, Yahoo!, Outlook.com (formerly Hotmail.com), and other email services. This is a fast way to add many contacts all at once.
Do you want to add contacts one at a time? See Using contacts (People) in Outlook on the web.
Do you want to export contacts from Outlook Web App? See these instructions.
Create your list of contacts
Before you can import contacts to Outlook Web App, you need to export the contacts from the other email service or program to a comma-separated value (CSV) file.
For example, if you export your contacts from Google Gmail, choose to store them in CSV file format.
Or, you can download this sample CSV file, open it in Excel, and use it as a starting point for creating your list of contacts. There are a few things to remember when working with this sample CSV file:
Outlook Web App requires the column headings in the first row so don’t replace them with something else.
Save the file with a new name as a CSV file type (.csv). If you use Excel to work in the file, when you save it, Excel will prompt you a few times with "are you sure you want to save it in CSV format?" Always choose Yes. If you choose No, the file will get messed up and you'll need to start over with a fresh sample template.
Practice 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.
Here's what it looks in Outlook Web App like when you import the contacts in the sample CSV file.
Import your list of contacts to Outlook Web App
Sign in to Outlook Web App. For help, see Sign in to Outlook Web App.
At the top of your Outlook Web App page, choose the app launcher , and then choose the People tile.
When your contacts page opens, it may appear empty like this one:
On the My contacts page, in the toolbar, select Manage > Import.
On the Import contacts page, choose Browse, and then choose the CSV file that contains the contacts you want to import.
Choose Import to start importing your contacts from the CSV file.
When the import process is finished, you'll see a message indicating how many contacts were imported.
To view your contacts, choose the Options back button.
The contacts you just imported will look something like this:
What else do I need to know?
If the same contact is in your Contacts folder and in the CSV file, the contact is duplicated.
If you try to import more than 2000 contacts at a time, you'll see an error message. Use a program such as Excel to open the CSV file and separate your list of contacts into smaller files, and then import each newly created file separately.
If you don’t see the Import contacts option in Outlook Web App, use a desktop version of Outlook to import contacts into your account. And, if you don't have a desktop version of Outlook, consider signing up for the free 30 day trial of Office 365 that includes the desktop version of Outlook. You can use your free trial to import your contacts. This is a workaround that will get you unblocked.
Import contacts by using a desktop version of Outlook
You can use a desktop version of Outlook instead of Outlook Web App to import contacts from a CSV file to your Office 365 mailbox. Then the contacts will appear in both Outlook Web App and your desktop version of Outlook. For detailed information about how to do this, see one of the following articles:
Import email, contacts, calendar, and more by using a desktop version of Outlook
You can use a desktop version of Outlook instead of Outlook Web App to import email, contacts, calendar, from an Outlook data file. For detailed information about how to do this, see one of the following articles:
What if I have Office 365 for business?
If you're an admin and you want to import contacts for multiple Office 365 mailboxes at the same time, see Migrate email and contacts to Office 365 for business.
Was this article helpful? Please leave a comment at the bottom of this page and let us know. We'll use your feedback to double-check our steps or update the article to provide the information you need.