Friday, September 26, 2014

How to import Excel File Contacts into Gmail Account


Excel is a widely preferred spreadsheet application developed by Microsoft and comes with MS Office suite. It provide us many useful formulas and functions that help to manage large amount of data in a excel sheet. Most of professionals used this program for the personal as well as business purpose to save important contacts, account details, employee data and other information etc.

In other hand we are talking about Gmail that is the most popular online mail service provider developed by Google Inc. Gmail allow users sending receiving emails, storing contacts, calendars and managing tasks etc.

Why Need to Transfer Contacts from Excel to Gmail?

When a MS Excel user desires moving their contacts from xls file to Gmail account that time a most common query generated that is “how to import Excel file contacts to Gmail account”. So now here we will discuss stepwise solution to short out this query manually in less time and less effort. By unloading contacts to Gmail from Excel user can achieve several benefits:
  1. By sending xls contacts to Gmail account user can access them widely every time from everywhere.
  2. Imported contacts helps users in sending bulk emails to single or multiple persons which saves time
  3. Gmail contacts can be sync simply with email clients, mobile phones and other electronic devices
  4. Gmail also allow users for directly exporting contacts into most common vCard and CSV file format
Easy Steps to import Excel file Contacts into Gmail!

Before doing any task it is important to know everything about method so after reading above described information everything should be clear. Now follow only few simple and manual steps to short out how to Import Excel Contacts to Gmail. We have divided whole process in two sections as shown below:
  1. Export Excel Contacts as CSV File
  2.  Import CSV File into Gmail Account
Steps to Export Excel Contacts to CSV File


Step1: In the very first step, create a duplicate file for backup purpose. 

Open your Excel spreadsheet where all contacts are stored


Step2: If you are using MS Office 2007 then Click on Office button, Click on Save as button 


Step3: Select CSV from Save as type list >> Provide a desired name and save the file
 

Step4: A confirmation message pops-up >> click on Ok button

 
Step5: A confirmation message spark again >> Now press Yes button 

 
Step6:Through this method you can move all Excel contacts to a CSV file 


Note: For MS Office 2010 users there is direct method to save Excel file as CSV file.
 
 Steps to Import CSV File into Gmail Account
Step1: Open Gmail and provide credentials to Login into account

Step2: Now click on contacts from the top right corner

Step3: Click on more button and select Import 
 
Step4: A window will pops-up on your screen >> Now click the choose file button and browse CSV file from your computer >> finally click on Import button to finish the process.

Step5: Now you can see all contacts are imported in your Gmail account.

 
Final Words: In the last section I want to say one more thing that it is better to use this easy manual method for moving excel contacts to Gmail instead using a paid solution. All possible steps are described here to get over this task. Apart from importing contacts you can get details about MS Excel and Gmail contacts in deep.

No comments:

Post a Comment