HomeHow ToHow to Convert Excel xlsx to Vcard vcf File

How to Convert Excel xlsx to Vcard vcf File

After a long time, we are here with a completely different tutorial. When you export data, especially contacts, they are sometimes exported in xls or xlsx format. This is a general format and can be opened almost on any computer. However, some software only allows importing data or contacts from vCard, i.e., .vcf format.

First of all, let’s learn something about vcf and Excel files:

What is a vCard VCF File?

It is a file format that stores contact information like name, phone number, email address, home address, and many more. The structure of the vcf file looks like this:

BEGIN:VCARD
VERSION:3.0
N:FirstName;LastName;;;
FN:First Last
TEL;TYPE=CELL;TYPE=PREF:9999999999
END:VCARD

What is Excel (xls/xlsx) File?

It is a file format that Microsoft Excel generally creates. Up to Microsoft Excel 2003, the extension was xls, and for Microsoft Office 2007 & later, the extension is xlsx. It is generally used by most of the organizations and businesses. That’s why having xlsx file instead of vcf is very important.

If you try to google this, you will find amazing results. You will find various paid software to do the same. Unfortunately, you will not be able to find any free one. This is because converting from xlsx to vcf is a two-step process. Let us see how we can Convert Excel xlsx to vCard vcf File:

Converting the xls or xlsx file to a csv file using Microsoft Excel

  1. Open your Excel file in Microsoft Office.
Excel Contacts File
  1. Arrange the data if not already arranged.
  2. Click File and click Save As.
  3. Click Browse and select the location where you want to store the file.
  4. Select CSV(Comma delimited)(*.csv) in Save as type.
Save Excel File As Csv

Method 1: Using textcompare.org to Convert CSV to vCard Online

  1. Go to https://www.textcompare.org/csv/csv-to-vcard/
Textcompare Csvtovcard Home
  1. Click Choose CSV File and select the file CSV file we generated earlier. 
Textcompare Csvtovcard Csv File Upload
  1. The contents of the CSV file will be populated in the left text area. 
Textcompare Csvtovcard Csv Imported
  1. Select all the blank data that contains no essential details at the end and remove them. 
Textcompare Csvtovcard Select Blank Data
  1. Now, click Process
Textcompare Csvtovcard Data Sanatized
  1. You will see vCard Options in the right section below the text area. 
Textcompare Csvtovcard Vcard Options
  1. Map your CSV Column Name with the vCard Property Name. In this case:

    Full Name -> Full Name
    Phone -> Phone
    Email -> Email
    Job Title -> Job Title

    and the fields that you don’t want in the generated vCard or the empty fields to (ignore)
  1. Click Build to populate the right text area with vCard format.
Textcompare Csvtovcard Vcard Conversion Complete
  1. Click on Save to download the vCard vcf file.  
Textcompare Csvtovcard Vcard Download Complete

Method 2: Using csvtovcard.com on Windows Computer to Convert CSV to vCard

  1. Head over to www.csvtovcard.com and download their software. (Size <1MB)
Csvtovcard.com
  1. Install it on your computer and open it.
  2. Select the CSV file you just exported. Select the format you want to export it in. (Single file or Separate file for each row)
  3. If attributes/vCard property is not identified automatically, specify it manually.
Csv To Vcard Settings
  1. Click Convert. Your file will be converted in seconds.

Also read: 6 Ways to Run Windows on Mac

So these are two of the best methods that you can use to convert your Excel file to vCard vcf files. Let us know if you have difficulties following the steps in the comment section below. 


“As an Amazon Associate & Affiliate Partners of several other brands we earn from qualifying purchases.” [Read More Here]


48 COMMENTS

  1. Excel to vCard Converter is a professional and multi- featured utility that is widely used to convert

    spreadsheet contacts into vCard or VCF format. With the help of this tool users can migrate Excel databases

    without losing any single data.

  2. Hey i wanted to thank you so much your tutorial saved me a lot of time and work i had more than 800 contacts to add the only problem
    I had is to convert the sheat from excel format to csv it shows all the data in one column, so what i did is converting it in google sheats and it worked so happy thanks again.

Leave a Comment

Please enter your comment!
Please enter your name here


By submitting the above comment form, you agree to our Privacy Policy and agree with the storage and handling of your data by this website.


Stay Connected