Google Contacts
Monday.com Contacts4 fieldsHow to import Google Contacts data into Monday.com
Google Contacts exports use verbose column names like 'E-mail 1 - Value' and 'Organization 1 - Name'. This template renames them, combines Given Name and Family Name into Monday.com's single Name column, then maps email, phone, and company to board columns. Monday.com doesn't deduplicate on import, so dedupe your CSV first if your contact list has repeats.
Field-by-field mapping
This is the complete column mapping from Google Contacts to Monday.com. The left column is the header in your CSV export. The right column is the Monday.com field it should map to.
| Google Contacts column | Monday.com field | |
|---|---|---|
| Given Name + Family Name | Name* Monday.com uses a single Name column on the item, so we combine the two Google columns into one. TransformGiven Name and Family Name combined with a space | |
| E-mail 1 - Value | Email TransformLowercased and trimmed | |
| Phone 1 - Value | Phone TransformStandardized to international format (+1, +44, etc.) | |
| Organization 1 - Name | Company |
Required by Monday.com.
Columns we don't use
Your Google Contacts export includes 12 columns this template doesn't map. Each one below explains why, plus the workaround if you want the data in Monday.com.
- E-mail 2 - Value, Phone 2 - Value
Monday.com's default contact board has single Email and Phone columns. The first email and phone map to them; the second pair doesn't have a default home.
If you need it. Add Email and Phone columns to your Monday.com board called Secondary Email and Mobile, then re-run this template to map them.
- Address 1 - Street, City, Region, Postal Code, Country
Monday.com boards don't have a default address-block column set. Each piece needs its own column on the board.
If you need it. Add Text columns to your Monday.com board for each address piece, then re-run this template to map them.
- Organization 1 - Title
Monday.com boards don't have a default job-title column.
If you need it. Add a Text column to your Monday.com board called Job Title, then re-run this template to map Organization 1 - Title into it.
- Group Membership, Notes, Birthday, Website 1 - Value
Monday.com's default contact board doesn't include columns for groups, notes, birthday, or website.
If you need it. Add the columns you need to your Monday.com board (Dropdown for groups, Long Text for notes, Date for birthday, Link for website), then re-run this template.
Formatting and cleanup
Google Contacts exports rarely match the format Monday.com expects. Fix these before you import.
- 1.Combines Given Name and Family Name into Monday.com's single Name column
- 2.Lowercases and trims email addresses
- 3.Standardizes phone numbers to international format (+1, +44, etc.)
- 4.Renames verbose Google column headers (e.g. 'E-mail 1 - Value', 'Organization 1 - Name') to board column names
Or skip the manual work
Operelio runs this cleanup and mapping for you. Upload your Google Contacts export and download a clean, import-ready file for Monday.com.
Google Contacts to Monday.com FAQ
How do I export contacts from Google?
Go to contacts.google.com, click 'Export' in the left sidebar, choose 'Google CSV' format, and download the file. Select Google CSV, not Outlook CSV.
Why do you combine Given Name and Family Name?
Monday.com items have a single Name column. The template combines the two Google columns with a space so each item displays correctly on the board.
How does Monday.com handle duplicates on import?
Monday.com boards don't deduplicate on import. Every row in your CSV creates a new item. Run a deduplication pass on your CSV before uploading if you want to avoid duplicate items on the board.
What if a contact has multiple phone numbers or emails?
Google exports each phone and email in numbered columns. This template maps Phone 1 and E-mail 1. See 'Columns we don't use' below for the second pair.
Where do I import the CSV into Monday.com?
Open your contacts board, click the + at the top-right, choose 'Import from spreadsheet', and upload the file Operelio produces. The import wizard matches the column headers to your board columns.
