Migrate Outlook Contacts to Google — CSV Converter

🥦

Migrate Complete

Google Contacts CSV Format
valid rows

Switch from Outlook to Google without losing contacts. Upload your Outlook export, download a Google-ready CSV, and import directly.

Free preview — then from $5. Save with bundles.
Free preview before you pay
Files never leave your browser
No account needed to start

Download Sample Outlook Contacts Export

Example Outlook Contacts CSV to test the migration tool

Sample Contacts

Tool Rating

4.7 / 5 (106 votes)

How Outlook → Google Migration Works

1

Open Outlook

Open Microsoft Outlook desktop or Outlook Web App (outlook.com)

2

Export contacts

File → Open & Export → Import/Export → Export to a file → CSV → Contacts folder → Finish

3

Upload and Configure

Upload Outlook Contacts CSV Export CSV and choose Google Contacts CSV format

4

Preview and Download

Review converted data, download Google-ready file

5

Open Google Contacts

Go to contacts.google.com and sign in

6

Import contacts

Click Import in the left sidebar, select the CSV file, click Import

Every row and field is preserved in Google Contacts CSV format — ready to load into the target platform immediately.

Field Mapping

How Outlook Contacts fields map to Google Contacts Csv

Outlook Contacts Source Value Google Contacts Csv Target Value Note
First Name John → Given Name John Direct mapping
Middle Name Michael → Additional Name Michael Direct mapping
Last Name Doe → Family Name Doe Direct mapping
Title Mr. → Name Prefix Mr. Name prefix (Mr., Dr.)
Suffix Jr. → Name Suffix Jr. Name suffix (Jr., III)
E-mail Address john@example.com → E-mail 1 - Value john@example.com Primary email
E-mail 2 Address john@work.com → E-mail 2 - Value Secondary email
Mobile Phone 555-555-6666 → Phone 1 (Mobile) Mobile phone → type Mobile
Home Phone 555-111-2222 → Phone 2 (Home) Home phone → type Home
Business Phone 555-333-4444 → Phone 3 (Work) Business phone → type Work
Company Acme Inc. → Organization 1 - Name Acme Inc. Company name
Job Title Engineer → Organization 1 - Title Engineer Job title
Department Engineering → Organization 1 - Department Engineering Department
Web Page https://example.com → Website 1 - Value https://example.com Website URL
Birthday 1/15/1990 → Birthday 1990-01-15 Date format: YYYY-MM-DD
Notes Met at conference → Notes Met at conference Direct mapping
Categories Business → Group Membership Business Prepend '* myContacts :::'

Data Transformation

Each Outlook contact becomes one Google contact row

Input Outlook Contact Row

Outlook CSV row with flat column structure

Key columns: First Name, Last Name, E-mail Address
1:1 — One input row creates one output row
Output Google Contact Row

Name mapping
Phone numbering
Address mapping
At least First Name or Last Name required

Why Use Outlook → Google Migration?

One-Click Migration

Upload Outlook CSV, download Google CSV. No API setup, no app installation, no account linking.

Phone Restructuring

Converts flat Outlook phone columns into Google numbered format with proper type labels.

Address Combining

Merges Outlook flat address fields into Google structured address columns.

Date Format Conversion

Converts Outlook M/D/YYYY dates to Google YYYY-MM-DD birthday format.

Category to Group Mapping

Converts Outlook Categories to Google contact groups preserving your organization.

Browser-Based Privacy

Files process locally in your browser. Contact data never leaves your computer.

Common Google Contacts CSV Import Errors

Issues you might encounter when importing Outlook Contacts CSV Export data to Google Contacts CSV - and how we solve them

Missing Contact Name

Contact has no First Name or Last Name

First Name: (empty), Last Name: (empty)
First Name: John, Last Name: Doe

Add at least a First Name or Last Name to each contact

Contacts without names are skipped

Character Encoding Problem

Non-ASCII characters corrupted in Outlook CSV export

Name: Renée → Ren?e
Name: Renée (save as UTF-8)

Re-export from Outlook using UTF-8 encoding

Tool attempts automatic encoding detection

Outlook → Google Migration Questions

How do I export my Outlook Contacts?

In Outlook desktop, go to File, Open & Export, Import/Export, select Export to a file, choose CSV, and select your Contacts folder. In Outlook.com, go to People and click Manage Contacts then Export contacts.

How do I import into Google Contacts after conversion?

