How to Convert a Zipped VCF to a CSV

Save

If you try to import multiple contacts from a vCard file into Microsoft Outlook 2013, the email client imports only the first contact. To work around this issue, convert the VCF file to a CSV file; Outlook imports all contacts from CSV files. If your VCF is compressed into a ZIP or RAR file, unzip it using an archiving utility and then perform the conversion. You don't need to use any third-party applications in Windows 7 or 8.1 to convert a VCF to a CSV.

  • Extract the VCF file from the archive using an archiving utility and store it on your hard drive. WinZip, WinRAR and 7-Zip -- links in Resources -- can extract the contents of both ZIP and RAR archives. After you install any of these utilities, the extract or unzip option appears in the context menu when you right-click an archive.

  • Press "Windows-X" in Windows 8.1 to display the Power User menu and click "File Explorer" to launch the utility. In Windows 7, click the "Start" button and click "Computer" to open Windows Explorer.

  • Open the "C:\Users\Your-Username\Contacts" folder. If you installed Windows on a different partition, replace "C:" with the correct letter. All your Windows contacts are stored in the Contacts folder as individual .contact files.

  • Click the "Import" button to display the Import to Windows Contacts dialog. If the Import button is not visible, click the ">>" button and then select "Import" from the menu.

  • Select "vCard (VCF file)," click "Import," select the VCF file you extracted from the archive and click "Open." The Properties window for each contact displays. Edit the contact information if necessary, and click "OK" until all contacts are imported.

  • Select the contacts you want to export to a CSV file. To select all contacts in the Contacts folder, press "Ctrl-A." To select only specific contacts, hold "Ctrl" and click each item. To delete specific contacts, select them and press "Delete."

  • Click the "Export" button to display the Export Windows Contacts dialog. If the Export button is not visible, click the ">>" button and select "Export" from the menu.

  • Select "CSV (Comma Separated Values)" and click "Export" to display the CSV Export dialog. Click "Browse," select a folder, type a name for the CSV file into the "File name" field and click "Save."

  • Click "Next" and then select the information -- such as first name, e-mail address or mobile phone -- you want to include in the CSV file. Click "Finish" to create the CSV and then close the Export Windows Contacts dialog.

Tips & Warnings

  • You can import CSV files into Microsoft Excel 2013 if you want to organize the information in spreadsheets.
  • Most database software can import data from CSV files; however, it may not be able to import it from vCard files.
  • To change the contact information for a specific contact, double-click it in the Contacts folder to display its Properties window.
  • You can use free online conversion services to convert VCF files to CSV files. However, many of these services cannot unzip the file if it is stored in an archive.
  • Avoid using free online converters if your vCard file contains personal information. The file is stored on third-party servers and may be accessed by others.

References

  • Photo Credit dolgachov/iStock/Getty Images
Promoted By Zergnet

Comments

Resources

You May Also Like

  • How to Convert a CSV File to Mac

    Most database, word processing and spreadsheet programs provide the option to save a document in another format for compatibility across platforms and...

  • How to Convert Contacts to Vcf

    The Vcf file format is the most widely accepted format for sharing contacts between computers and software programs. There are a wide...

  • How to Format a CSV File

    Comma separated value (CSV) files are spreadsheet or database files written as text files. You may want to convert a file to...

  • How to Convert VCF to CSV Online

    A VCF file is a vCard file exported from Microsoft Outlook or the Apple Address Book. Certain programs, such as Mozilla Thunderbird,...

  • How to Import a Contacts File in Outlook 2003

    Import a contact's file in Outlook by clicking on the "Contacts" tab then using the File, Import and Export menu items. Import...

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!