CSV to Google Contacts Converter

Turn a messy CSV or a plain list of numbers into a file Google Contacts will import cleanly.

Everything runs in your browser. The numbers you paste are never uploaded, logged or stored — there is no server involved in this tool at all. Free, with no sign-up.

Works with an export from any contact tool, a spreadsheet copy-paste, or a bare list of numbers one per line.

Used only for numbers that arrive without a country code.

Numbered automatically — Lead 001, Lead 002, and so on.

What this tool does

Google Contacts will only import a CSV laid out the way it expects. Paste any CSV — or just a list of numbers — and this builds that file for you: correct headers, numbers normalised to international format, duplicates within the file removed, and a name generated for any row that has none.

Importing into Google Contacts

  1. Paste your data above and check the detected columns.
  2. Download the generated CSV.
  3. Open contacts.google.com → menu → Import.
  4. Select the file and confirm.

Google offers to label everything you just imported. Accept it — that label is what lets you undo the whole batch in one action if the result is not what you wanted.

If your numbers came from WhatsApp, skip this entirely

Most WhatsApp contact-saver extensions hand you a CSV, and then this conversion and import becomes your problem. That middle step is avoidable.

The LeadSync Chrome extension writes straight into Google Contacts through the official Google People API — no file, no import, no format juggling. It also checks your existing contacts first, so it will not create the duplicates a CSV import can. Free for your first 35 contacts.

Related tools

Clean a messy list first with the phone number formatter, or remove repeats with the duplicate number remover.

Frequently asked questions

How do I import the file into Google Contacts?

Go to contacts.google.com, open the left menu, choose Import, select the CSV this tool produced, and confirm. Google reads the column headers automatically. Tip: label the batch on import so you can undo it in one step if something looks wrong.

What CSV format does Google Contacts need?

Google reads its own header names — Name, Given Name, Family Name, Phone 1 - Type and Phone 1 - Value are the ones that matter for a name-and-number import. This tool writes exactly those, so you do not have to rename anything.

Can I paste just a list of numbers with no names?

Yes. Set the name column to "None" and each contact is named from your prefix with an incrementing number — Lead 001, Lead 002, and so on. That keeps them easy to find and delete as a group later.

Will it create duplicates in my Google Contacts?

The tool removes duplicates within the file you paste, but it cannot see what is already in your Google account, so a number you already have would be imported again. Google Contacts has a built-in Merge & fix feature for cleaning that up afterwards.

Does my data get uploaded?

No. Parsing and file generation happen entirely in your browser, and the download is created locally from memory. Your contact list never reaches a server.

My CSV has commas inside quoted fields — will that break it?

No. The parser handles quoted fields containing commas and escaped quotes, which is what usually breaks simpler converters on real exports.

Can I import these contacts to a phone?

Once they are in Google Contacts, they sync to any Android phone signed into that account, and to an iPhone that has the Google account added with Contacts enabled.

Other free tools

LeadSync

Save up to 35 contacts, 100% free.

Add — Free