How to export contacts from Outlook to Excel spreadsheet?
Exporting Outlook contacts to a file is an easy way for you to import the contact file into other applications. You can get rid of typing the same contact information over and over again by using the following method.
Save or Export Multiple emails to other fomat files(PDF/HTML/WORD/EXCEL) in Outlook |
Sometimes, you may want to save or export the emails to a folder as other format files, such as PDF, Word or Excel files in Outlook. In Outlook, neither of the Save as and Export function can handle this job. However, Kutools for Outlook's Save as file utility can export multiple emails to a folder as files with multiple formats at once time .Click for 45 days free trial! |
Kutools for Outlook: with dozens of handy Outlook add-ins, free to try with no limitation in 45 days. |
Oct 20, 2016 Exporting your Address Book from Outlook 2016. Under Select the folder to export from: select the Contacts folder you want to export, then click Next. Under Save exported file as: click Browse, and select the location you want to save the file for future use. Type a descriptive name in the File name: box (e.g., backup), then click OK.
Kutools for Outlook: 100+ New Advanced Tools for Outlook.
Office Tab: Enable Tabbed Editing and Browsing in Office, Just Like Chrome, Firefox, IE 8/9/10.
Classic Menu: Bring Old Menus and Toolbars Back to Office 2007, 2010, 2013, 2016 and 2019.
Office Tab: Enable Tabbed Editing and Browsing in Office, Just Like Chrome, Firefox, IE 8/9/10.
Classic Menu: Bring Old Menus and Toolbars Back to Office 2007, 2010, 2013, 2016 and 2019.
Export contacts from outlook to excel spreasheet
1. After launch your outlook, click File > Options. See screenshot:
2. When the Outlook Options window popup, click Advanced. In the right pane, click Export button.
3. In the Import and Export Wizard dialog, select Export to a file option, and then click Next button.
4. Select Microsoft Excel 97-2003, then click Next button. See screenshot:
5. Under the Select folder to export from, select Contacts option, then click Next to continue.
6. Under Save exported file as, click Browse button to select a destination folder.
7. In the File name column, type a name for the file. And then click OK button. After clicking OK button, it returns to the previous window, click Next, See screenshot:
8. If you want to manually customize the map by yourself, click Map Custom Fileds button. See screenshot:
9. If you don’t like the default setting, click on the Clear Map button to remove all the values on the right pane. And then you should choose your own value from the left pane. Just like the instructions giving in the dialog box: you need to drag the values from the source file on the left, and drop them on the appropriate destination field on the right. When finish setting, click on OK button.
10. Then it turns to the previous window, click on Finish button. Now, an Excel file with outlook contacts information is created.
Export contacts from outlook to excel spreadsheet in Outlook 2013/2016
If you are working in Outlook 2013/2016, the steps will be much easier.
1. Click File > Open&Export > Import/Export.
2. In the Import and Export Wizard, select Export to a file, click Next.
3. Select Comma Separated Values from the list box, click Next.
4. Select the contacts folder you want to export to a sheet in the Export to a file dialog. Click Next.
5. Click Browse to select a folder to place the new sheet which will contains contacts, and give it a name. Click OK > Next > Finish.
Then the contacts have been exported as csv file.
6. Open the csv file which you have create just now, click File > Save As and select Excel Workbook from Save as type drop down list in the Save As dialog. Click Save.
Now the contacts have been exported to a sheet.
Recommended Productivity Tools
Kutools for Outlook - More than 100 Advanced Functions for Outlook, Improve 70% Efficiency For you
- Complicated and repeated operations can be done a one-time processing in seconds.
- Forward multiple emails individually with one-click, and auto forward by rules.
- Auto CC/BCC every sending email and easy for customizing rules, and auto reply without requiring exchange server.
- Powerful junk emails filter, remove duplicate emails, reply with attachment, bunch of one-click operations, and so on...
- 60-day unlimited free trial. 60-day money back guarantee. 2 years free upgrade and support. Buy once, use forever.
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
- i did not find any e-mail address at excell sheet through above method ...
- To post as a guest, your comment is unpublished.I was able to export the file to an Excel spreadsheet, except that it didn't export my user-defined columns, which made the spreadsheet useless! I could not see any way to do that. Do you?
- I also could export but all went into one coloumn and I couldn't separate name from email so is useless. who has figured it out?
- To post as a guest, your comment is unpublished.I had created an distribution list that I now want to export to excel. I need to be able to see each of the names in the list but using this export function does not allow me to do that. Please help :) Thanks
- To post as a guest, your comment is unpublished.I managed to export the 'contacts' folder to Excel file, but No data!
What am I doing wrong? - To post as a guest, your comment is unpublished.very helpful, i love it
Topics Map > Campus Services > Office 365
Outlook 2016 for Windows - Exporting Your Contacts / Address Book(s)
This document will provide step-by-step guidance on how to export your Contacts / Address Book. The exported file can then be imported into another client.
Important: For those who use contact groups, please be aware that the individual contacts of your address book will be included in the export but your contact groups will not. If you use contact groups, please make a note of them prior to migrating so that you can more easily re-create them in Office 365.
Exporting your Address Book from Outlook 2016
- In Outlook 2016 click File > Open & Export > Import/Export. This starts the Import/Export wizard.
- In the Import and Export Wizard, choose Export to a file, then click Next.
- Under Create a file of type, select Comma Separated Values, then click Next.
- Under Select the folder to export from: select the Contacts folder you want to export, then click Next.
- Under Save exported file as: click Browse, and select the location you want to save the file for future use.
- Type a descriptive name in the File name: box (e.g., backup), then click OK.
- In the Export to a File window, click Finish and you are done.
- You also have the option to select which information should and should not be included in this file by clicking on Map Custom Fields ... .
- From here you can simply drag and drop values in the appropriate field. When you are finished click OK.
Keywords: | microsoft office365 o365 outlook 2016 address books exporting import migration contacts backup Suggest keywords | Doc ID: | 67925 |
---|---|---|---|
Owner: | Ara M. | Group: | Office 365 |
Created: | 2016-10-20 15:12 CDT | Updated: | 2017-06-08 13:24 CDT |
Sites: | DoIT Help Desk, DoIT Tech Store, Office 365 | ||
Feedback: | 34CommentSuggest a new document |