There are multiple users who are using Excel workbook for saving contacts and information from many years now want to import their contacts to VCF file. VCF(vCard) is very popular for saving contacts & other information. It can save name, phone number, address, email address, and other details of contacts. We hereby in this blog offer an easy solution to export Excel contacts to VCF file. So, let us start with the reasons to switch to VCF file.
Though Excel is commonly used for storing and managing contacts in large amounts but this was the old trend. An Excel file can contain multiple contacts details but you can’t share them separately through emails or through any other medium. On the other hand, VCF format store a single contact detail which is easy to share and can be easily transferred over computers and networks. VCF file is highly supported by various devices, cloud services, desktop applications and other popular platforms. It has successfully replaced Excel workbook to save contacts.
If you prefer manual tricks, then you can easily use it and export Excel contacts to VCF file. For this, you need to go through three different steps –
Another solution is a professional method in which only 4-5 easy steps are there for exporting Excel contacts to vCard format. Both methods provide results but for quick and hassle-free export, the second method is suggested to use by professionals.
1. Steps to export Excel contacts to CSV file Open Excel workbook where contacts are saved. Click on Office button. Click on Save as and choose Other formats Mention a location to save the file. Choose Save as type CSV and then click on Save button. You will get a message, click OK to save the active sheet, in case the selected workbook has multiple sheets. You will get another message, click Yes to keep the selected workbook in the same format. 2. Steps to import contacts from CSV file Once Excel workbook contacts are saved into CSV file, you need to import contacts from CSV file. On your desktop, press Windows Key & R key together and type contacts in the search box. Click Contacts under program list. In Contacts window, click on Import tab to import contacts from CSV file. A window to Import to Windows contacts will open. Select CSV option and click on Import button to continue. Choose the CSV file to import and click on Browse to locate the file. Select the CSV file from which you want to import contacts to your system. Click Open. The selected CSV file is listed. Click Next to continue. All contact fields are displayed. Map them correctly. Select the contact field from here. Click OK Map all fields and once mapping is done, click Finish 3. Steps to export contacts to VCF file Once contacts are imported from CSV file into your Windows system, you can export them to vCard format. From the Contacts window, select all contacts that you want to export to vCard files. Click on Export tab. A window of Export Windows Contacts appears, select vCards from the list. Click on Export to continue the process. Select the location for VCF Export. Once the location is selected, click OK. You will find all contacts are exported into VCF file format. Automated tool to export Excel contacts to VCF format If you don’t find manual solution suitable for you as it is lengthy and takes time to provide results then you can go for an automated solution named Datavare Address Book Manager. It allows to export Excel file contacts to VCF file format in a few clicks. Moreover, this method is too short and assures 100% safe conversion results. It has a self-expressive interface and it allows mapping of Excel and vCard contacts before the conversion. Check out the software working process – Install and Launch Excel to VCF Converter Program on your system. Select Export vCards from Excel file option and click Next. Choose Excel to vCard Conversion and load Excel file. Preview and map Excel contacts with vCard. Mention a path to save VCF file by click on the Browse button. To start the conversion process, click on Process button. Concluding Lines
We have explained manual trick and automated solution for exporting Excel contacts to vCard format. Both solutions work if implemented carefully. To use manual trick, more attention and technical skills are required. On the other hand, no such provisions are there to use Excel to VCF Converter software which is very simple to handle. You can evaluate the software working by downloading the free demo edition.