Google Column Detection
Automatically recognizes Google Contacts numbered fields like E-mail 1 - Value and Phone 1 - Type.
Google Contacts to Outlook CSV Converter Free
or drop files here .csv, .xls, .xlsx, .xlsm (up to 50 MB)
Free 5-row preview · No sign-up required
Invoice import blocked if Sales Tax enabled in QBO
Convert Complete
Your converted file is ready!
Download now before closing this page
Outlook Contacts CSV Format
Showing valid rows only (download includes all rows + errors)
All rows valid
| $ |
|---|
+ more rows
valid rows
invalid rows skipped from preview
credits
| Row | Column | Value | Error |
|---|---|---|---|
Showing first 50 errors. more errors not shown.
more errors hidden. Download the full validation report to see all errors.
Validation Report Download
The download includes your original file with an added "Validation Error" column showing error messages for each row. Valid rows have an empty error column.
• credits
Use credits to download
Click any download button to use your credits
- Full CSV & Excel export
- Google Sheets export
- Instant browser download
for credits
One-time payment
256-bit SSL encryption
14-day money-back guarantee
PCI DSS compliant
Powered by Paddle
Want to save on credits?
Buy bundles and get up to 27% off. Perfect for recurring monthly conversions.
Liked the preview?
Upload your actual file to get the real conversion
Transform your Google Contacts export into a properly formatted CSV ready for Microsoft Outlook import.
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 Google Contacts CSV
Sample Google Contacts export with standard column format
How to Convert Google → Outlook
1
Open Google Contacts
Go to contacts.google.com and sign in to your Google account
2
Export contacts
Click Export in the left sidebar, select Google CSV format, click Export
3
Upload and Configure
Upload Google Contacts CSV Export CSV and choose Outlook Contacts CSV format
4
Preview and Download
Review converted data, download Outlook-ready file
5
Open Outlook
Open Microsoft Outlook desktop app
6
Import contacts
File → Open & Export → Import/Export → Import from file → CSV → Browse to file → Map fields → Finish
Output is in Outlook Contacts CSV format — ready to import directly, no manual reformatting needed.
Field Mapping
How Google Contacts fields map to Outlook Contacts Csv
| Google Contacts | Source Value | Outlook Contacts Csv | Target Value | Note | |
|---|---|---|---|---|---|
Given Name |
John |
→ | First Name |
John
|
Direct mapping |
Additional Name |
Michael |
→ | Middle Name |
Michael
|
Direct mapping |
Family Name |
Doe |
→ | Last Name |
Doe
|
Direct mapping |
Name Prefix |
Mr. |
→ | Title |
Mr.
|
Name prefix (Mr., Dr.) |
Name Suffix |
Jr. |
→ | Suffix |
Jr.
|
Name suffix (Jr., III) |
E-mail 1 - Value |
john@gmail.com |
→ | E-mail Address |
john@gmail.com
|
Primary email |
E-mail 2 - Value |
john@company.com |
→ | E-mail 2 Address |
john@company.com
|
Secondary email |
Organization 1 - Name |
Acme Inc. |
→ | Company |
Acme Inc.
|
Company name |
Organization 1 - Title |
Engineer |
→ | Job Title |
Engineer
|
Job title |
Organization 1 - Department |
Engineering |
→ | Department |
Engineering
|
Department |
Website 1 - Value |
https://example.com |
→ | Web Page |
https://example.com
|
Website URL |
Birthday |
1990-01-15 |
→ | Birthday |
1/15/1990
|
Date format: M/D/YYYY |
Notes |
Met at conference |
→ | Notes |
Met at conference
|
Direct mapping |
Group Membership |
myContacts ::: Friends |
→ | Categories |
myContacts ::: Friends
|
Strip '* myContacts :::' |
Data Transformation
Each Google contact becomes one Outlook contact row
Input
Google Contact Row
Google Contacts CSV row with numbered multi-value fields
Key columns:
Given Name,
Family Name,
E-mail 1 - Value
1:1 — One input row creates one output row
Output
Outlook Contact Row
Name mapping
Phone routing
Address mapping
At least Given Name or Family Name required
Google → Outlook Conversion Questions
How do I export contacts from Google?
Go to contacts.google.com, click Export in the left sidebar, select Google CSV format, and click Export. This downloads a CSV file with all your contacts.
How do I import the result into Outlook?
In Outlook, go to File, Open & Export, Import/Export, select Import from another program or file, choose Comma Separated Values, and select the converted CSV file.
Are phone numbers mapped correctly?
Yes. The tool reads Google phone types (Mobile, Home, Work, Main, Pager, Fax) and routes each number to the matching Outlook column like Mobile Phone, Home Phone, or Business Phone.
Why Use the Google → Outlook Converter?
Smart Phone Routing
Routes Google phone types (Mobile, Home, Work) to correct Outlook columns automatically.
Address Restructuring
Converts Google multi-line addresses into flat Outlook address columns.
Birthday Reformatting
Converts Google YYYY-MM-DD birthdays to Outlook M/D/YYYY format.
Group to Category Mapping
Converts Google contact groups to Outlook Categories field format.
Browser-Based Privacy
Files process locally in your browser. Contact data never leaves your computer.
How People Use Google → Outlook
Our firm migrated from Google Workspace to Microsoft 365 and I needed to convert Google Contacts to Outlook format for 12 attorneys. The smart phone routing mapped Mobile, Home, and Work numbers to the correct Outlook columns automatically, saving me from manually fixing thousands of phone fields.
My boss switched from Gmail to Outlook and wanted every contact intact. I exported the Google CSV and converted it to Outlook format in one step. The address restructuring turned multi-line Google addresses into flat Outlook columns, and all birthdays reformatted from YYYY-MM-DD to M/D/YYYY without errors.
I keep all candidate contacts in Google but a client required everything in Outlook PST-compatible CSV. I converted my Google Contacts CSV to Outlook import format, and the group-to-category mapping preserved my labels like Candidates, Clients, and Referrals as Outlook Categories.
Why Google Contacts CSV Does Not Import to Outlook
The Column Mismatch
Google Contacts exports use numbered multi-value fields like E-mail 1 - Value and Phone 1 - Value. Outlook expects flat columns like E-mail Address and Mobile Phone. Direct import maps fields incorrectly or loses data.
What This Tool Does
Upload your Google Contacts CSV export. The tool remaps numbered Google columns to flat Outlook columns, routing phone types to the correct Outlook fields and reformatting dates and addresses.
No Data Loss
All contact fields are preserved during conversion including names, emails, phones, addresses, organizations, birthdays, and notes.
Common Outlook Contacts CSV Import Errors
Issues you might encounter when importing Google Contacts CSV Export data to Outlook Contacts CSV - and how we solve them
Missing Contact Name
Contact has no Given Name or Family Name
Given Name: (empty), Family Name: (empty)
Given Name: John, Family Name: Doe
Add at least a Given Name or Family Name to each contact
Contacts without names are skipped
Unknown Phone Type
Phone type not recognized (e.g., custom label)
Phone 1 - Type: Custom Label
Phone 1 - Type: Mobile
Use standard types: Mobile, Home, Work
Unknown types default to Business Phone
Your Google → Outlook Conversion is Secure
Client-Side Conversion
No server round-trips. Your Google → Outlook data is processed entirely in the browser tab.
Auto-Erased on Close
The moment you close the page, all Google → Outlook 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.
Go to contacts.google.com, click Export in the left sidebar, select Google CSV format, and click Export. This downloads a CSV file with all your contacts.
In Outlook, go to File, Open & Export, Import/Export, select Import from another program or file, choose Comma Separated Values, and select the converted CSV file.
Yes. The tool reads Google phone types (Mobile, Home, Work, Main, Pager, Fax) and routes each number to the matching Outlook column like Mobile Phone, Home Phone, or Business Phone.
The primary email (E-mail 1 - Value) is mapped to Outlook E-mail Address. Additional emails are mapped to E-mail 2 Address and E-mail 3 Address.
Contact photos are not included in CSV exports from either platform. Photos need to be re-added manually in Outlook after import.
Yes. Google Workspace (formerly G Suite) uses the same CSV export format as personal Google Contacts.
Google contact groups are converted to Outlook Categories. The tool strips the Google internal group prefixes and formats them for Outlook.
Google → Outlook Data Ecosystem
All available data flows from Google to Outlook
Also available as
This platform pair is available in 2 other hubs
🥦
Quick question before you go
Help us improve—what stopped you today?
🎉
Thank you!
Enter your email to claim your welcome bonus