Go to contacts.google.com, click Import in the left sidebar, select the converted CSV file, and click Import. All contacts will be added to your Google account.

Will all my contacts transfer?

Yes. All contacts are migrated preserving emails, phone numbers, addresses, companies, job titles, birthdays, notes, and categories converted to Google groups.

How People Use Outlook → Google

Our company switched from Microsoft 365 to Google Workspace and I was responsible for migrating everyone's contacts. The Outlook CSV export had phone numbers split across Mobile Phone, Home Phone, Business Phone columns but Google wants them in numbered Phone 1, Phone 2 format. I tried importing directly and lost every phone number type label. The converter restructured all the phone columns and preserved the type information. Migrated 1,400 contacts in under five minutes.

Linda G.
Office Manager · migrated 1,400 contacts from Outlook 365

My entire client database was in Outlook with detailed address fields — street, city, state, ZIP all in separate columns. Google Contacts expects combined address fields with a different structure entirely. I was facing the prospect of manually fixing 3,200 address records. The converter merged the flat address fields into Google format and even converted my birthday dates from M/D/YYYY to YYYY-MM-DD. The import into Google Contacts worked on the first try.

Tom R.
Real Estate Agent · transferred 3,200 contacts to Google

We moved our organization from Outlook to Gmail and the contact migration was the part nobody wanted to own. Outlook categories were mapped to Google groups, which was critical for our departmental structure. I ran each department's export through the converter separately so I could verify the group assignments. Every category transferred as a Google contact group. What our IT team estimated would take two weeks took two days.

Keiko N.
IT Administrator · moved 8,500 contacts across 12 departments

Why You Cannot Import Outlook CSV Directly to Google

Incompatible Column Layouts

Outlook uses flat named columns (Mobile Phone, Home Street, Business Phone) while Google expects numbered multi-value columns (Phone 1 - Type, Phone 1 - Value). Direct import creates empty fields and loses phone type information.

What This Tool Does

Upload your Outlook Contacts CSV. The tool restructures flat columns into Google numbered format, combines address fields, reformats birthdays, and maps categories to Google groups. Download and import directly to Google Contacts.

Secure Outlook → Google Migration

Client-Side Migration

No server round-trips. Your Outlook → Google data is processed entirely in the browser tab.

Auto-Erased on Close

The moment you close the page, all Outlook → Google data is wiped from browser memory. No traces left.

EU Privacy Standard

Meets GDPR requirements by design — no data processing on external servers, ever.

More credits - more savings

Buy bundles and get up to 60% off. Perfect for recurring monthly conversions.

Frequently Asked Questions

You can, but free scripts and AI often miss edge cases that break real-world data: missing SKUs, currency formatting quirks, tax calculation errors, or date format mismatches. We have battle-tested validators specifically designed for accounting software imports that catch these issues before they corrupt your books. Plus, you get instant browser-based conversion without installing Python or managing dependencies.
In Outlook desktop, go to File, Open & Export, Import/Export, select Export to a file, choose CSV, and select your Contacts folder. In Outlook.com, go to People and click Manage Contacts then Export contacts.
Go to contacts.google.com, click Import in the left sidebar, select the converted CSV file, and click Import. All contacts will be added to your Google account.
Yes. All contacts are migrated preserving emails, phone numbers, addresses, companies, job titles, birthdays, notes, and categories converted to Google groups.
Yes. The tool works with CSV exports from Outlook 365, Outlook 2021, Outlook 2019, Outlook.com, and older desktop versions.
Outlook distribution lists are not included in standard CSV exports. Individual contacts within those lists are exported and migrated normally.
Yes. This is a one-time export, convert, and import process. For ongoing sync, you would need a dedicated sync tool with API access.
Yes. Export your contacts from Outlook.com (People section) as CSV and upload the file to this tool for conversion.

Outlook → Google Data Ecosystem

All available data flows from Outlook to Google

Outlook Outlook Contacts CSV Export Microsoft Outlook contacts CSV export with flat column structure (First Name, E-mail Address, etc.)
→
Google Google Contacts CSV Google Contacts import-ready CSV with numbered multi-value fields
First Name → Given Name Middle Name → Additional Name Last Name → Family Name
Google Contacts import, Gmail contacts, Google Workspace Current tool

Also available as

This platform pair is available in 2 other hubs

Learn More:

vs CloudFuze vs Cisdem vs Shared Contacts for Gmail