Skip to content

App tutorials

2 min read

How to export contacts from Outlook

Make a CSV file, then automatically export all new contacts going forward

By Justin Pot · January 15, 2021
A hero image for Outlook app tips with the Outlook logo on a blue background

Rolodexes grow with time—virtual ones are no exception. If you're a longtime Outlook user, you probably have a massive collection of contacts that's just sitting there, not doing anything. 

Those contacts aren't stuck in Outlook, though: you can export them, then use them in other apps. Any tool that uses contacts—from customer relationship management (CRM) software to email marketing apps—supports importing CSV files, and Outlook can export your entire customer list to that format. This article will show you how to do a one-time export of your Outlook contacts to a CSV file. 

But that's only a one-time transfer: any new contacts you add after doing this won't be included. So we'll also show you how to automatically export new Outlook contacts to almost any app, so everything stays up to date. 

Outlook isn't the only contact manager out there, of course. Here's how to export contacts from Google Contacts

How to export Outlook contacts 

1. Open Outlook, and click File

Clicking File in Outlook

2. This will open the File menu, which takes up the entire window. Click Open & Export

Clicking Open & Export

3. Then click Import/Export

Clicking Import/Export

4. Next, select Export to a file, and click Next

Clicking Export to a file

5. You'll be asked which kind of file you want to export to.

Exporting to CSV

6. If you want to migrate data to some program that isn't Outlook, choose Comma Separated Values (frequently shortened to CSV). Only use Outlook Data File (.pst) if you're specifically migrating contacts from one Outlook instance to another. Make your choice, then click Next

7. Select your contacts from the list. In this example, I only have local contacts, so I choose the Contacts (This computer only) option. 

Selecting the folder to export to

Note that, if you have multiple Exchange accounts connected, you'll see the contacts for each listed separately. 

8. You'll be asked where you'd like your CSV file to be saved, after which Outlook will export your contacts. Note that, if you have a giant collection of contacts, this process might take a while. When it's done, though, you can use the CSV file to import your current contacts into any app that supports importing CSV files. 

Automatically export Outlook contacts using Zapier

A CSV export is great for migrating all current contacts from Outlook. What if you want to export all new contacts going forward? 

Zapier can connect Outlook with thousands of apps, allowing you to automatically send your contacts to almost any app you can think of. For example, you could send every new contact in Outlook over to Google Contacts. 

Add new Microsoft Outlook contacts to Google Contacts

  • Microsoft Outlook logo
  • Google Contacts logo
Microsoft Outlook + Google Contacts
More details
    Copying contacts by hand is time-consuming and error-prone. Set up this Microsoft Outlook-Google Contacts integration to do it for you instead. Any new Outlook contacts you add from then on will automatically trigger this Zap, copying them to Google Contacts at the same time, with all the details you need to reference in both places.

    Or, if you have a Mailchimp newsletter, you could automatically add new contacts to your mailing list. 

    Add or update Mailchimp subscribers with new contacts in Microsoft Outlook

    • Microsoft Outlook logo
    • Mailchimp logo
    Microsoft Outlook + Mailchimp
    More details
      Adding new contacts to your mailing list by hand can be tedious and time consuming. Set up this Zap to handle that for you. Once you do, each new contact on Microsoft Outlook will automatically be added as a subscriber in your Mailchimp account. Your mailing list will always be up-to-date!

      Note: Be sure to follow all applicable rules around cold emailing prospects and give people ways to opt out of continued communication. 

      These are just two examples—Zapier lets you set up your automation, called a Zap, with whatever apps you use. Check out Zapier's Outlook integration to learn more.

      Read more: How to create a newsletter in Outlook

      Get productivity tips delivered straight to your inbox

      We’ll email you 1-3 times per week—and never share your information.

      Related articles

      Improve your productivity automatically. Use Zapier to get your apps working together.

      A Zap with the trigger 'When I get a new lead from Facebook,' and the action 'Notify my team in Slack'