Cara convert file vcf ke excel

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.

 Cisdem ContactsMate

The Best VCF to Excel Converter for Mac

• Support contacts from various sources: VCF, CSV, Mac’s Contacts, iCloud, Google, Outlook, etc.
• Convert/export contacts to 8 formats: Excel, CSV, VCF, etc.
• Let you convert 1 or multiple VCF files to Excel at once
• Let you view, search, edit, create, group, tag, share, print and sync contacts
• Find and delete/merge duplicate contacts
• Let you backup/restore contacts with a click
• Easy to use and powerful
• Compatible with macOS 10.11 or later

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.

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, Choose Export.

6. In the dialog that appears, make sure you select the right label in the drop-down menu and select CSV as the export format. Click Export.

7. Open the exported CSV file with Excel.

8. From the File menu, choose Save As. In the Save as type list, select Excel Workbook (.xlsx). Click Save.

Note that this method can only handle one VCF file at a time.

Google Contacts labels contacts with the date they are imported. To make sure that you convert the right contacts, make sure that you select the right label in step 6.

Method 3. How to convert VCF to Excel online

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.

Method 4. Manually import VCF to Excel

There is more than one way to convert vCard to Excel. You can do it by hand if there are only a few contacts. If there are tons of contacts, the methods above are better.

1. Create a new Excel spreadsheet.

2. Open a VCF file in Windows Contacts (on Windows PC) or Contacts (on Mac).

3. In the newly created spreadsheet, add a column heading for each field (such as name, home address and phone number) of the contact information contained in the VCF file.

4. Copy contact information and paste it the appropriate columns.

5. Save the Excel file.

Now the contact information in the vCard is properly pasted to Excel.

Conclusion

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.