1 / 14

How to Import Contacts in Gmail from Excel Spreadsheet

Get easy solution for how to import contacts in Gmail from excel file. Watch online presentation to confirm all steps requied in Excel to vCard conversion.

ellicastren
Download Presentation

How to Import Contacts in Gmail from Excel Spreadsheet

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. How to Import Contacts in Gmail from Excel Sheet ? Solution is Here: • No Free Option Available to Import • VBA Scripts to Convert Excel Contacts to vCard • Software:SysToolsExcel to vCard • Steps to Import .VCF File (vCard) in Gmail

  2. No Direct Option “To Import Contacts in Gmail from Excel Sheet “ Gmail not let importing contacts from directly excel sheet to Gmail account do so you need to convert Excel contacts to vCard first.

  3. Convert Excel to vCard using VBA Scripts • Open your Excel File which contacts you want to export as vCard • Now press Alt+F11 (A Window will pops-up on your screen) • Double click on desired sheet from the list and paste VBA Scipt Sub Create_VCF() …… …….. End Sub • Press F5 to execute the code. • All Excel contacts will exported to a VCF file.

  4. How to Convert Excel Contacts to vCard ? • Option to create a single VCF file for all contacts • Export unlimited contacts from Excel file (tested on 40,000 + contacts) • Export vCard into 3 formats like: vCard 2.1, 3.0 and 4.0 versions • Allow Empty Email address to be imported • Field to Field mapping for Excel contacts and vCard You can use VBA script to export Excel contacts to vCard but it is difficult to use so I would like to suggest an automated SysTools Excel to vCard converter tool for this task. It allows users to export entire excel contacts to separate or single VCF file according to user requirement. Features Provided by Application:

  5. Steps to Export Excel Contacts to vCard Step-1: Browse Excel File from your PC

  6. Step-2: Software will scan and preview entire fields

  7. Step-3: Map columns between Excel fields and vCard fields

  8. Step-4: Now check the box (single vCard file for all contacts) and vCard version

  9. Step-5: After choosing options click the convert button to get a VCF file

  10. Now Import Exported VCF File to Gmail Once you exported excel to vCard then import that VCF file to Gmail account manually. Just follow given below guidance to import VCF file to your Gmail account. Step-1: Login you Gmail Id >> Move to Contacts

  11. Step-2: Now Click on More and select import function from the list

  12. Step-3: Click Choose file to Select your VCF file from your PC and Click Import

  13. All Contacts Imported Successfully Now you can click on every contact to see how information in it got saved.

  14. Thanks For Visiting All Slides

More Related