Outlook Column Detection
Automatically recognizes Outlook flat contact fields like Mobile Phone and Business Street.
Enter your email to receive a sign-in link
Transform your Outlook Contacts export into a properly formatted CSV ready for Google Contacts import.
Free preview — then from $5. Save with bundles.Download Sample Outlook Contacts CSV
Sample Outlook Contacts export with standard column format
Open Microsoft Outlook desktop or Outlook Web App (outlook.com)
File → Open & Export → Import/Export → Export to a file → CSV → Contacts folder → Finish
Upload Outlook Contacts CSV Export CSV and choose Google Contacts CSV format
Review converted data, download Google-ready file
Go to contacts.google.com and sign in
Click Import in the left sidebar, select the CSV file, click Import
Output is in Google Contacts CSV format — ready to import directly, no manual reformatting needed.
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 :::' |
Each Outlook contact becomes one Google contact row
Outlook CSV row with flat column structure
First Name,
Last Name,
E-mail Address
In Outlook desktop, go to File, Open & Export, Import/Export, select Export to a file, choose Comma Separated Values, and select your Contacts folder. In Outlook.com, go to People and click Manage Contacts then Export.
Go to contacts.google.com, click Import in the left sidebar, and select the converted CSV file. Google will import all contacts with their fields correctly mapped.
Yes. The tool maps Outlook fields (Mobile Phone, Home Phone, Business Phone, Home Fax, Business Fax, Pager) to Google numbered format with correct type labels.
Automatically recognizes Outlook flat contact fields like Mobile Phone and Business Street.
Converts flat Outlook phone columns into Google numbered Phone 1/2/3 format with types.
Merges Outlook flat address fields into Google structured address format.
Converts Outlook M/D/YYYY birthdays to Google YYYY-MM-DD format.
Converts Outlook Categories to Google contact group format.
Files process locally in your browser. Contact data never leaves your computer.
Our company switched from Outlook to Google Workspace and I needed to move everyone's contacts. The Outlook CSV had flat phone columns that Google wouldn't recognize. I converted the entire export and all phone numbers, addresses, and categories came through correctly in Google Contacts.
Every time a client moves to Google Workspace, contact migration is the painful part. I converted their Outlook Contacts CSV exports and the numbered phone fields mapped perfectly. Birthday reformatting from M/D/YYYY to Google's format saved me from fixing dates manually.
My Outlook contacts had home and business addresses that kept disappearing when I tried importing to Google directly. After converting with this tool, both address types showed up properly in Google Contacts. The category-to-group mapping kept my client segments intact.
Issues you might encounter when importing Outlook Contacts CSV Export data to Google Contacts CSV - and how we solve them
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
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
No server round-trips. Your Outlook → Google data is processed entirely in the browser tab.
The moment you close the page, all Outlook → Google data is wiped from browser memory. No traces left.
Meets GDPR requirements by design — no data processing on external servers, ever.
Buy bundles and get up to 60% off. Perfect for recurring monthly conversions.
All available data flows from Outlook to Google
This platform pair is available in 2 other hubs
Help us improve—what stopped you today?
Enter your email to claim your welcome bonus
SpreadsheetBroccoli