Vovsoft Logo
Vovsoft Facebook Page Vovsoft Twitter Account
Menu
Home » Blog Posts » How to Create CSV Files to Import into Gmail

How to Create CSV Files to Import into Gmail

Date Last updated 1 month ago
*****
Rate this blog post
How to Create CSV Files to Import into Gmail Image

What is a CSV file?

CSV (Comma Separated Values) file is a plain text file that contains a list of data. These files are often used for exchanging data between different applications. For example, databases and contact managers often support CSV files. These files may sometimes be called Character Separated Values or Comma Delimited files. They mostly use the comma character to separate (or delimit) data, but sometimes use other characters, like semicolons.

You can export complex data from one application to a CSV file, and then import the data in that CSV file into another application.

How to import CSV files into Gmail?

If you want to convert your contacts (VCF file) to a CSV file and import it into Gmail:

VCF to CSV Converter

  1. Download VCF to CSV Converter and run the application.
  2. Click "Load vCards from VCF File" button and select your VCF file.
  3. Click "Export to File" button.
  4. Select "Comma-Separated Values File".
  5. Select "Google CSV Format".
  6. Go to Gmail Contacts.
  7. Import the CSV file into Google Contacts. That's all! Checkmark

Google Contacts Import

Alternatively, if you want to create a CSV file for your contacts manually:

  1. Create a new document in Microsoft Excel (or LibreOffice Calc).
  2. Add a column heading for each piece of information you want to record (for example, first name, last name, email address, phone number), and then type the information in the appropriate columns.
  3. Select File > Save As.
  4. Use the drop-down box to select CSV (Comma delimited) (*.csv), give your file a name, and then select Save.
  5. Save your Excel file as a CSV file.
  6. You can now use this new CSV file to import your contacts into Gmail.

Download Sample CSV file for importing contacts into Google.csv

Excel CSV Import Into Google

Header Fields for Google CSV Files

  • Name
  • Given Name
  • Additional Name
  • Family Name
  • Yomi Name
  • Given Name Yomi
  • Additional Name Yomi
  • Family Name Yomi
  • Name Prefix
  • Name Suffix
  • Initials
  • Nickname
  • Short Name
  • Maiden Name
  • Birthday
  • Gender
  • Location
  • Billing Information
  • Directory Server
  • Mileage
  • Occupation
  • Hobby
  • Sensitivity
  • Priority
  • Subject
  • Notes
  • Language
  • Photo
  • Group Membership
  • E-mail 1 - Type
  • E-mail 1 - Value
  • E-mail 2 - Type
  • E-mail 2 - Value
  • Phone 1 - Type
  • Phone 1 - Value
  • Address 1 - Type
  • Address 1 - Formatted
  • Address 1 - Street
  • Address 1 - City
  • Address 1 - PO Box
  • Address 1 - Region
  • Address 1 - Postal Code
  • Address 1 - Country
  • Address 1 - Extended Address
  • Organization 1 - Type
  • Organization 1 - Name
  • Organization 1 - Yomi Name
  • Organization 1 - Title
  • Organization 1 - Department
  • Organization 1 - Symbol
  • Organization 1 - Location
  • Organization 1 - Job Description
  • Website 1 - Type
  • Website 1 - Value

VCF to CSV Converter Icon VCF to CSV Converter Windows


Continue Reading


Leave a Comment