Home » excel » How to Convert Excel Contact to Google Sheets? Top 2 Ways

How to Convert Excel Contact to Google Sheets? Top 2 Ways

author
Published By Kumar Raj
Aswin Vijayan
Approved By Aswin Vijayan
Published On February 8th, 2023
Reading Time 5 Minutes Reading

Are you having a large number of contacts saved in an Excel spreadsheet? Seeking a solution to import Gmail Google contacts effortlessly? You have certainly reached the right place. Here, we will provide you with the best available solution to convert Excel contact to Google Sheets.

In today’s write-up, we will keep you informed about the entire conversion solution in a hassle-free manner. But before that, we will know about Excel and Google Sheets in brief.

MS Excel is a widely accepted application for storing and managing a large amount of data. Most of the users are saving contacts with the complete information including the first name, last name, email id, address, and other related important data.

Whereas, Gmail is a free email service that is used to send and receive emails, and save contacts and calendars in a hassle-free manner. With the growing popularity of Google sheets, users are now storing their contacts in it. One of the reasons behind it is the security that it offers. One can easily synchronize their contacts with their phones, be it Android or iOS.

Subsequently, in the below sections we will encounter a user query. Following that, we will find an appropriate solution for XLS contacts to Google Sheets conversion.

How to Convert Excel Contact to Google Sheets?

“Google provides me the functionality to access my contacts due to which I want to import my contacts from Excel spreadsheets to Google Mail. But I don’t know how to save Excel contacts in Google Contacts because Google doesn’t support Excel XLSX files. Does anyone know a solution to upload Excel contacts to Gmail account?”

Manual Solution to Export Contact to Google Account

We are aware of the fact that Gmail does not support XLS / XLSX / XLSM formats. As a result, we are required to save the contacts into CSV file format and then import them into the desired Gmail account.

Follow the steps in a sequential manner to perform the process manually. Keep in mind that one wrong step would lead to loss of contacts.

Step 1. Save Excel into CSV File Format

  • Initially, you need to properly arrange the contacts in the XLS Spreadsheet
  • The next step is to Save the files into Comma Separated Values format.

Step 2: Import Generated CSV into Gmail

  • Sign in to your Gmail account >> click Google Apps Icon >> Contacts
  • From there, click on the Import option to convert Excel file to Google Sheets
  • In the new Import Contacts Wizard, choose the CSV file that you have created in Step 1 >> Click Import

Alas! By following the steps carefully you will be able to convert your contacts from Excel spreadsheets to Google contacts for FREE!!

But!? Is this really worth it? You need to think twice before opting for this method. It is well suited for those who are either technically sound or have already backed up their contacts.

Direct Solution to Convert Excel Contact to Google Sheets

Google supports both CSV and vCard file formats for importing contacts. One has to convert the contacts into vCard format using Excel to VCF Converter Tool. Then, these contacts can be easily imported into Google contacts. Other than this, a user can also import these contacts into various vCard-supported applications including Android Phones, iPhones, iCloud, Outlook, etc.

The tool is capable enough to easily convert contacts from Excel to Google Contacts without any sort of data alteration or modifications. In addition to this, the program well supports all the below and later versions of Excel and Windows OS, including 11. Users can free download the trial edition of the program for easy evaluation without spending a single penny. Let us learn how this tool actually works.

Few Easy Steps to Convert Excel Contacts File to Google Sheets

Follow the steps to convert XLS Spreadsheet into Google sheets in a sequential manner.

Step 1. Download the Software on your Windows machine and click on Browse

Add Excel File

  • The software will then display the following screen. Select the desired MS Excel file and click the Open button

Select the Excel file

  • To match Excel fields to vCard fields

Excel contacts attributes

  • Next, provide a location to save the generated files. Click Change

Search Location

  • After this, click the “Convertbutton to start the conversion process.

convert Excel to vCard

This is how you will be easily able to convert the desired contacts from an Excel sheet into the virtual contact files format. After the completion of the procedure, a pop-up will appear, click Yes.

The Final Verdict

We know how important contacts are to us in our day-to-day life. As a result, we have described the ways that a user can easily opt to import Excel contact to Google Sheets in a hassle-free manner. If you are a non-technical user and have contacts in bulk, then, we recommend you to go for the automated solution.

email-backup-banner