How to export address book from outlook 2010 to 2016
- How to export address book from outlook 2010 to 2016 how to#
- How to export address book from outlook 2010 to 2016 update#
Clicking the OK button will bring you back to the previous window and you click Next to continue.In the Browse dialog, type a name for the exported file in the " File name" field and click OK.Click the Browse button to select a destination folder to save the exported file to. Well, you have just chosen the data to export and now you need to specify where you want to save them.Since we are exporting our Outlook contacts, we choose Contacts under the Outlook node, as shown in the screenshot below, and click Next to continue. Note that Outlook 2010 is the last version where this choice is available, in Outlook 2013 your only option is " Comma Separated Values (Windows)". If you want to export the contacts to earlier Excel versions, then select " Microsoft Excel 97-2003". Select " Comma Separated Values (Windows)" if you want to export your Outlook contacts to Excel 2007, 2010 or 2013 and click the Next button.On the first step of the Import and Export wizard, choose " Export to a file" and then click Next.I'll remind you that in Outlook 2010 you can find it on the File tab > Options > Advanced. Open your Outlook and navigate to the Import/Export function, as shown in the screenshots above.We are going to do this in Outlook 2010, and lucky you are if you have this version installed :)
How to export address book from outlook 2010 to 2016 how to#
Now that you know where the Import/Export feature is located, let's have a closer look at how to export contacts from your Outlook address book to an Excel spreadsheet. How to export Outlook contacts to Excel using the Import/Export wizard Import and Export function in Outlook 2007 and Outlook 2003Ĭlick File on the main menu and choose Import and Export. On the File tab, choose Options > Advanced > Export: On the File tab, choose Open & Export > Import/Export:Īlternatively, you can open the same wizard by going to Options > Advanced > Export, like you do in Outlook 2010. Well, let's see where exactly the Import/Export wizard resides in each Outlook version and after that I will walk you step-by-step through exporting Outlook contacts into an Excel file. Where to find Import/Export function in different Outlook versions Read this article to learn how you can quickly export all needed details of all your Outlook contacts to an Excel worksheet at a time. Instead, they seem to have been trying to hide this function deeper and deeper with each new version of Outlook, which is funny, because it's really useful. However Microsoft failed to find little room for it on the ribbon (nor on the toolbar in earlier versions) so that it would be within easy reach. The Import/Export function is available in all Outlook versions. Export contacts from Outlook to Excel by copying / pastingĮxport Outlook contacts to Excel using the Import and Export function.Export Outlook contacts to Excel using Import / Export wizard.Today we will dive into 2 possible ways of exporting Outlook contacts to Excel and I'm going to show how you can quickly do this in different Outlook versions:
How to export address book from outlook 2010 to 2016 update#
You may want to update all or some of your contacts, backup the contacts or make a list of your VIP clients so that your partner can take care of them during your vacation. First I will explain how to use the build-in Outlook Import / Export function, and after that we will create a custom contacts view and copy / paste it to an Excel file.Īll of us need to export contacts from the Outlook address book to Excel once in a while. In this article I will show how you can quickly export contacts from Outlook 2016, 2013, 20 to an Excel spreadsheet.