![Export Export](http://www.pppindia.com/contacts-sync/Gmail-Outlook-Contacts-Sync.png)
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. 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.
![Export Contacts From Gmail To Outlook 2016 For Mac Export Contacts From Gmail To Outlook 2016 For Mac](/uploads/1/2/5/6/125625660/167671661.png)
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.
This wikiHow teaches you how to receive Gmail emails in your Outlook 2016 desktop app on a Windows or Mac computer. For GmailAdding Your Gmail Account to OutlookImporting Your Google ContactsCommunity Q&AReferences. Exporting contacts (with Photos) from Outlook 2016 MAC to Google/Contacts Hi, Working in local (no exchange server) and because there is no sync between Google/Contacts & Calendar and Outlook 2016 i am continuing using Outlook on my Mac and use Google to sync with my other devices (iPhone, iPad).