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
- Open your Excel file in Microsoft Office.
- Arrange the data if not already arranged.
- Click File and click Save As.
- Click Browse and select the location where you want to store the file.
- Select CSV(Comma delimited)(*.csv) in Save as type.
Method 1: Using textcompare.org to Convert CSV to vCard Online
- Click Choose CSV File and select the file CSV file we generated earlier.
- The contents of the CSV file will be populated in the left text area.
- Select all the blank data that contains no essential details at the end and remove them.
- Now, click Process.
- You will see vCard Options in the right section below the text area.
- 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)
- Click Build to populate the right text area with vCard format.
- Click on Save to download the vCard vcf file.
Method 2: Using csvtovcard.com on Windows Computer to Convert CSV to vCard
- Head over to www.csvtovcard.com and download their software. (Size <1MB)
- Install it on your computer and open it.
- Select the CSV file you just exported. Select the format you want to export it in. (Single file or Separate file for each row)
- If attributes/vCard property is not identified automatically, specify it manually.
- 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.
Dear Mehulbhai, I am a principal of a college, and in present circumstances, we have to create different groups on different platforms. In such times, Your article helped me a lot to create vcf file and that saved a lot of labour. frankly, when it asked me to download the app, I was a bit afraid that you might be hacker advising me so…but then thought that you are a Gujarati and wont hurt anyone and so proceeded….(Frankly I say)….Thanks again.
Hello Priyanka,
Was the conversion successfully done? If yes then try to open the VCF file on your computer and check whether it is proper or not.
Hi, I tried the whole process as per the steps given but at the end when i transfered the contacts to my phone it shows ‘couldn’t import the files’. Please help me to resolve this.
Hello Jignesh,
We are able to download the file from the URL that you mentioned above. Can you please check with another browser or maybe a VPN?
Yes, the link mentioned in the article is working fine. Although, here is the direct link: http://www.softsea.com/download/CSV-to-vCard.html