Google Contacts CSV template and import checker

Check a contacts file before Google Contacts imports it.

Free for 10 runs a day.

The Google Contacts import check on a contact file: row 2 Phone 1 - Value fixed in file, row 3 E-mail 1 - Value check, row 4 E-mail 1 - Value duplicate.

Contacts you would import twice

Google Contacts creates a contact for every row. It does not check for duplicates on import. You merge them by hand afterward.

This checker finds the repeats before they land.

Start from the columns Google maps

Emails go in E-mail 1 - Value. Labels need three colons between them. Birthdays read as year-month-day.

The template uses the column names of the Google Contacts template.

The Google Contacts import template

Google Contacts contacts template

21 columns, in the order the template downloads.

Column	What goes in it	Required
First Name	Text
Middle Name	Text
Last Name	Text
E-mail 1 - Label	Text
E-mail 1 - Value	An email address
Phone 1 - Label	Text
Phone 1 - Value	Plus sign, country code and number
Address 1 - Label	Text
Address 1 - Street	Text
Address 1 - City	Text
Address 1 - Region	Text
Address 1 - Postal Code	Text
Address 1 - Country	Text
Organization Name	Text
Organization Title	Text
Organization Department	Text
Birthday	A date, year-month-day
Website 1 - Label	Text
Website 1 - Value	A web address
Notes	Text
Labels	Values, separated as the CRM asks

Use it from a script or an AI agent

Use in Claude

MCP  https://dedupe.ly/tools/mcp   every free tool in one connector (this one: check_crm_import)

POST https://dedupe.ly/tools/api/import-checker
{ "crm": "google-contacts", "csv": "..." }

Docs https://dedupe.ly/tools/api/openapi.json

OpenAPI document · API index · llms.txt