The Scenario
The conference ended three days ago. You're the operations coordinator who ran registration, and right now you're staring at an Excel workbook with 400 rows — first name, last name, email, phone, company, job title — one per attendee. Your manager wants everyone added to Google Contacts by end of day so the sales team can find them in Gmail autocomplete.
The bad version:
- Open Google Contacts, click New Contact, enter a name and email, save, go back to the workbook, repeat — for 400 rows
- Save the workbook as CSV and attempt the Google Contacts CSV import, watch it drop the phone and job title columns silently, then re-enter those fields manually for everyone
- Hand the workbook to someone else with instructions to "just add them," and spend the next two hours fielding questions about which columns go where
The import wizard is supposed to save time. In practice, the CSV path loses half the fields and gives you no feedback on which rows it skipped. You end up with a partial import and a manual cleanup job that's somehow worse than starting from scratch.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the data directly and talks to Google Contacts on your behalf — no CSV, no import wizard, no field mapping UI. You describe what you want and it runs the batch operation.
Take every row in the "Attendees" worksheet where column A is first name, column B is last name, column C is email, column D is phone, and column E is company — create a Google Contact for each person in a single batch operation and write the result to column F
What You Get
- One Google Contact created for each row in the worksheet — all 400 in a single batch call
- Display name set from First Name + Last Name, primary email from column C, mobile phone from column D, organization from column E
- Column F written back with "created" or the error message for any row that failed (duplicate email, missing required field)
- Contacts visible in Gmail autocomplete immediately after the batch completes
What If the Data Is Not Quite Ready
The phone numbers have mixed formats (some with dashes, some with parentheses, some international)
Before creating Google Contacts from the "Attendees" worksheet, normalize all phone numbers in column D to E.164 format (+1XXXXXXXXXX for US numbers) — then run the batch create using columns A through E and write the result to column F
Some rows have a first name but no last name, or vice versa
Create Google Contacts from the "Attendees" worksheet — for rows where column A (First Name) is empty, use the value in column B (Last Name) alone as the display name; for rows where column B is empty, use column A alone; skip any row where both are blank, and write "skipped – no name" to column F
Two worksheets need to be merged before importing — "Day 1 Attendees" and "Day 2 Attendees"
Combine the "Day 1 Attendees" and "Day 2 Attendees" worksheets, deduplicate by email address (column C), and create a Google Contact for each unique row using columns A through E — write the result status to column F on whichever worksheet the row came from
The list has 400 rows but only 200 people actually checked in — column F has a checkmark for those
Create Google Contacts only for rows in the "Attendees" worksheet where column F contains a checkmark or the word "yes" — batch all matching rows using First Name (A), Last Name (B), Email (C), Phone (D), and Company (E), and write "created" or the error to column G
The general pattern: clean and filter inside the same prompt, so you're not making two passes through the workbook before the operation even starts.
Try It
Get the 7-day free trial of SheetXAI and open your attendee workbook — or any workbook with a name, email, and company column — and ask SheetXAI to batch-create the contacts. For related tasks, see Export All Google Contacts to a Google Sheet and the Google Contacts overview.