Live Chat
Home » Import » Technology » How to Import Contacts from Excel to Google Contacts?

How to Import Contacts from Excel to Google Contacts?

Sherry James | Modified: 2023-01-04T10:58:52+00:00

If you want to import contacts from Excel to Google Contacts, you must make sure your contacts are first converted to vCard format. Some users have a huge amount of contacts stored in an Excel sheet which is required to be saved as a VCF file since Google doesn’t support importing XLS/XLSX files. This creates an issue for the users who have no knowledge of exporting the files to Gmail manually.

Now, as we know that Microsoft Excel is used to store and manage a huge amount of data and most users prefer saving contacts in a spreadsheet. This spreadsheet stores details like the first name, last name, phone number, email address, etc. The data is saved in XLS/XLSX file formats that are known to be non-accessible in Google contacts which is why this blog explains the solutions to transfer Excel file contacts to Google Contacts.

Let’s understand the need for such a solution by taking a look at the following user query.

User QueryThere are multiple contacts that I want to add to Gmail that is stored in an Excel spreadsheet as Gmail helps with accessing contacts on my mobile. Although, I have no clue on how to do that since I know that XLS files are not supported by Gmail. Is there any solution that can help me out in this situation? I really need some contacts to be saved on Gmail which is pretty important.

We have found various users asking similar queries for which we have decided to write this blog. Let’s get going!

How to Import Contacts from Excel to Google Contacts?

Here, we have got two solutions that users can make use of and choose which one is the right one for them. Both the methods are divided into two parts i.e. conversion and importation. Check out these methods as shown below:

Both the solutions are explained below. Let’s get started with the first method.

Instant Approach to Import Excel Contacts to Google Contacts

Google contacts only support CSV and vCard file formats to import the contacts and access them. With the help of the Excel Contacts to VCF Converter Tool, you can easily convert your files and save them as vCard files to your local storage device. Since vCard is an electronic business card, it stores the details of the contacts and is compatible with Android, Outlook, Google Contacts, iPhone, etc.

This tool will easily convert the data files with no risk of data loss and no file-size restrictions. It is compatible with all the Windows versions such as Windows 10, 8, 7, and below versions. There are various features offered by this tool to transfer Excel file to Google Contacts that you can make full use of as listed below:

  • It offers an option to Map Excel columns with the vCard fields
  • Preview the Excel spreadsheet with all the rows and columns
  • Capable of converting multiple Excel files in batch mode
  • Option to create a single VCF file for every contact
  • There is an option to import empty email addresses as well
  • Also, provides multiple naming convention options during the migration process
  • It is important to have Excel installed on your system during the conversion

Other than this, the tool has a pretty easy-to-understand interface which makes the conversion procedure easier to undertake. Let’s take a look at the steps for it.

Section 1: Steps to Import Contacts from Excel to Google Contacts

Now, follow the following listed steps to start the process to import:

  • Download the Software and click on the Browse button to add the files to the software

Browse Excel file

  • Select the files from the storage and click on the Open button. Hit Next

Open Excel file

  • Now, map the Excel Fields with the vCard Fields and hit Next

map the Excel Fields with the vCard Fields

  • Mark Allow Empty Email Address to be an Imported option and choose the vCard version as per your requirement

Select vCard Version

  • Click on the Change button and choose the desired location for the result. Hit Convert

Click on Convert button

  • Once the process is completed you will be able to view the converted files in your desired location. Let’s get going to the method to import these files to Google Contacts.

Section 2 – Import vCard Contacts  to Google Contacts

  • Enter the Credentials for your Gmail Account to log in

login your Google account

  • Select the Google Apps icon and choose Contacts from thereClick on Contacts
  • Now, a new window will open up. Click on the Import option there

click on import

  • Choose the Select File option and choose the vCard file you have just converted

Select File option

  • Once the files are added, hit the Import button and wait for the process to finish.

click on import

This way, all your contacts will be imported to Gmail without any data loss in an accessible file format. Now, for those users who won’t go for not so reliable but a free method. Skip to the next section.

Manually Import Contacts from Excel to Google Contacts

The manual solution is also divided into two different segments that we are going to explain below. First, we will be converting the files into CSV format and then importing the converted data into Gmail. The following segments contain the methods for each.

Section 1 – Converting Excel Spreadsheet to CSV

  • Start by arranging the information properly in an Excel sheet
  • Create separate rows and columns for the First Name, Last Name, Phone Number, etc
  • Click on the File tab and choose Save As option
  • Mark CSV format and hit Save.

Now, complete the process by importing these files.

Section 2 – Import Excel  File to Google Contacts as CSV Format

For this method, follow the steps shown in section 2 of the instant solution. You just have to add the CSV file that you converted and follow the procedure as same.

Closing Lines

Contacts are an integral part of a user as these contacts hold a lot of information about a user than just the name and the number like company name, email address, home address, etc. All of this information can easily be stored in an Excel spreadsheet since it stores data in rows and columns. Now, these contact files cannot be used on the mobile phone of a user. For that, users have to import contacts from Excel to Google Contacts to be able to use these contacts from their phones as well.