VCF to CSV converts vCard contact files into a spreadsheet you can open in Excel, Google Sheets or Numbers, or import into a CRM, a newsletter service or another phone. A .vcf file is how iPhone, iCloud, Android, Google Contacts and Outlook export an address book, but it is hard to read, sort or edit directly. Drop one or several .vcf files and every contact becomes a row, with names, companies, job titles, all phone numbers and email addresses, postal addresses, websites, birthdays, notes and groups in their own columns. Three layouts are available. Spreadsheet gives clean, readable columns such as Mobile Phone, Work Phone and Work Email, and includes only columns that actually contain data, so a simple phone book does not come out as a table with eighty empty columns. Google Contacts produces the exact column names that contacts.google.com imports, and Outlook produces the columns Outlook recognises, which makes the tool a bridge between address books as well as a converter. The parser understands what phones really export: Android files in vCard 2.1 with quoted-printable encoding, iPhone custom labels such as Mobile or iPhone stored in separate lines, vCard 4.0 phone numbers written as tel: links, birthdays without a year, and names in any alphabet. Photos are left out to keep the file small. When saved as Excel, every value is stored as text, so phone numbers keep the plus sign and leading zeros that Excel would otherwise remove. Contacts from several files, for example backups of two phones, can be combined into one table with exact duplicates removed. Everything runs in your browser, so the address book never leaves your device. To go the other way and put a spreadsheet back onto a phone, use CSV to vCard Converter, and to combine several contact lists that are already spreadsheets use Merge CSV Files.
People convert contacts to a spreadsheet for many reasons. Small businesses move a phone full of customer numbers into a CRM. Associations and clubs turn the chairman's phone into a member list. Families merge the address books of an old and a new phone and want to see who is missing. Marketing teams prepare a newsletter import from contacts collected at an event. In each case the same few details decide whether the result is usable. The first is phone number format. A CSV has no types, so Excel decides on its own that +381 64 123 4567 is a number and 0641234567 is the number 641234567. Saving as .xlsx avoids that, because the workbook marks every cell as text. If you must use CSV with Excel, import it through Data, From Text/CSV and set the phone columns to Text. The second is encoding. The CSV files created here are UTF-8 with a signature at the start, which tells Excel to show letters like ć, ü or Cyrillic correctly; without it Excel on Windows often shows garbled characters. Use the semicolon separator if your Excel is set to a European language, since it uses the comma as a decimal mark. The third is duplicates: when the same person is saved on two phones, both copies are identical and the duplicate option keeps one. Contacts that differ slightly, for example with an extra email, are kept, so nothing is lost. Once the list is cleaned up in a spreadsheet, CSV to vCard Converter turns it back into a .vcf for any phone, and Excel to CSV Converter or CSV to Excel Converter switch between the two spreadsheet formats.