blog home about get remote Apple support

Export Your Outlook for Mac Contacts to an Excel Spreadsheet

Office 2011 for Mac

Get the Home and Business edition of Office 2011 if you want Outlook.

Here are instructions on exporting your contact list in Outlook 2011 for Mac to an Excel spreadsheet. That way you can send them to a friend, or sort them, or do a variety of other things.

Part 1: Export from Outlook for Mac

  1. Open Outlook for Mac and click on Contacts.
  2. From the File menu, choose Export.
  3. A box pops up, asking you “What do you want to export?” Choose “Contacts to a list (tab-delimited text).” Then click the right arrow at the bottom.
  4. A Save box appears. In the “Save As” field, put the name you want to give your file. Make sure the “.txt” extension is at the end of your file name. Under “Where” choose your desktop. Then click the Save button.
  5. Outlook then exports your contacts. When the export is complete, click the Done button.

Part 2: Import to Excel

  1. Open Excel.
  2. From the File menu, choose Open…
  3. When the Open box appears, go to the bottom of the box and under “Enable” make sure it’s set to “All Readable Documents.” then in the top part of the window, find the .txt file you exported from Outlook to your desktop, and choose it. Then click the Open button.
  4. The Text Import Wizard opens up. Choose Delimited and click Finish. Your contacts open up in an Excel spreadsheet.
  5. Save it as Excel by going to the File menu and choosing Save As; under Format choose Excel Workbook.

Related Posts

Moving to Outlook for Mac from Entourage: Tips

How to Get Your Contacts from Apple Address Book into Excel

Sign up to get our blog posts by email

Sign up for our monthly email newsletter