csv (comma separated value) file is a simple but versatile text file. csv file, which can then be transferred over to a spreadsheet or database app. In order to export your contacts, you’ll need to download them as a. Unfortunately, the way Outlook stores and organizes its data isn’t compatible with the way Excel and Google do. Both are pretty accessible and flexible platforms, making them universally-easy choices for an Address Book backup. If your iPhone screen shatters, for example, or if you get locked out of your email account, you’ll want to have your contacts stored in another place so that you can still remain in contact with important business accounts.įor this reason, you might consider exporting your Address Book to Microsoft Excel or Google Sheets. Why Should You Import or Export Contacts?Īlthough Microsoft Outlook offers a robust and convenient address book on their platform, it’s always a good idea to backup your files and store your contacts’ information in an additional place. Why Should You Import or Export Contacts?.We’ll also teach you how to import Outlook contacts, and some reasons to consider doing so. In this article, we’ll go over everything you need to know about how to export Outlook contacts so that you can easily access your contacts’ information. You’ll need to know how to export your contacts within a file type that’s compatible with wherever else you’re trying to send them. Unfortunately, the Outlook data file doesn’t translate well to other programs. However, there may come a time where you need to export your contacts elsewhere. Save it as Excel by going to the File menu and choosing Save As under Format choose Excel Workbook.Microsoft Outlook makes it easy to store all of your contact information in one place within your address book.

Your contacts open up in an Excel spreadsheet. 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.

Outlook for mac export contacts to csv