Excel to Google Contacts CSV: import a spreadsheet into Gmail or Outlook contacts
In short: Upload an .xlsx or CSV, or paste cells: columns are matched by header (name, first, last, email, phone, mobile, company, title, notes), full names split, repeated addresses merged, and a CSV written with Google Contacts' headers (E-mail 1 - Value, Phone 1 - Value…) or Outlook's (E-mail Address, Mobile Phone…). Limit: Columns are matched by name. A header it doesn't recognise (say, "Contact pt.") isn't carried over; rename it to Name, Email or Phone first.
To import contacts from Excel into Gmail, save the sheet as a CSV with the column names Google Contacts reads, such as First Name, Last Name and E-mail 1 - Value, then use Import in Google Contacts. Upload your spreadsheet here and it writes that file for you, or Outlook's version, with names split and repeated addresses merged.
Price: this tool is free. Checking a whole email list is from $9/mo, and the first 100 checks are free with Google, no card. See pricing
Sample result
Name, Email and Mobile columns become a Google Contacts CSV with E-mail 1 - Value.
- Contacts
- 3
- Merged
- 1
- Skipped
- 1
What this means for you
Import it in Google Contacts or Outlook. Verify the addresses before you email the group.
- Upload .xlsx or CSV, or paste
- Google Contacts or Outlook headers
- Names split, repeats merged
- Optional Google label
- Gmail
- Outlook
- CSV
By SimpleVerifier Team · Last updated · Runs in your browser; nothing you paste is sent to us
Before you email them from Gmail, check the addresses.
- Use the addresses in the contacts file; the button under the result carries them.
- Upload or paste it at /verify. The first 100 email checks are free with a Google sign-in, no card.
- For every list after that, Pro includes unlimited email verification. Fair use: the first 100,000 checks a month at full speed, then slower, never cut off.
How do I import contacts from an Excel spreadsheet to Gmail?
- Upload the .xlsx or CSV, or copy the cells from Excel or Sheets and paste them. The first row should be the column names.
- Choose Google Contacts or Outlook, and optionally a label for Google (for example Leads November).
- Check the column matches the tool found, then download the CSV.
- In Google Contacts choose Import and pick the file; in Outlook use Import contacts. Verify the addresses first if you'll email them.
Example
- You enter
- A sheet with Name, Email, Mobile, Company and Title: Jane Doe, Leo Martin (
[email protected]),Doe, John, Ana Silva with no email or phone, and Jane D. repeating Jane's address; Google Contacts with the label Leads. - You get
- 3 contacts in a Google Contacts CSV (First Name, Last Name, Organization Name, Organization Title, Labels, E-mail 1 - Value, Phone 1 - Value…): Jane Doe, Leo Martin (address lowercased) and John Doe (name read last-first). Ana Silva skipped, Jane D. merged into Jane Doe.
- Limits
- Runs in your browser; an uploaded file can be up to 25 MB.
What format does Google Contacts need for a CSV import?
A CSV whose first row has the column names Google Contacts uses in its own export: First Name, Middle Name, Last Name, Organization Name, Organization Title, Notes, Labels, E-mail 1 - Label, E-mail 1 - Value, Phone 1 - Label, Phone 1 - Value. Using the same headers as Google's own export means each field lands where it should; Google's import help covers the import steps.
A sheet with a single Name column is split here: the first word becomes the first name, the last word the last name and anything between the middle name. "Doe, Jane" is read last name first.
How do I import contacts from Excel to Outlook?
Outlook reads its own headers: First Name, Last Name, Company, Job Title, E-mail Address, Business Phone, Mobile Phone, Notes (Microsoft's CSV guide). Choose Outlook, download, then follow Import contacts to Outlook; the file needs to be a CSV, so the tool writes one with commas and UTF-8.
Should I verify contacts before importing them?
If you'll email them, yes. Google Contacts happily stores an address that no longer exists, and the first time you send to the group from Gmail the dead ones bounce back to you. Rows with a badly formed address are counted on the result so you can fix them, and the button under it checks every address the file holds.
Google Contacts or Outlook CSV?
| Field | Google Contacts header | Outlook header |
|---|---|---|
E-mail 1 - Value (with E-mail 1 - Label) | E-mail Address | |
| Phone | Phone 1 - Value (Mobile or Work label) | Mobile Phone or Business Phone |
| Company | Organization Name | Company |
| Job title | Organization Title | Job Title |
| Group | Labels | Not in the file; add a contact list after import |
Who uses this tool, and for what?
- Small business owners
- Move a customer spreadsheet into Gmail contacts so you can email a label of them at once.
- Event organisers
- Turn the attendee sheet into an Outlook contacts file for the team that follows up.
- Recruiters
- Import a candidate shortlist into Google Contacts with a label per role.
What can’t this tool tell you?
- Columns are matched by name. A header it doesn't recognise (say, "Contact pt.") isn't carried over; rename it to Name, Email or Phone first.
- One email and one phone per contact; extra address columns aren't merged in.
- It writes the import file. It can't see what's already in your contacts, so Google or Outlook may create duplicates of existing ones.
Common questions
- How do I convert Excel to CSV for Google Contacts?
- Upload the .xlsx here, choose Google Contacts and download. The CSV has the column names Google Contacts reads, so the import maps every field.
- Can I import an Excel file directly into Gmail contacts?
- Google Contacts imports CSV and vCard files, not .xlsx. Convert the sheet to a Google-format CSV first.
- How do I import contacts into a label in Google Contacts?
- Enter a label name here; it goes in the Labels column of every row, and Google Contacts files the imported contacts under it.
- Is my spreadsheet uploaded?
- No. The file is read and converted in your browser.
Sources
A tidy list can still be full of dead addresses.
Extracting, deduplicating and syntax checks all work on the text of an address. None of them can tell whether the mailbox exists. Only the server that hosts it can answer that, through an SMTP check, and that is what the paid product does.
- Upload the cleaned file as it is: CSVs up to 100,000 rows
- A real SMTP mailbox check on every row, with catch-all detection
- Small list? Starter at $9/mo covers 2,500 emails a month, cancel anytime
Plans from $9 a month, cancel anytime, no contract. Sign in with Google and your first 100 email checks are free, no card. The free tools stay free either way.