Banner

How to Import Contacts from Excel to Google Contacts (Gmail)

Published On - July 20, 2022 by Nasir Khan |

Reading Time: 5 minutes

MS Excel is one of the popular tool for storing data in an organized way. In Excel, you can store large data on spreadsheets, add diagrams, insert pie charts, save contacts and much more. All the data in MS Excel is store in .XLS or .XLSX format. When we talk about ‘How to Access Excel Contacts to other platform‘ or users want to import Contacts to Phone, Outlook, Thunderbird, iCloud or other platforms that does not support Excel files. The Excel files must be converted to vCard (VCF) file format before importing them to other systems.

About vCard File Format

vCard (VCF) is an electronic business card file format standard. vCards allows generating and exchanging contact information through the Internet such as in email and instant messaging. vCard file format is compatible with almost all devices, email clients, email services, and cloud services. Once Excel contacts are converted to vCard file format, they can be imported into MS Outlook, Android Phone, iPhone, Thunderbird, Gmail, WhatsApp, and other applications.

Google Contacts (Gmail) only supports CSV and vCard files. If the contacts are store in Excel (.xlsx or .xls), first convert the excel file to CSV or vCard format. This can be done with Google Sheets or MS Excel.

2 Free Manual Methods to Convert Excel files to CSV format

1st Method: by Using Google Sheet

Steps to convert Excel File to CSV File with Google Sheet

  1. Open the Web Browser and go to Google Drive.
  2. Sign in.
  3. Upload the Excel file having the contacts that you need to import to Google Contacts (Gmail).
  4. Right-click the Excel file and select Open with > Google Sheets.
  5. Select File > Download > Comma-separated values (.csv, current sheet).
  6. How to Import Contacts from Excel to Google Contacts

2nd Method: To import contacts from Excel to Google Contacts, you need to perform three steps:

  1. Convert Excel file to .csv file.
  2. Import Contacts from CSV file.
  3. Export contacts to VCF file format.

Step 1: Convert Excel to CSV Format in MS Excel

Perform the below steps for converting Excel file to CSV file format:

  1. Open the Excel file.
  2. Click the Office button at the top corner of Excel window.
  3. Click Save As > Other Formats.
  4. How to Import Contacts from Excel to Gmail
  5. The Save As dialog box opens. Select the folder or location for saving the file.
  6. In Save As type option, click the drop-down menu.
  7. Select the option CSV (Comma delimited).
  8. Click Save.
  9. Stesp to export Excel Contacts to vCard file

The Excel file is now converted to CSV file format.

Step 2: Import Contacts from CSV File

Perform the below steps to import contacts from CSV file:

  1. Go to Start Window and type contacts.
  2. Click the contacts icon to open a contact window.
  3. Select the users available and click the Import tab.
  4. Select the format as CSV (Comma delimited) file.
  5. Manual Steps to Save Excel file to CSV format
  6. Select the CSV file created before, click Next.

The excel contacts will be imported.

Step 3: Export Contacts to VCF

Perform the below steps to export contacts to VCF file:

  1. Go to the Contacts window, click Export.
  2. Select the option vCards (folder of.vcf files).
  3. Click Export.
  4. Manual ways to export Excel file data
  5. Select the folder to save the converted files.

The Excel file gets converted to VCF file format.

Now Importing Excel Contacts (CSV or vCard Files) to Gmail with Google Contacts

  1. Login to your Google account.
  2. Click on “Google Apps icon” and select “Contacts”.
  3. On the left, click Import.
  4. Import vCard files to Gmail
  5. In the Import Contacts wizard, click Select file.
  6. How to Import Contacts from Excel to Google Contacts
  7. After selecting the CSV file, click Import.
  8. Manual Steps
  9. Under the Labels section, find the contacts imported.
  10. Select all the contacts, then click the Add to contacts icon.
  11. Free Manual Guide

Limitations while importing Excel Contacts to Gmail with Google Contacts

  • Allows importing 3000 contacts at a time. If you have more than 3000 contacts, split them into multiple CSV files before importing.
  • There is a limitation of 25000 contacts.
  • In case contacts aren’t formatted to work with Google Contacts.
  • Contacts must be saved as a vCard or CSV file.

Professional Tool to convert MS Excel Contacts to vCard File

If you are looking to convert your MS Excel contacts file to MS Outlook PST file, then Regain Excel to PST Converter is the professional tool available. The software supports converting .xls, .xlsx, and .csv files to Outlook PST, MSG, vCard and ICS files.

Regain Excel to PST Converter Software Features

  • Exclude duplicate contacts before conversion.
  • Convert Excel Spreadsheet Contacts to vCard format
  • Facilitates skipping empty email addresses.
  • Displays preview of all contacts from the Excel file before conversion.
  • No file size limit to convert Excel contacts to vCard files.
  • Compatible with all versions of MS Excel and MS Outlook.
  • Available as a free trial version.

Export Contacts from Excel File to vCard format with Easy 5 Step Process

Using Regain Excel to PST Converter software to convert MS Excel contacts file to vCard format, you need to perform only the 5 steps as listed below:

  1. Launch Regain Excel to PST Converter software.
  2. Browse and add Excel file for conversion.
  3. See preview of all Excel file contacts.
  4. Map columns of Excel and Outlook.
  5. Select destination path and target format as ‘Save to vCard‘.

Regain Excel to PST Converter: Free Trial

Excel to PST Converter software is available as a free to download trial version. Download the free demo version and check the offered functionalities of the software. The only limitation with the Excel to PST Converter free demo version is that it saves only 30 contacts per Excel file. To save unlimited contacts per Excel file, purchase the full licensed version of Excel to PST Converter software.

Conclusion

This article discusses the manual method for converting contacts from Excel file to Google Contacts. Also, if you are looking to convert Excel contacts to vCard format, this article recommends using the professional third-party Excel to PST Converter software.

https://secure.gravatar.com/avatar/634e2b272d33cc8cd0af4cf5f65e6336?s=96&r=g

Author: Nasir Khan

I am Nasir Khan from India, working as a Content Developer in Regain Software. Here I am writing about our products and their updates. And writing some free solutions from converting emails or Cloud Migration process. We have tools like Email Converter, Emails backup and Cloud migration.

Leave a Reply

Your email address will not be published. Required fields are marked *

  +  12  =  20