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. Open Outlook for Mac and click on Contacts.
From the File menu, choose Export. 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. 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.
Outlook then exports your contacts. When the export is complete, click the Done button.
Part 2: Import to Excel. Open Excel. From the File menu, choose Open. 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.
The Text Import Wizard opens up. Choose Delimited and click Finish. Your contacts open up in an Excel spreadsheet. Save it as Excel by going to the File menu and choosing Save As; under Format choose Excel Workbook.
Related Posts.
How to Export Contacts from Outlook and Import Them into Gmail. If you have your contacts in Outlook and you want to transfer them into your Gmail account, open Outlook and click the “File” tab. On the backstage screen, click “Open & Export” on the left and then click the “Import/Export” button. Outlook is no longer compatible with Googles online services, either use MS Exchange (and forget about Gmail) or use Gmail and forget about.
The Ultimate Guide to Office 365 If you use Outlook 2013/2016 or the Outlook Web App, it’s easy to import contacts from other email services. If you’ve moved from, from Google Apps for Work to Office 365 for Business, or you’re just using both email clients and want to have the same contacts in both, you can follow the video above or the instructions below. To export Gmail contacts:.
From your Gmail account, click Gmail - Contacts. Click More. Click Export. Select the contact group you wish to export. Select the export format Outlook CSV format (for importing into Outlook or another application).
Click Export. When prompted, click Save as, and browse to a location to save the file. To import from Outlook 2013 or 2016:. From the FILE tab, select Open & Export. Select Import/Export. In the Import and Export Wizard, select Import from another program or file. Click Next.
Select Comma Separated Values. Click Next. In the Import a File box, browse to and select the.csv file you saved your Gmail contacts to. Select Replace duplicates with items imported, Allow duplicates to be created, or Do not import duplicate items.
Click Next. In the folder list, select the contacts folder where you want to import your contacts to, and click Next.
Click Finish. To import from Outlook Web App:.
Select People from the app launcher. Select the settings gear, them click Options.
Select Import contacts under People. Click Browse and select the.csv file you saved your Gmail contacts to. Click Import. For instructions on migrating contacts from Yahoo!, Outlook.com, Mozilla Thunderbird, or a desktop version of Outlook,.