Turn a messy spreadsheet into a Google Contacts CSV

Contacts Import Fix maps your columns to Google’s format, flags duplicate contacts for you to review, and merges nothing until you say so.

Check my file free$8 once, only when you download

The error it solves

The file you’re importing isn’t formatted for Google Contacts

It usually means the columns don’t match what Google expects, as with many Outlook and spreadsheet exports. Google also advises splitting files of more than 3,000 contacts.

What it does

Columns
Recognizes common headers like Name, E-mail, Mobile and Org, and lets you change any column’s meaning before you download.
Names
Splits a single Name column into first and last name, including the “Last, First” layout.
Duplicates
Groups rows that share an email, phone number or full name. Every group starts as “keep separate”, and you choose which to merge.
Bad values
Leaves out malformed emails and too-short phone numbers and lists each one, with its row, in a needs-attention file.

A field that is empty in your spreadsheet stays empty. Rows with no name, email, phone or company are set aside, not filled in. Phone numbers are not reformatted, because the country is not known.

What you get that a plain CSV converter doesn’t

Renaming columns is the easy part. The risk is in contacts that look alike and values Google can’t read.

Duplicates reviewed, not merged for you
Rows that share an email, phone number or full name are grouped. Every group starts as “keep separate”, and only the ones you choose are merged.
Bad values listed, not silently lost
Malformed emails and too-short phone numbers are left out of the import and listed with their row number in a needs-attention file.
Nothing filled in
An empty field stays empty, and rows with no name, email, phone or company are set aside instead of padded.
A report and your original
The report counts the duplicate groups you merged and kept separate, and your untouched file comes back in the same zip.

Free before-and-after preview

Fictional sample. Nothing here is a real person, place or calendar.

Rows read

4

Contacts out

4

Duplicate groups

1

Nothing merges until you choose

Need attention

1

Before and after

Before: your spreadsheet

Your spreadsheet, first rows
Full NameE-mailMobile #OrgNotes
Ada Quillada@example.invalid555 0101Quill & Sonsmet at fair
Rowan, Beabea@example.invalid—Harbour Cafe—
Cal Fennnot-an-email555 0144——
ada quillADA@example.invalid——prefers email

After: Google Contacts CSV

Google Contacts CSV, first rows
NameEmailPhoneOrganization
Ada Quillada@example.invalid555 0101Quill & Sons
Bea Rowanbea@example.invalid—Harbour Cafe
Cal Fenn—555 0144—
ada quillADA@example.invalid——

Needs your attention

  • Row 4: “not-an-email” is not a valid email address, so it was left out of the Google file.

Duplicate review

Every group starts as “keep separate”. In the tool you choose which to merge.

  • 2 contacts with the same email address, same name

    • Row 2: Ada Quill · ada@example.invalid · 555 0101 · Quill & Sons
    • Row 5: ada quill · ADA@example.invalid
    What to do with this group

How it works

  1. Add your spreadsheet saved as CSV. It is read in this browser and not uploaded.
  2. Check the column mapping and the free preview, and decide each duplicate group.
  3. Pay $8 once to download the Google Contacts CSV, the needs-attention list, a report and your untouched original.

What you download

  • Google Contacts CSV (split into files of 3,000 contacts when larger)
  • Needs-attention list with row numbers
  • A plain-text report
  • Your original file
Open Contacts Import Fix

Other import problems