Exporting Microsoft Outlook contacts to a Microsoft Excel data list

You may have a Microsoft Outlook contacts folder that you would like to be able to manipulate in Microsoft Excel.

If you are using Microsoft Outlook 2003 or Microsoft Outlook 2007:

  1. In Outlook, click File – Import and Export.

  1. Click Export to a File; click Next.

  2. Click Microsoft Excel 97-2003; click Next.

  3. Select the relevant Contacts folder from the folder list; click Next.

  4. Browse to the folder in which the list should be saved, type in a name for the Excel workbook and click OK. Click Next.
  5. If necessary, click Map Custom Fields to set up appropriate column headings for your Excel list. Click OK. Click Finish.

If you are using Microsoft Outlook 2010, Microsoft Outlook 2013, Microsoft Outlook 2016 or Microsoft Outlook 365:

  1. Click File – Options – Advanced.
  2. In the Export section, click Export. The Import and Export Wizard will be displayed.
  3. Click Export to a file, then click Next.
  4. Under Create a file of type, click the type of export required; click Next.
  5. In the Select folder to export from section, select the contact folder that you want to export to Excel; click Next.
  6. In the Save exported file as section, click Browse. Select the folder in which your Excel workbook should be located and type in a name for the file. Click OK.
  7. The Export to File dialog box will be displayed. Click Next. Click Finish.

Find out more about our Microsoft Outlook training Sydney, Australia.

Find out more about our Microsoft Outlook training London, UK or our Microsoft Outlook training Dorset, Wiltshire, Hampshire, UK.

About jdonbavand

I am a trainer of Microsoft Office, Microsoft Project and Crystal Reports. I have called my blog "If Only I'd Known That...." because I hear it so many times in training sessions. In fact, if only I had a £100 (or 150 Aussie dollars)for every time someone says "If only I'd known that." ....
This entry was posted in Microsoft Excel, Microsoft Outlook, Microsoft Outlook 2007, Microsoft Outlook 2010, Microsoft Outlook 2013, Microsoft Outlook 2016 and tagged , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s