How To Export Your Google Contacts To Excel
As a Gmail/GSuite user, you may have the need to export your Google contacts. Whether you are importing them into a different application like our Salesmate, or just backing them up, this post will walk you through the process. Exporting your Google contacts into a .CSV file is an easy process and only takes a few clicks.
Open Google Contacts
The first step with exporting your contacts is to open Google Contacts. Click the button below and log into your account to get started.
Export from newer Google Contacts
Currently, there are two versions of Google Contacts in use including the new version and the more traditional version. If you are using the new version then proceed with the steps below. If you are using the traditional version, then skip to Export from traditional Google Contacts.
Step 1: Select the “Export” option:
Select the Export option on top left.
Step 2: Select the file format
Select one of the following file formats:
- Google CSV (google.csv): Choose this option if you want to import these contacts into a Google account as well as other applications
- Outlook CSV (Gmail-to-outlook.csv): Choose this option if you want to import these contacts into 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
Note that many CRM platforms such as ClientLook can import both the Google and Outlook CSV files
Step 3: Export
Click “Export” and your file will be downloaded to your computer. That’s it! Skip to Using your export file to wrap up.
Using your export file
Your export from Google Contacts will produce a text file that has a “CSV” extension along with whatever name you have given it like filename.csv. This type of file can be easily imported into most 3rd party products and services like Salesmate CRM.
Your export file can be opened in Excel just by double-clicking it. Once the file opens you will probably notice that there are many columns of data that are empty. That’s pretty typical and not something to be concerned with. 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 into Salesmate CRM then remember that you can create custom fields to import just about any data desired into your account.