how to export your google contacts to excel
As a gmail user, you may need to export your google contacts. Whether you’re importing them into a different application, like our commercial real estate crm software, or just making a backup, this post will walk you through the process. exporting your google contacts to an excel file is an easy process and only takes a few clicks.
open google contacts
The first step to exporting your contacts is to open Google Contacts. Click the button below and sign in to your account to get started.
export from new google contacts
There are currently two versions of Google Contacts in use, including the new version and the more traditional version. if you are using the new version, continue with the steps below. if you are using the traditional version, skip to export from traditional google contacts.
step 1: select the “more” option:
Along the left side of the page in google contacts, look for a “more” menu item. click that to see a list of options including import, export, print, etc.
step 2: select the “export” option
click the “export” link in the left side menu.
step 3: select file format
select one of the following file formats:
- google csv (google.csv): choose this option if you want to import these contacts to a google account and other applications
- outlook csv (gmail-to-outlook.csv ): choose this option if you want to import these contacts to outlook as well as other applications
- vcard format (contacts.vcf): choose this option if you want to import these contacts to apple address book or any other applications
please note that many crm platforms such as clientlook can import csv files from google and outlook
step 4: export
click “export” and your file will be downloaded to your computer. that is all! switch to using your export file to finish.
export from traditional google contacts
if you are using the traditional version of google contacts, then this section is for you. Follow the steps below to export your contact data.
step 1: select the “more” option:
click the “more” link at the top of the page. you will see options to import, export, print, etc.
step 2: select the “export” option:
click the ‘export’ link.
step 3: select file format:
select one of the following file formats:
- google csv (google.csv): choose this option if you want to import these contacts to a google account and other applications
- outlook csv (gmail-to-outlook.csv ): choose this option if you want to import these contacts to outlook as well as other applications
- vcard format (contacts.vcf): choose this option if you want to import these contacts to apple address book or any other applications
please note that many crm platforms like clientlook can import csv files from google and outlook
step 4: export
click “export” and your file will be downloaded to your computer.
using your export file
your export from google contacts will produce a text file that has a “csv” extension along with whatever name you’ve given it, such as filename.csv. this type of file can be easily imported into most third party products and services, such as clientlook crm.
Your export file can be opened in excel simply by double-clicking on it. once the file is opened, you will probably notice that there are many columns of data that are empty. that’s pretty typical and not something to worry about. feel free to remove any of these unwanted columns in excel without worrying that your original data will be affected. this process is especially useful if you intend to import this data into a new application. if you are importing your contacts to clientlook crm, remember that you can create custom fields to import any data you want into your account.
more information
Want to learn more about using your exported google contacts in clientlook? then schedule a demo to get a personalized tour of our commercial real estate crm software.
Already a clientlook subscriber? Schedule a free success audit to make sure you’re getting the most out of our features.