Formatters & Code
Google Contacts CSV Import Mapper Online
Format contact spreadsheets for Google Contacts import. Auto-split full names, map paired phone/email columns, normalize numbers, and split 3,000-row batches.
Contact spreadsheet source
Compatible with Outlook, iCloud, Excel, and CRM exported contact spreadsheets (Max 15 MB)
Review column mappings
Review Column Mappings
Confirm which columns match Google Contacts fields. Full names are automatically split into First, Middle, and Last Name.
| Your CSV Header | Sample Values | Map To Google Field |
|---|
Export & preview contacts
Ready for Import
Download your formatted CSV files below and import directly into contacts.google.com → Import.
Download Unmapped Fields Audit ReportTransformed Preview (First 5 Rows)
Results
What the result means
Google Contacts requires specific column headers such as Given Name, Family Name, Phone 1 - Type, and Phone 1 - Value when importing contact address books. Standard CSV exports from Microsoft Outlook, Apple iCloud, and CRM databases frequently combine names into single fields or use incompatible column titles, resulting in missing numbers or failed imports. PageUtil Google Contacts CSV Import Mapper inspects your input headers locally, suggests matches, and splits full names into first, middle, and last components. It formats international and domestic telephone digits into standard formats and partitions lists exceeding Google's 3,000-contact batch limit into individual download files without sending address book data over the network.
Related tools
Guides
Questions
Why are my phone numbers not showing up after importing to Google Contacts?
Google Contacts does not recognize generic headers like 'Phone' or 'Mobile'. It strictly requires paired columns: 'Phone 1 - Type' (e.g. Mobile, Work) and 'Phone 1 - Value'. This tool automatically maps and pairs those headers.
What is Google's contact import limit?
Google Contacts imposes a maximum batch import limit of 3,000 contacts per CSV file. If your upload exceeds 3,000 records, this tool automatically partitions the data into separate candidate files (Part 1, Part 2, etc.) for seamless sequential import.
Does this tool support files exported from Outlook or iPhone?
Yes. The mapper recognizes common header names from Microsoft Outlook, Apple Contacts (iCloud), Salesforce, HubSpot, and generic Excel address lists, automatically matching them to Google's official schema.
Is my personal address book data secure?
Yes. All parsing, column remapping, phone number formatting, and CSV generation occur 100% locally in your web browser using Web Workers. No contact records or names are ever uploaded to a server.