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:
Table of Contents
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:
-
Open Excel File.
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.
-
Head over to www.csvtovcard.com and download their software. (Size <1MB)
-
Install it on your computer and open it.
-
Select 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 then specify it manually.
-
Convert the File
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
nice article. it helped me a lot. Thank u
You’re welcome!
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.
AM unable convert.. can you pls help
What issue are you facing? Let me know.
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 :)
thank you very much !
You’re welcome!
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.
Hello Harsh, I am not clear what you are saying. Connect directly with me @boricha.mehul5
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.
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?
Hello Siti,
From where you exported the vcard and how?
I keep getting an error when I go to import the vcards that they can not be read. Any suggestions?
IT only occurs when your vcfs are not of correct format or corrupt. Please verify it.
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.
That is awesome :)
very easy & helpful
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.
Working fine here! Try this link: http://www.softsea.com/download/CSV-to-vCard.html
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
Hello Matteo,
Kindly send us a sample of your CSV to our mail mentioned on the contact us page. :)
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
Hello Matteo,
Our contact us page dear. We’ll try our best to help you out. We have no affiliation with csvtovcard.
Your data is wrong. CSV means comma ‘,’ separated not semicolon ‘;’. Replace all semicolons with commas. (Reply for the Email you sent us!)
it really works and thanks a lot
hi please helpme in converting excel to vcard
Hello Hema,
The process is already explained well enough. If you have any issues, kindly mention it here.
Hello Mehul,
I have visited this page – ( http://www.softsea.com/download/CSV-to-vCard.html ),
and I am unable to download it, then I am clicking on
(Click here to start download manually if it not start. ) manually download so this page redirect to a blank page
url of blank page – ( http://file1.softsea.com/get.php?id=834879451 ),
Please help me, How can I download this tool.
Thanks in advance
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?
Best article ever read. You did a great job
Thank You :)
I cant download the software .. any help
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
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.
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.
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.
Hello Aesha,
Yes, you need to download the .NET framework for this software to work. It is already mentioned on the official site of the software. You can download the .NET framework from this link: https://dotnet.microsoft.com/download/dotnet-framework
NIce Article but the problem is want to convert more than 100 contact its converting onle 1
What do you mean? Can you please explain?
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.
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.