HomeHow ToHow to Convert Excel xlsx to Vcard vcf File

How to Convert Excel xlsx to Vcard vcf File


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


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

First of all, lets learn something about vcf and excel files:

What is Vcard VCF File?

It is a file format that is used to store contact information like name, phone number, email address, home address and many more things. 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 is generally created by Microsoft Excel. Up to Microsoft Excel 2003, the extension was xls and from Microsoft Office 2007 the extension is xlsx. It is generally used by most of the organizations and businesses. That’s why it is very important to have xlsx file instead of vcf.

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:

Steps to Convert Excel (xls/xlsx) to Vcard vcf File

Follow these steps to Convert Excel (xls/xlsx) to Vcard vcf File quickly:

  1. Open Excel File.

    Csv File For Vcard Conversion

    Open your Excel file in Microsoft Office.

  2. Arrange the data if not already arranged.

  3. Click File and click Save As.

  4. Click Browse and select the location where you want to store the file.

  5. Select CSV(Comma delimited)(*.csv) in Save as type.

  6. Head over to www.csvtovcard.com and download their software. (Size <1MB)

  7. Install it on your computer and open it.

  8. Select CSV file you just exported. Select the format you want to export it in. (Single file or Separate file for each row)

  9. If attributes/vCard property is not identified automatically then specify it manually.

  10. Convert the File

    Csv To Vcard Settings

    Click Convert. Your file will be converted in seconds.

Thank you for reading this post and keep connected to Tech Arrival to continue enjoying wonderful posts. Share your views about this post in the comment section below. If you are still having any query throw it in the comment section.

If you find this post helpful, don’t hesitate to share this post on your social network. It will only take a moment, and also it is quite easy and helpful for others

About Author

Mehul Borichahttps://techrrival.com
Mehul Boricha is the founder of Tech Arrival & Astute Links. He is a computer and smartphone geek from Junagadh, Gujarat, India. He is a Computer Engineer by Education & an Entrepreneur by Passion. Apart from technology geek, he is an audiophile & loves to connect with people.

47 COMMENTS

  1. are bhai gano saras article chhe. tamne khabar nathi tame mara life na ketla kalako bachavi didha chhe.

    Thank you very much.

    • Vaah. Bov j sau kehvay. Biju kai hoi to janavjo etle eni upar pan article lakhi nakhisu. 🙂

      English Translation: That’s great. If there are any other tutorials that are required do let us know. We will be glad to publish it.

  2. I have 200 entries in my CSV file, followed the instructions, appeared to work. Only one VCard was created. The first line.

    Suggestions on how to convert the whole CSV file into a batch of VCards?

    Thank you

    • Hello Valerie,

      That is simple. To create VCF file for each entry just select the option “vCard Folder(each contact create a VCF File)”. Hope this helps 🙂

  3. It Keeps telling me “No Vcard Property, Please select vcard property for CSV Feild.” What does that mean? I did select vcard property for csv feild but still it couldnt recognize 🙁 Please help.

  4. Hi,

    How should I arrange the data in excel? Could you give me an example for Full Name, Phone, Email and Job title?

    My csv is always messed up and the converter can’t identify the csv & vCard properties correctly.

    Thank you in advance!

    • Hello Rudi,

      It is very simple. I have included the screenshots here: https://imgur.com/a/r6JCk9D

      All you have to do is to arrange the CSV file as you require and map the columns with the respective VCard properties. Let me know if you encounter any problems.

  5. Hi. I imported all the Vcard to my galaxy tab. The name (first and last name) is correct. However the phone number is not recognized as “mobile number”. It only appear as “notes” as the most below. So I cant call or text with having no number in the “mobile number” slot. Can you advise?

  6. I had to open the csv-file in an Editor and to Exchange all “;” into a “,” and save it again. Than it worked properly. Thank you. It helped a lot.

  7. its not working after all csvtovard.com is not working after trying multiple times receives an error

    You don’t have permission to access /download/32236102/a9618c11f6aa5882d4cce06017b94032/Contact_Management/csvtovcard_setup.exe on this server.

  8. At step 8 of the article:
    1) I select the .csv file in csvtovcard application
    2) In the CSV Field of Properties section appear the columns of .csv file separated by “;”
    3) I’m not be able to identify attributes/vCard property because all columns of the .csv file are in the same line of Properties section

    Please, anyone might help me? tkx

  9. Hi Mehul,
    the email address I found in the contact page of csvtovcard.com website seems not working (I changed at with @). The server returns to my email an error.
    May you help me? Thx Matteo

    • Your data is wrong. CSV means comma ‘,’ separated not semicolon ‘;’. Replace all semicolons with commas. (Reply for the Email you sent us!)

    • 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?

  10. 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 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.

  11. 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 Dr. Iyer,

      I am glad that we were able to help you. Just FYI, if you are unsure about installing any app on your computer then you can try installing it it a Virtual Machine first so that your personal data is always safe from any malicious app.

  12. Dear Mehulbhai,

    We run an optical business, and I am trying to send bulk messages for offers and such in whatsapp business. However when I download the csv to v card, there is application error. It says NET framework missing. I am running on windows 7 64 bit. Thanks.

  13. 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

10 Best YouTube Playlist Downloaders

YouTube has become so popular that it is simply impossible to imagine a life without it. It is one of the best platforms for...

8 Best Bluestacks Alternatives You Should Use

Android emulators have been around for more than a decade now. So if you thought it is a new concept, you are wrong. Despite the...

12 Best Bookmark Managers You Should Use

There is a huge amount of content on the internet. Be it articles, blogs, videos, infographics, images, and even white papers. With so much online...

9 Best Free Online YouTube to MP3 Converters

As you already know, YouTube has the largest collection of music than most other websites. But the problem is you cannot listen to them...

22 Best Open Source Apps for Android

As you already know, Android is an open-source platform. This gives the freedom to smartphone manufacturers to shape it the way they want. Just...

All Time Favorites

18 Best WiFi Hacking Apps for Android

When you enter the hacking world, you would know that almost every basic tutorial you would search for on the net won’t be possible...

21 Best Android Apps Not on Google Play Store

Google Play Store has the most extensive collection of apps for Android. Almost everyone downloads apps from the Play Store. But many excellent apps...

14 Best Game Hacker Apps for Android (With/Without Root)

Are you a mobile gamer? If you are, then you've come to the right place. In this post, we are going to tell you...

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...