---
title: "Fix a contacts CSV for Google Contacts — Import Desk"
description: "Turn a messy contacts spreadsheet into a Google Contacts CSV, review duplicates before anything merges, and keep your original. Free preview, $8 once."
url: "https://importdesk.io/contacts-import-fix"
site: "Import Desk"
updated: "2026-11-19"
---

# 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](https://importdesk.io/app/contacts-import-fix)$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

| Full Name | E-mail | Mobile # | Org | Notes |
| --- | --- | --- | --- | --- |
| Ada Quill | ada\@example.invalid | 555 0101 | Quill & Sons | met at fair |
| Rowan, Bea | bea\@example.invalid | — | Harbour Cafe | — |
| Cal Fenn | not-an-email | 555 0144 | — | — |
| ada quill | ADA\@example.invalid | — | — | prefers email |

After: Google Contacts CSV

| Name | Email | Phone | Organization |
| --- | --- | --- | --- |
| Ada Quill | ada\@example.invalid | 555 0101 | Quill & Sons |
| Bea Rowan | bea\@example.invalid | — | Harbour Cafe |
| Cal Fenn | — | 555 0144 | — |
| ada quill | ADA\@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

  Keep separateMerge into one contact

## 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](https://importdesk.io/app/contacts-import-fix)

## Other import problems

- [Calendar Rescue ($9)](https://importdesk.io/calendar-rescue)
- [My Maps Splitter ($9)](https://importdesk.io/my-maps-splitter)
- [How your files are handled](https://importdesk.io/privacy)
