#IMPORTING CONTACTS INTO OUTLOOK 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. Import/Export function in Outlook 2021 - 2013 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:
#IMPORTING CONTACTS INTO OUTLOOK 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 2021, 2019, 2016, 2013, 20 to an Excel spreadsheet.