Learn how to Import contacts from other Email services into Gmail using CSV File?

Gmail is set to create a new contact automatically for every email you send. However, you have to enter the email addresses of all the contacts at least once before Gmail starts to auto-complete them. In case you have all these contacts stored in other email services such as Hotmail, Yahoo, outlook then you can import addresses from other Email services into Gmail.

The most convenient way to import address from other email services into Gmail is by using .CSV (Comma separated values) file. These are simple files that hold the data in a plain text format. In this article, we will describe how you can use CSV file to import addresses from other Email services into Gmail.

Exporting Address from other Email services into CSV file.

First of all, you need to get the contacts stored in other email services exported to CSV file before importing them into Gmail.

Exporting Contacts from Outlook to CSV file

  • Firstly, open Outlook Desktop app on your computer.
  • Sign in and click on “File” Tab from the top left corner.
  • Now from the left sidebar, click on “Import and Export”.
  • Open “import/export setting” from the menu opened.
  • Choose “Export to a file” and click “Next”.
  • Select the CSV (comma separated Values) in create a file of type option and click “Next”.
  • Choose “Contacts (This computer only)” and tap on next button.
  • Name the file as per your preference and choose the location where the file to be stored.
  • Finally, click “Finish”.

Now the contacts from your outlook have been successfully exported to a CSV file.

Exporting Contacts from Yahoo to CSV file

  • Open the full version of Yahoo mail and sign in with your login credentials.
  • Now click on contacts tab from the left navigation bar.
  • Click on the “Actions” dropdown box.
  • Choose “Export” from the opened menu.
  • Click the “Export Now” button beside the “Yahoo! CSV”.
  • As soon as you click on the “Export Now” button, you need to enter the CAPTCHA’s code.
  • Now click on the “Export Now” button once again.
  • The contact will automatically save to a CSV file named as “Yahoo_ab.csv”.

As the contacts from other email service have been exported to the CSV file. Now, it’s easy to Import contacts from other Email services into Gmail using CSV File.

Import Addresses from other Email services into Gmail using CSV File

Follow the instructions given below to import contact into Gmail via .CSV file.

  1. Open Gmail and log in using the email id in which you want contacts to be imported.
  2. Click on “Gmail” dropdown from the top left corner.
  3. Click on the “Contacts” button.
  4. Open “More” drop down from the side panel.
  5. Click “Import” from the opened menu.
  6. Select”CSV or vCard” file.
  7. A message will appear with a link to older version of Gmail contact. Click on the “Go to old version” link.
  8. Now, Click “Import contact” from the left side menu.
  9. Click “Choose file” and browse the location where the CSV file is stored.
  10. Select the CSV file to be imported and click “open” button.

That’s all you need to do in order to import address from other Email services into Gmail using CSV File.

Points to remember

  • Some email service provider has a bit complex process of exporting the contacts to CSV file. For Example – Apple Mail, it doesn’t provide an option for direct export of contacts to a CSV file. The Mac users have to download an app called “Address book to CSV Exporter” in order to export Mac contact to CSV File.
  • It is possible that exported CSV file does not have the headers such as contact name, Email Address etc. These headers are necessary in order to Import addresses from other Email services into Gmail. You may use a plain text editor or a spreadsheet program to add a header to the CSV file.
  • Soon, Gmail will have a feature to import contacts from more than 200 sources as such AOL, Yahoo, Outlook, Apple etc. without using a CSV file. The import will be handled by the Shuttlecloud which is a third party app. Users have to provide a temporary access to shuttlecloud in order to import addresses from other email services into Gmail.