Save it as Excel by going to the File menu and choosing Save As under Format choose Excel Workbook.Unlike it’s predecessor, evaluating formulas and applying functions are much easier in Excel 2011, as you can choose required function from huge built-in list that can be accessed from. Your contacts open up in an Excel spreadsheet. As Office 2010 (Windows-based latest Office version) has more functions and added extensive formula support, Office 2011 for Mac covers a lot functions. txt file you exported from Outlook to your desktop, and choose it. 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.When the export is complete, click the Done button. Make sure the “.txt” extension is at the end of your file name. In the “Save As” field, put the name you want to give your file. 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.Open Outlook for Mac and click on Contacts.That way you can send them to a friend, or sort them, or do a variety of other things. Here are instructions on exporting your contact list in Outlook 2011 for Mac to an Excel spreadsheet. Get the Home and Business edition of Office 2011 if you want Outlook.