Export contacts from excel to outlook. Set up storage and sort order for contacts in Microsoft Outlook
When exporting contacts from Outlook their copy saved as a CSV or other file type, the contents of which can then be imported into another application.
- Comma separated values.
In Outlook on your computer, select Teams File > Setting up accounts > Setting up accounts.
Select the account you want to delete and click the button Delete.
Click the button Close.
Open Outlook on your computer and go to the File.
If there is no element on the ribbon File in the top left corner, you don't have Outlook on your computer. In this case, you can find export instructions for your version of Outlook in the article What version of Outlook do I have.
Select teams Open and export > Import and export.
Select an item Export to file.
THIS ACTION IS THE MOST IMPORTANT, especially if you are using a friend's computer. Scroll the list if necessary Select a folder to export up and select the folder in your account section Contacts. Click the button Next.
Click the button Review, give the file a name and click the button OK.
Check which folder the files will be saved in and click the button Next.
Ready Import and export disappears.
Locate the new .csv file on your computer and open it in Excel to verify that your contacts have been exported. Most likely, it will have many empty cells. This is fine.
If you're using Outlook on a friend's computer, you can now remove your account from their version of Outlook. Here's how to do it.
You can now import contacts copied to a CSV file to another computer running Outlook for Windows or to another email service.
Select version
The instructions vary slightly depending on whether you're using classic or new version of Outlook on the web. Select your version of Outlook on the web to see the appropriate instructions.
Note: If the organization has placed a logo on the toolbar, the interface may differ from the above.
Instructions for the new version of Outlook on the web
Instructions for classic Outlook on the web
- Options.
-
Click the button OK.
In the dialog box Export to file click the button Next.
To start exporting contacts, click the button Ready. When the export is complete, Outlook does not display any messages, but the Import and export disappears.
When the export is complete, click the button OK to close the Outlook Options window.
Open the folder where you saved your contact list (for example, the Documents folder).
If you exported your contacts to a .csv file, view it in Excel to see what was exported from Outlook. Most likely, it will have many empty cells. This is fine.
It is generally recommended to close the file without saving changes. Otherwise, the file formatting may be broken and you will not be able to use it for import. If this happens, you can always export again and create a new file.
You can use Excel to update the data in a CSV file. For tips on working with your contact list in Excel, see Create and edit CSV files.
At the top of the Outlook 2010 ribbon, open the File.
If there is no element on the ribbon File, you do not have Outlook 2010. In this case, you can find import instructions for your version of Outlook in the article What version of Outlook do I have?
In the Outlook Options window, select Additionally.
In the section Export select Export.
In the window Import and Export Wizard select Export to file and press Next.
Select desired type export to the field Create file next type . The most commonly used format Comma Separated Values (Windows), also called a CSV file. Then click the button Next.
If you plan to use the exported contacts in another copy of Outlook, select Outlook Data File (.pst).
In the section Select a folder to exportscroll up the list, if required, and then select the folder containing the contacts you want to export. Once completed, click the button Next.
Note: If you don't choose to export to an Outlook data file (.pst file), you can only export one folder at a time.
To learn about importing contacts into Outlook 2016, see
Hello friends. Just recently, in the process of preparing the computer, I transferred all the data and was about to start the installation. But at the last moment, the user warned me that he uses a postal service to check and send mail. Outlook client, where a very large list is stored Email addresses, which needs to be saved. This is exactly what I will tell you about now
I have already described the lesson earlier. For example, I, given mail client I have been using it regularly for a long time. Every day my “Address Book” was filled with addresses of friends and acquaintances. This contact list saved me a lot of time. Firstly, it was difficult to remember all the contacts, and secondly, I could select the address I needed in 2 clicks, rather than entering it manually. But how to save a list of addresses in Outlook, if you suddenly need to reinstall Microsoft Office, or in general operating system? I will talk about this in detail below.
Saving Contacts in Outlook
So, having opened Outlook, go to the section “ Contacts" Our " Address books", and on the right their contents.
To save contacts in Outlook, click on “ File" and select " Open" A list of actions will appear on the right in which we need the item “ Import».
In the window that opens, go down to the very bottom and mark “ Export to file" and click " Next»
The next step will be elections like created file. I recommend using " Comma Separated Values (Windows) ", the file will be saved in .csv format, which means that we can use it not only in Outlook.
Specify the name and path to the address book storage location. To do this, use the button " Review", by clicking it, a folder selection window will appear, in my case for saving Outlook contacts, I chose " Desk" and named the file " Address book».
Before starting the saving process, a list of actions will appear that will be performed after clicking the " Ready" If you are saving only contacts, your window should look something like the one shown below.
After finishing saving, a .csv file appeared on my desktop with the name “Address Book”, which I will later use to restore the contact list after rearranging the operating system.
Recover contacts in Outlook using a .csv file
To call the contact recovery menu, click “File” -> “Open” -> “Import”.
The same window will appear as when saving, although this time we need to select the item “ Import from another program or file».
In the next window, in the file to import field, indicate the storage location of our file; to do this, you can use the “Browse” button. Menu " Options» – here you need to indicate what action to take when duplicates occur. We are asked to replace, allow duplicates, and ignore duplicates. Having indicated the path, mark the item that you like ( I use duplicate creation), click " Next».
Select the folder where the imported contact list will be placed.
In the window of completed actions, click on “Finish”, which will start the process of restoring contacts in Outlook.
Now all your addresses will be saved in the Contacts menu.
Saving and restoring contacts in Outlook is very similar, just a few things change, so remembering these steps is very easy. And which is very convenient when reinstalling Windows.
You can use the same contacts in Google Gmail And Microsoft Outlook without manually adding them in both locations.
In this article
Import contacts from Google Gmail to Outlook
Export contacts from Outlook to Google Gmail
Before you export contacts from Outlook, it's helpful to differentiate between Outlook Address Book and Outlook Contacts. Both are part of Outlook. However, an address book is a compilation of lists of different addresses that Outlook may store, such as Internet LDAP directories, a global address list (GAL), or other third-party address books. Contacts is just one of the address lists included in address book. You can only export contacts directly from Outlook to Google Gmail.
Open the tab File.
Select an item Options.
Select an item Additionally.
In the section Export click the button Export.
In the field from drag the field you want to convert the shape to the Outlook field specified in the field To whom.
To view additional entries in the field " from", press the button Back or Next.
To remove all mappings, click the button Clear.
To restore the original mappings, click Default.
In the window Import and Export Wizard select Export to file and press the button Next.
Select Comma separated value (DOS) and press the button Next.
In the list of folders, select the contacts folder you want to export and click Next.
Select a folder to temporarily save the file on your computer.
Note: This file can be deleted after importing contacts into Google Gmail.
Enter the name of the exported file and click the button Next.
To add or remove fields to determine how contact information is saved in the new imported file, click Field Matching.
Note: When you try to import data from another program or file, the button Field Matching in the dialog box Export to file may not be available. In the dialog box the following actions will be performed check the box Export, and then the button Field Matching available.
More help custom field mapping
To display additional fields in field, click the plus sign (+) next to the field. For example, to display fields Street And City of business, click the plus sign (+) next to Work address.
Click the button Ready.
Sign in with your account Google Gmail.
In the left column, select Contacts.
On the right side of the screen, click the button Import.
In the dialog box Importing contacts click the button Review.
Select the file exported in step 10 and click Open.
Click the button Import.