1001Ferramentas
Tools Categories Guides FAQ
About Contact Privacy Policy Terms of Use
📇 Converters

CSV ↔ vCard (.vcf) Batch Converter

Converts a CSV contact list into a multi-contact vCard (.vcf) file and back to CSV, with column mapping and vCard 3.0/4.0 output.

Why 3.0 is still the safe choice

vCard 4.0 is from 2011 and writes phone numbers as tel: URIs and birthdays without hyphens. Plenty of address books, car head units and older CRM importers still choke on it and show an empty contact list. Version 3.0 is the format Google Contacts and Outlook export by default, so start there and only move up if the target app asks for 4.0.

When reading a .vcf, the parser undoes the 75-octet line folding and decodes quoted-printable, which is how phones from the 2.1 era wrote accented names: a contact stored as Gon=C3=A7alves comes back as Gonçalves instead of the mojibake you see when the file is opened straight in a spreadsheet.

Convert a contact spreadsheet into vCard

Phones export contacts as .vcf, spreadsheets export as .csv, and the system you are migrating to always wants the one you do not have. This tool goes both ways: paste the spreadsheet and get a single .vcf holding every contact, or paste the .vcf and get a CSV with a fixed header. Column mapping is guessed from the header in English and Portuguese, and you can fix any field by hand.

Version 3.0 is preselected because it is what Google Contacts and Outlook export, and what almost every device imports without complaining. Version 4.0 writes phone numbers as tel: URIs and birthdays without hyphens, a shape that car head units and older CRM importers sometimes ignore in silence, leaving you with an empty address book. Move up only when the target asks for 4.0.

On the way in, the file goes through two steps that routinely mangle contacts: undoing the 75-octet line folding that cuts long names and notes in half, and decoding quoted-printable, the scheme phones from the 2.1 era used for accented characters. A contact stored as Gon=C3=A7alves comes back as Gonçalves rather than the pile of symbols you get when the .vcf is opened in a spreadsheet.

Frequently asked questions

My CSV is semicolon separated. Do I convert it first?
No. The delimiter setting starts on Detect: the tool counts commas, semicolons and tabs outside quotes on the first line and picks whichever appears most. If an unusual header throws the guess off, choose the separator from the list and convert again.
What happens to blank rows in the middle of the sheet?
They are skipped and counted separately. The summary reports how many contacts came out and how many rows were ignored, listing each row number, so you can tell export garbage apart from a row that simply lost its mapping.
Can I import the generated .vcf into Google Contacts?
Yes. Download the file and use Import at contacts.google.com, picking the .vcf. Since every contact sits in one file, the whole batch lands at once. Create a fresh label first so you can undo the import in bulk if a field ends up in the wrong place.

Related Tools

📄

CSV to JSON

Convert CSV to JSON. The first row becomes object keys, the rest become array items. Supports separators , ; and \t. Auto-detects numbers and booleans. Everything in your browser.
📋

CSV → JSON Lines

Convert CSV to JSONL (one JSON object per line). Common format in logs, ML pipelines and document databases.
📐

Fixed-Width ↔ CSV/JSON Converter

Converts fixed-width text files to CSV, TSV or JSON and back, with automatic column detection, a position map and per-line warnings.