Version applicability: Outlook and Excel 2019, 2016; Office 265; Windows and MAC OS Last updated: September 2018 Once a year, i typically consolidate a full list of all my Outlook contacts – both business and personal into a spreadsheet which i keep in a separate network storage. In today’s quick tip, i will describe a very simple procedure that will allow you to save your Outlook 2016 contact persons list into an comma separated values (CSV) file, which you can edit with Excel or alternatively, into a personal outlook data file (PST). Both are pretty similar but serve a bit different purposes. Export your contacts to an Excel CSV file We’ll first learn how to save your address book contacts into an Excel CSV file, so you can backup them as needed. You could then edit the list as needed and then import and sync them into your Iphone or Android phones and into third party services like GMail, Yahoo Mail or even your MAC Icloud.
![Excel Excel](/uploads/1/2/5/3/125388458/726960008.jpg)
Business users might also import their CSV files to other Outlook mailboxes served by Microsoft Exchange. Special Bonus: the Free PDF version of our Outlook 2016 Tips and Tricks guide.
Save contacts to a.pst file (Outlook Data file) Sometimes, you might want to migrate your contact between different versions of Microsoft Outlook, or import contacts from Outlook to the Microsoft Outlook.com web application. In this case, you might opt for exporting your Contacts people list to an Outlook Data file, commonly referred as.pst. The process is quite similar to the one described in the previous section. Note that in step 6 – you’ll need to pick Outlook data file to create a contacts.pst file. Import your.pst file contacts into Excel (csv / xlsx / xls files) If you already have a.pst file, you can import its contents into Microsoft Excel using Microsoft Outlook. Provided that your pst file contents are visible as part of your Contacts folder in Outlook, then the process will be similar to the one we outlined in the previous section in this post.
Are you using Outlook for Mac? If so, you can do this: 1. Open Outlook for Mac. Click 'Contacts'. From the File menu, choose Export. Choose 'Contacts to a list (tab-delimited text)' when. For those using Outlook for Mac 2011, export your contacts as a tab-delimited text subscribers to your MailChimp list from Apple's Address Book Export your contacts from Outlook to Google Gmail Outlook, it is helpful to understand the difference between the Outlook Address Book and Outlook.
Modified: July 16th, 2018 Outlook 2011 for Mac users can store its contacts in the data storage repository OLM file with other data items like calendar entries, email messages, etc. Although, when users need to move from Mac Outlook to a cloud-based mail client namely Gmail, all number of contacts can be imported to Gmail. Migrate OLM contacts directly from Outlook Mac file to Gmail account may be quite difficult.
As contacts may consist of some important addresses or phone numbers, end users cannot afford to lose them at any cost. Henceforth, in this blog, we are going to discuss a manual procedure to let users understand how to export contacts from Outlook 2011 to Gmail account. Well, to understand the need have a look on the above query taken from the forum site that syncs Outlook contacts to Gmail account: “I have been working on Mac Outlook 2011 for a long time. Nevertheless, now I have decided to import my contacts to Gmail account. I have been searched for the methods, but I was not able to find any relevant procedure for the same. Therefore, I am looking for a suitable method to export OLK files to Gmail.” Manual Steps to Export Contacts from Outlook 2011 to Gmail Earlier, Outlook 2011 users are not able to get any direct utility to export MAC Outlook contacts to Gmail.
However, now we have a manual workaround that includes export OLM contacts to CSV file and then, import CSV into Gmail contact group. Here, we are going to explain the following step-by-step procedure to export Mac Outlook contacts to Gmail: Convert OLM Contacts to TXT format Go through the follwing steps to export contacts from Outlook for Mac (.olm) to the plain text (.txt).
Let us take a look:. First, launch Microsoft Outlook in your Mac System. Then, go to File menu and choose an option Export. Now, the Export Window can pop up, select Contacts to a list (tab) option. Type the name and specify the desired location of the contacts file.
After this, click on Save button and confirmation message for import will be displayed. Export Text file to CSV (Comma Separated Value file) format Since a.txt file contains all contacts generated by Mac Outlook 2011 and it cannot be supported by Gmail account. Thus, users want to migrate it to a.csv file before importing it to the Gmail account.