How to Import Excel Sheet Contacts to Gmail, and Google Contacts Directly ?

Google Contacts doesn’t import XLSX files directly. If your contacts are in an Excel spreadsheet, you need to convert them first before Gmail can accept them. The two-step approach here is: convert the Excel file to vCard (VCF) format, then import that vCard file into Google Contacts. This method works for any number of contacts and preserves all fields including custom ones.

The Turgs Excel to vCard Converter handles the conversion step. The import into Google Contacts uses the built-in Gmail interface. This guide covers both steps completely.

Why Import Excel Contacts to Gmail

Three practical reasons drive this task:

First, accessibility. Once contacts are in Google Contacts, they sync to every device with your Google account: Android phone, iPhone with the Google app, laptop, and tablet. Excel files require the spreadsheet to be open. Second, Gmail integration. Google Contacts integrates directly with Gmail autocomplete, Google Calendar, and Google Meet. When you start typing a name in Gmail, contacts from Google Contacts appear automatically. Third, deduplication and management. Google Contacts provides tools for merging duplicates and organizing contacts with labels that don’t exist in a static Excel sheet.

Manual Method: CSV Import

If your Excel file has simple fields (Name, Email, Phone), you can use the manual CSV method:

1. Open your Excel file, go to File, Save As, and choose CSV format.
2. Sign in to Gmail and open Google Contacts.
3. Click the Import option in the left sidebar.
4. Click Select File and choose your CSV file.
5. Click Import to upload the contacts.

The limitation is that Google expects specific column headers in the CSV. If your Excel file uses custom field names, they may not map correctly during import. For XLSX files with many fields or non-standard column names, use the Excel to vCard converter below for cleaner results.

Step 1: Convert Excel Contacts to vCard

Download and install the Turgs Excel to vCard Converter on your Windows machine.

Step 1: Launch the Excel to vCard software on your Windows machine.

Step 2: Click Browse and locate your Excel contact file. The tool supports both XLS and XLSX formats from any Excel version.

Step 3: Use the Contacts Fields Mapping option to match your Excel column headers to the correct vCard fields. For example, map your “Cell” column to “Mobile” and your “Work Email” column to “Work” email. This step ensures all fields transfer correctly, including custom ones not in the standard Google Contacts template.

Step 4: Choose your destination folder where the vCard file will be saved.

Step 5: Click Convert to start the Excel to vCard conversion. The tool processes all contacts in your spreadsheet.

Step 6: When complete, navigate to your destination folder to find the VCF file. It’s ready to import into Google Contacts.

Step 2: Import vCard into Google Contacts

Step 1: Sign in to your Gmail account and click the Google Apps grid icon in the top right corner.

Step 2: Choose Google Contacts from the apps list.

Step 3: In Google Contacts, click the More button in the left sidebar.

Step 4: Choose the Import option from the menu.

Step 5: Click Select File in the Import dialog box.

Step 6: Browse to and select the VCF file you created in Step 1.

Step 7: Click Import to upload the contacts to Google Contacts.

Step 8: Google Contacts creates a new group called “Imported” for the newly added contacts. Click on any contact to verify the fields transferred correctly.

Also read: How to Delete Duplicate Emails from Thunderbird for related contact management tips.

Limitations to Know

Frequently Asked Questions

Can I import contacts from an XLSX file directly to Gmail?

Gmail doesn’t support XLSX format directly. Convert the XLSX file to vCard (VCF) format first using the Turgs Excel to vCard Converter, then import the VCF file into Google Contacts. The converter supports all Excel versions including XLSX from Excel 2019, 2016, 2013, and 2010.

How do I import phone numbers from Excel to Gmail?

Use the Excel to vCard Converter to map your Excel “Phone” or “Mobile” columns to the corresponding vCard fields during the field mapping step. The converter preserves phone numbers with their type labels (Mobile, Work, Home) so they appear correctly in Google Contacts after import.

Will my custom Excel fields transfer to Google Contacts?

Yes, if you use the field mapping option in the converter. The Contacts Fields Mapping screen lets you match each Excel column to the correct vCard field. Fields that don’t have a direct Google Contacts equivalent are mapped to custom notes fields in the vCard output.

What happens to duplicate contacts during import?

Google Contacts detects potential duplicates after import and shows a merge suggestion. You can review and merge them selectively. The manual CSV method doesn’t filter duplicates before import, so you may end up with more duplicates to clean up afterward than with the converter’s structured output.

How many contacts can I import to Gmail at once?

Google Contacts accepts VCF files with multiple contacts in a single file. The practical limit is Google’s 25,000 contact per-account maximum. The Excel to vCard converter creates a single VCF file from your entire spreadsheet, so you can import all contacts in one step regardless of count, up to the Google limit.

Can I access imported Gmail contacts on my Android or iPhone?

Yes. Google Contacts syncs automatically across all devices signed into your Google account. Within minutes of import, the contacts appear in your Android Contacts app and in Gmail’s autocomplete. On iPhone, use the Google app or add your Google account to the iPhone’s Contacts settings to sync.