VCF (with the extension of .vcf) is a file format for storing contact information and is also known as vCard. Excel (.xlsx) is a spreadsheet developed by Microsoft. Sometimes, you may want to convert VCF files to Excel to use them in a certain app or to bulk edit contacts, among other purposes. This article will show you how to easily convert VCF to Excel on Mac, Windows and mobile in different ways.
Applies to: macOS
A single VCF (also known as vCard) file can contain one or many contacts. If a VCF file has many contacts, it can be relatively large. Cisdem ContactsMate is the best contact manager for Mac. It allows you to efficiently convert VCF files to Excel on Mac, individually or in bulk, small or large.
1. Download and install ContactsMate.
2. When you open it for the first time, click OK to allow access.
3. Control-click On My Mac and choose New Group.
4. Control-click New Group and choose Import.
5. Select one or more VCF files and click Open.
6. Now control-click New Group again and choose Export.
7. To convert one or multiple VCF files to Excel, select Excel in the Format drop-down menu. Click Save.
Now the conversion is done, and the contact information is kept in an Excel spreadsheet. The conversion doesn’t require Internet, so this method can work offline.
If you want to delete the contacts imported in step 5, here’s how. Choose New Group, select all contacts in it, press the Delete key, and then click the Delete button.
By default, Cisdem ContactsMate will export the contacts list with valid fields. In step 7, you can also select custom fields to export. To do that, choose Custom Fields from the Field drop down list. Click the Gear icon next to it. Select the contact fields that you wish to export, such as First name, Last name, Phone, Email, etc. This way, the exported Excel file will only contain the contacts information that you need.
Some third-party contacts systems only supports exporting contacts to vCard, not Excel. This can be inconvenient in some cases. Fortunately, you can easily export contacts from Mac Contacts, Gmail, iCloud, and more to Excel with Cisdem ContactsMate. To do that, click Add Account on the top tool bar. Select a contacts system from Internet Account window. Sign in with your email and password. Check the box next to Contacts. Then this contacts management tool will sync contacts with your account. Find the contacts group on the main window. Select the contacts that you want to export. Right-click and choose Export. Select Excel as export format. Click Save.
Applies to: Windows, macOS, Android, iOS
If you directly open a VCF file with Microsoft Excel, the contact information won’t be properly displayed. How to open VCF file in Excel in the right way? A conversion is required. If you have a Google account, the conversion will be easy.
1. Sign in to Google with your account.
2. Go to Google Contacts.
3. On the left, choose Import.
4. In the dialog that appears, click Select file. Select a VCF file and click Open. Click Import.
5. On the left, select the Label Imported on [date]. Control-select all contacts you want to export.
6. Click the 3-dot icon on the upper right. Choose Export.
7. Select CSV as the export format. Click Export.
8. Right-click the exported CSV file. Open it with Excel app.
9. From the File menu, choose Save As. In the Save as type list, select Excel Workbook (.xlsx). Click Save.
Applies to: Windows, macOS, Android, iOS
To do the conversion without software, you can also use an online VCF to Excel converter. Note that such a converter will require you to upload your VCF file to their server first.
1. On your browser, go to aconvert.com/document/vcf-to-xls.
2. Click Choose Files.
3. Select a VCF file and click Open. If you want to import multiple VCF files into Excel, just select them all.
4. From the Target format list, choose the XLSX format.
5. Click Convert Now.
6. When the conversion is completed, click the Save icon.
7. Click the file URL to download the Excel spreadsheet to your device.
This method will convert each VCF file to a separate spreadsheet, where as the first method will convert all VCF files into one spreadsheet.
In addition to converting VCF to XLSX, you can choose the XLS format in step 4 if needed. XLS is also an Excel extension.
Applies to: Windows
Windows Contacts is a contact manager that is built in Windows Vista, Windows 7, Windows 8, Windows 10, and Windows 11. It supports importing contacts from vCard. And its Export feature supports the CSV format. Then you can use the Excel app to convert the CSV to Excel format. Below are steps.
1. Right-click the VCF file on your PC. Choose Open with > Windows Contacts.
2. Click Add to my contacts on the pop-up window. Press the OK button.
3. Search for Contacts from the Start menu. Then open Windows Contacts. You’ll see your imported vCard in it.
4. Select all the imported contacts and press Export.
5. Choose CSV (Comma Separated Values) from the Export Windows Contacts window. Click Export.
6. Select a desired destination path to save the file. Click Next. Enter the file name and click on Save.
7. Find and right-click the CSV file you just exported. Open it with Excel.
8. Click File > Save As.
9. Select Excel Workbook (.xlsx) as save format. Click Save.
Now the VCF to Excel conversion is complete.
Certain apps and services allow users to import contacts from Excel but don’t support VCF. A conversion is required to use the contacts in a VCF file in these apps or services. Also, sometimes you may want to bulk edit contacts, which will be easier if the contacts are in a spreadsheet. In such cases, this article is helpful. It talks about how to convert VCF to Excel on Windows, Mac, Android and iOS.
Rosa has worked in Mac software industry for more than eight years. She believes that the purpose of software is to make life better and work more productively. In addition to writing, Rosa is also an avid runner.
Gerrit Klein
I couldn't find a quality tool to convert the file to excel without errors for a long time, but yesterday I tried Cisdem and it helped me do the job with ease. thanks!