Excel is a place to store the contacts details clearly. Some of you may keep your contacts list in Excel spreadsheet. However, some platforms do not support this contacts format. And vCard, also know as VCF, is a kind of digital file formats for storing contacts information. This format can be easy to read, and enables us to transfer contacts data conveniently. It is a more widely used format. Here in this article let’s see how to create vCard from Excel file on Mac and Windows computer.
Cisdem ContactsMate
Free Download
Although we can manually create vCard from Excel file by ourselves, it will be time-consuming and error-prone, especially when we have large numbers of contacts. Cisdem ContactsMate is an easy-to-use contacts management tool that enables you to manage all your contacts from different sources in one place. To convert Excel to vCard on Mac more efficiently, this tool can help.
1. Open the Excel file that you want to convert.
2. Click on File > Save as. Select a save location. Choose CSV under the Save as type dropdown menu. Click Save.
3. Download and install Cisdem ContactsMate on your Mac.
4. Allow this tool to access your contacts when you first launch it.
5. Control-click On My Mac. Select New Group.
6. Then control-click this new group. Click Import.
7. Choose the CSV file you just export from Google Sheets. Click Open.
8. Now the contacts data from the CSV file has been imported to this tool. Control-click the new group again. Click on Export.
9. To create vCard from your Excel file, select vCard from the format menu. Click Save.
The vCard file is now exported to your computer.
Not only converting contact formats, Cisdem ContactsMate has many other useful and powerful features to help you better manage your contacts list. That is why I recommend this tool to you.
Convert contacts to 8 different formats. Except vCard, this tool also supports exporting selected contacts to other formats, including CSV, Excel, TXT, Docx, HTML, Numbers and Pages. You can easily convert contacts formats via ContactsMate. In addition, you are able to customize the export fields.
Detect and delete/merge duplicate contacts. Before exporting the contacts to vCard, you can delete/merge duplicate contacts and fix problematic contacts to make your contacts list clearly. Choose the contacts group. Click “Scan” on the top tool bar. Then choose contacts in a type such as Exact duplicate contacts, Duplicate phone numbers, invalid email address, etc. to fix.
Easily sync, transfer, edit, tag, group, print, email and share all your contacts. As a professional contacts management tool, ContactsMate allows you to conveniently manage and use contacts from different sources in one place. To sync contacts from other accounts to this tool, click on “Add Account” in the top tool bar. Sign in with user name and password. Enable the box next to “Contacts”. Then this tool will get all your contacts in this account.
For Windows computer, there’s a way to convert Excel to vCard manually. This method will be more troublesome. And the exported result won’t be perfect if you’re not a technical person. Similar to method 1, first you need to transfer Excel to CSV through Microsoft Excel on your computer. Then import the CSV into Windows Contacts. Finally, export the contacts as VCF.
1. Open the Excel file on your PC.
2. Click on File > Save as. Choose to save as CSV. Click Save. Click OK if a pop-up notice window appears.
3. Click on Windows icon and search for Contacts.
4. Tap on Import on the Contacts pane.
5. Select CSV (Comma Separated Values) then click Import.
6. Click Browse and find the CSV file you just created in step 2. Click Next > Finish.
7. Go back to the Contacts window and select all the contacts you want to convert.
8. Tap on Export on the Contacts pane.
9. Select vCard (folder of .vcf files). Choose the save location you want to save VCF. Then click on Export. Hit Finish.
There’s an online Excel to VCF converter. Let you create vCard from Excel file directly on website. However, compared to other converter software, this online tool has a limit on file size, and less flexible. If you trust this online tool, follow the steps below to create your vCard without downloading any software.
1. Visit the online converter site on your browser: https://www.thewebvendor.com/excel-to-vcf-vcard-online-converter.html
2. Click Choose File. Select the XLS/XLSX file you need to convert. Click Submit.
Note: The maximum file size you can upload is 2 MB.
3. Select the sheet number your contacts data is in.
Then select the first and last column of your Excel sheet.
Select the first row where the actual data starts and the last row where the actual data ends.
Click Submit.
4. Mapping the contacts fields in each column one by one to help the tool build the VCF accordingly. For example column A is Name, and column B is Mobile number.
Click Submit.
You can view or download the demo VCF files for free. To get the complete vCard file, you have to pay.
To avoid error occurs when converting Excel to vCard, you should check your Excel file for the following issues before converting:
After completing the conversion, manually verify the converted vCard file to ensure that all data is mapped correctly.
There are multiple programs can open and view VCF files on computer, including Microsoft Outlook, Notepad, Mac Contacts app, and Google contacts on ChromeOS, etc.
Microsoft Outlook on Windows lets you easily view and edit the contacts cards. Open the app and then click File > Open & Export > Import/Export. Select Import a vCard file. Click Next. Then select the VCF file to import. By doing so, you can open, view and edit your VCF file on PC.
If you want to view the converted file on computer without importing it to your existing contacts list, you can use the Notepad app. Run Notepad app on your Windows PC. Click File > Open. Go to the VCF file location. Click All files from the File type drop down menu. Select the VCF file and click Open.
Compare to Excel file, vCard can be easier to read. And there’re more platforms receive contacts from vCard formats than Excel. Converting Excel file to vCard (VCF) can help you to share contact cards with other programs or other people more convenient. This article introduced 3 Excel to vCard converters on Mac, Windows and online tool. And I have mentioned a step-by-step process of these solutions. Hope it can help you perform the conversion efficiently.
With a passion for tech and writing, Sarah joined Cisdem, where she focuses on creating articles about using utility tools to enhance file management and simplify contact management.
Hedda Naatz
Hello I just want to say thank you. The first method worked great, and saved me a lot of time.