How to Merge Outlook and Gmail Contact
Most of your business contacts are probably stored in your company’s computer using Microsoft Outlook. You might want to copy or move these valuable contacts to your Gmail account so that you can access them when you are away from the office or if you are planning to leave the company. To move your Microsoft Outlook contact list to Gmail or vice versa is not that complicated. A few steps away and you can get the work done:
Copy contact list from Microsoft Outlook (2003 or 2007) to Gmail Account:
1. Go to your Microsoft Outlook, open File>Import and Export.
2. Select “Export to a file” and click “Next”.
3. Choose “Comma-separated values (Windows)” and click “Next”.
4. Locate your contact list and click “Next”.
5. Assign a name to the file and save it. The file will be saved in .csv extension.
6. Now log in to your Gmail.
7. Click the “Contacts” on the left pane and subsequently select “Import” at the top right corner.
8. Click browse to locate the .csv file that you saved earlier.
9. You can click “Import” to start importing your contact. Of course you can add these imported contacts to a new group and you can name the group as well.
10. Once the importing process is completed, you will be indicated with the number of contacts added, merged or ignored if there were duplicates.
Copy contact list from Gmail Account to Microsoft Outlook (2003 or 2007):
1. Go to Gmail contact page, click to the “Export” at the top right corner.
2. Choose the list of contact that you want to export. Check the item “Outlook’s CSV format (for importing into Outlook or other application).
3. Click the “Export” button. The exported file will be named as “contact.csv” automatically. Click the “Save” button to save the file.
4. Now go back to your Outlook. Go to File>Import and Export>Import from another program or file. Click “Next” to proceed.
5. Choose “Comma-separated values (Windows)” and click “Next”.
6. Browse for the file created from Gmail. At the prompted Windows, you will be given options to deal with the duplicate entries. You can allow duplicates, replace duplicates , or do not import duplicates.
7. Click “Next” to proceed. Choose the destination folder, e.g. Contacts under Personal Folders for your account, verify the action, and click Finish to complete the whole exercise.
Related Articles
- Export, Copy and Transfer Hotmail Contacts to Gmail, Outlook or Another Account
- How to Transfer Emails from One Gmail to Another Gmail Mailbox
- View and Manage Contact Information via New Google Contacts Manager
- Synchronize MS Outlook and Google Calendar/Gmail With Free Sync Utility KiGoo
- Delay Sending of Email Message in Microsoft Outlook (Supports Gmail, Hotmail, Yahoo, AOL and all POP3/IMAP Mail)
- Uploader to Migrate, Upload and Import Emails and Contacts from Desktop Mail Clients to Google Apps Gmail Mailbox
- Access Hotmail in Outlook with Microsoft Office Outlook Connector
- Remove Skype Extra Contacts from Microsoft Outlook
- Contact Cleaner Helps to Detect and Clear Duplicate Contacts in Windows Mobile Devices
- How to Merge Multiple Sound Files Into One File With Merge MP3
Entries (RSS)
May 14th, 2009 13:36
Awesome post, But this can also be performed with Outlook Contacts to Gmail Contacts Converter Tool
January 1st, 2009 01:38
I have the same problem that Greg has. It won’t import them. The Google help tells me to “clean up” the CSV in Excel so I did that by removing all commas from the file and other things I could think of but it still won’t work.
I think this is less of a formatting issue because I ran a test and imported a CSV with only 1 contact and basic information like name and phone. That worked but only if the contact wasn’t already in my Gmail contact list. I think this also goes for contacts in the “suggested” list. I don’t want to delete them all from suggested though since there are some emails I’d like to retain.
December 22nd, 2008 22:14
It works well for Outlook 2003 and 2007.
December 22nd, 2008 20:40
Hey
Thanks for the tutorial. I followed the steps you described to import my outlook contacts into gmail but gmail couldn’t import them as there was an “unexpected error”. I tried on 2 systems and both did not recognized the outlook export. Any clue ?
Greg