How to Convert Excel Contact to Google Sheets? Top 2 Ways
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
- The software will then display the following screen. Select the desired MS Excel file and click the Open button
- To match Excel fields to vCard fields
- Next, provide a location to save the generated files. Click Change
- After this, click the “Convert” button to start the conversion process.
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.