Export reference

Google Contacts CSV export: every column, and where it goes

Google Contacts is the contact book in a Google account. Its export has 17 columns, and 8 ready-made templates map it into 8 CRMs.

By Operelio teamUpdated September 26, 2026

Get started free See every column

Google Contacts import templates, by CRM

How to export from Google Contacts

From Google Contacts's own help pages, checked September 2026. Menu names can move, so the linked guide is the one to trust if they differ.

Google Contacts

Export Google Contacts as a Google CSV

Open Google Contacts.
Tick the contacts, or choose Selection Actions, then All.
Click More actions at the top right, then Export.
Select Google CSV and click Export.

File: Google CSV

In a work or school account you can't select every contact in the Directory.

Google: Export contacts

Every column in a Google Contacts export, and where it goes

For each column, the field it fills and the CRMs that field is in. Each CRM name opens its template. Columns no template uses are listed after the table.

Google Contacts export columns, the CRM field each one fills and the CRMs with that field
Column	FieldCRMs
Given Name	First Name: HubSpot, Salesforce Leads, Zoho Contacts, Freshsales Name: Pipedrive, Close, Monday.com, Copper
Family Name	Last Name: HubSpot, Salesforce Leads, Zoho Contacts, Freshsales Name: Pipedrive, Close, Monday.com, Copper
E-mail 1 - Value	Email: HubSpot, Salesforce Leads, Pipedrive, Zoho Contacts, Freshsales, Close, Monday.com, Copper
Phone 1 - Value	Phone: Salesforce Leads, Pipedrive, Zoho Contacts, Close, Monday.com Phone Number: HubSpot, Copper Work Number: Freshsales
Phone 2 - Value	Mobile: Zoho Contacts Mobile Number: Freshsales
Organization 1 - Name	Company Name: HubSpot, Freshsales, Copper Company: Salesforce Leads, Close, Monday.com Organization: Pipedrive Account Name: Zoho Contacts
Organization 1 - Title	Title: Salesforce Leads, Zoho Contacts, Close, Copper Job Title: HubSpot, Pipedrive, Freshsales Notes: Monday.com
Address 1 - Street	Street: Salesforce Leads, Copper Street Address: HubSpot Mailing Street: Zoho Contacts Address: Freshsales
Address 1 - City	City: HubSpot, Salesforce Leads, Freshsales, Copper Mailing City: Zoho Contacts
Address 1 - Region	State: Freshsales, Copper State/Region: HubSpot State/Province: Salesforce Leads Mailing State: Zoho Contacts
Address 1 - Postal Code	Postal Code: HubSpot, Copper Zip/Postal Code: Salesforce Leads Mailing Zip: Zoho Contacts Zip Code: Freshsales
Address 1 - Country	Country: Salesforce Leads, Freshsales, Copper Country/Region: HubSpot Mailing Country: Zoho Contacts
Website 1 - Value	Website URL: HubSpot Website: Salesforce Leads
Group Membership	Notes: HubSpot, Monday.com Description: Salesforce Leads, Freshsales
Notes	Description: Salesforce Leads, Zoho Contacts, Freshsales, Close Notes: Pipedrive, Monday.com Details: Copper

2 columns no template uses

Each template page lists the columns it leaves out and why.

E-mail 2 - Value
Birthday

Google Contacts export questions

What columns are in a Google Contacts export?

17 columns, starting with Given Name, Family Name, E-mail 1 - Value, E-mail 2 - Value, Phone 1 - Value, Phone 2 - Value. The full list, and where each column lands in each CRM, is on this page.

How do I export Google Contacts data to CSV?

Open Google Contacts. Tick the contacts, or choose Selection Actions, then All. Click More actions at the top right, then Export. Select Google CSV and click Export. The file comes out as Google CSV.

Which CRMs can I import a Google Contacts export into?

There are ready-made templates for HubSpot, Salesforce, Pipedrive, Zoho CRM, Freshsales, Close, Monday.com and Copper: 8 in all, each mapping the export column by column. Any other CRM can take the file too, mapped by hand in the CRM Formatter.

Does Google Contacts integrate with CRMs directly?

Google Contacts documents no direct integration with HubSpot, Salesforce, Pipedrive, Zoho CRM, Freshsales, Close, Monday.com or Copper, so an export file is the way in. The templates here map that file column by column.

Templates for other exports

Lead data and prospecting

Email marketing and ecommerce

Contacts, events and forms

Moving from another CRM

Google Contacts export

Map the export into your CRM

Pick the template for your CRM, upload the file and check every column before it goes in. The CRM Formatter runs on the Free plan, no credit card needed.

Get started free See all templates