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

Subscribe to our Newsletter

Stay updated with all the latest news, offers and special announcements.

By signing up, you agree to our Privacy Policy and agree with the storage and handling of your data by this website.

Latest Posts

How to Monitor the Raspberry Pi’s Temperature

Raspberry Pi has gotten very powerful over the years, especially with the launch of Raspberry Pi 5. Putting things in perspective, currently, we are...

How to Uninstall a Package on Ubuntu (GUI & Terminal)

Ubuntu is one of the widely used Linux distributions. Many people, including me, started my Linux journey with it. It is one of the...

Understanding YouTube Monetization | What Do You Need to Know

Do you want your captivating content on YouTube to turn into real income? Then look no further! We have just the guide here for...

What Are The Advantages & Disadvantages Of Android TV

In today's technological age, Android TVs are all the rage. Based on the Android ecosystem, Android TVs offer a range of features and functionalities....

How to Disable IPv6 Permanently on Raspberry Pi

On paper, IPv6 is a great thing because there are 340 undecillion addresses available, and it can be allocated uniquely to every device connected...

All Time Favorites

11 Best WiFi Hacking Apps for Android (2023)

Today, almost anywhere we go, we are surrounded by tons of WiFi Networks, whether at our homes, hotels, workplaces, or even public places like...

17 Best Illegal Android Apps Not on Play Store (2023)

Google Play Store has the most extensive collection of apps for Android. Almost everyone downloads apps from the Play Store. However, certain genuinely excellent...

15 Best Game Hacking Apps for Android (2023)

Are you a mobile gamer? If you are, then you've come to the right place. This post will tell you about the Best Game...

How to Download Torrent Files with IDM (Torrent to IDM)

Hey guys, you may all have heard about different ways to download torrent files. And some of you may also have downloaded them using...

11 Best Download Managers for Windows

The Internet is a vast resource of a lot of things which includes music, videos, movies and a lot of other things. The ability...