Technology KnowledgeBase

Can I Import a File to Create A Contact List In Outlook Web Access?

It is possible to import lists of email addresses into Outlook to create Contact Lists. The service from which you are pulling your email addresses may have unique steps you must follow to export a list. Check the help materials of that service for more information. In most cases, you will be exporting a comma-separated variable (.csv) file or a spreadsheet such as a .xls file.

Prepare your list for upload by using this template. It can be opened in Google Sheets, Excel, or any spreadsheet editor. It is important that you do not change the headings in the first row as these need to remain the same for Outlook to properly recognize them.

Paste email addresses into the Email field. There should only be one address in each cell.

Input a name in the Category field that will be recognizable to you in Outlook. It can be anything you want. For example, the category could be "Parent Contact List" or "Chess Club". This will keep the uploaded contacts together once you import them.

Input names in the First, Middle, Last, and Nickname fields. These fields can be left blank.

Save the the spreadsheet as .csv file. Save it in a location that will be easy to find.

Navigate to the People (contacts) section of your Outlook account.

Navigate to the Your Contacts section of the sidebar.

Open the Manage menu in the top-bar and choose Import Contacts.

In the menu that appears, choose Outlook 2010, 2013, or 2016.

Select Browse and find the csv file that you saved.

Select Upload. The upload often takes a surprisingly long time, even with a small number of entries in the csv. Once the upload completes, the window will display the number of contacts that were imported.

Once the completion report has been displayed, click out of the window and check the Your Contacts section of the sidebar. The category that you named in your .csv should be displayed under the Other Contacts heading. If it isn't, try refreshing your page. If the category still doesn't display, sign-out and then sign-in to Outlook.

Once the category has appeared, select all of its members by clicking the select all button that is hidden in the gray bar, on the far left. Hovering over the box will make it appear.

Once all the members have been checked, select the Lists menu and choose New Contact List.

Enter a name for your list. Once you're finished, hit the return key or click away from the box. You may need to refresh your page to see the created list.


The new list will now appear in your contact list. By clicking on and entering the Edit menu, users can be added or removed. The entire list can also be emailed from this menu. Alternatively, the list can be selected from your directory via the to: field in a new email message.

Attached Files
There are no attachments for this article.