Skip to main content
CSV to vCard Contact import

CSV to vCard Converter

Convert CSV contact lists to VCF (vCard) files. Paste CSV or choose a file, map columns to contact fields, and download your .vcf file. Conversion runs locally in your browser, without sending your contact list to a conversion server.

Example contact
John Doe
How each row can look on your phone
Phone +1 234 567 890
Email john@example.com

Next: paste your list in the tool below, then convert—everything stays in your browser until you save the file.

Built for address books

  • Save contacts to Android or iPhone using the same .vcf file.
  • Bring lists into Google Contacts or Outlook with their import screens.
  • Share a contact pack by email or chat—recipients tap Import, not a spreadsheet.

No installation is needed; the converter runs in modern browsers.

Contacts: paste your list from Excel or a CRM export (or Load sample), adjust input options if needed, then set vCard mapping so name, phone, and email line up. Convert sits right under the mapping table. Save the .vcf for Google Contacts, Outlook, or your phone’s import screen.

  • Put country codes on phone numbers (+1, +44, …) when you can—imports are calmer on real devices.
  • Try Load sample first if you want to see how mapping behaves before pasting your real list.
Other statements:

Turn this on when the first line is headers, not a data row—so column labels map correctly to output fields.

Applies to data rows only (the header row does not count when “First row is column names” is on). Skip drops that many rows from the top of the data; Limit keeps at most that many rows after skipping.

Field Separator

Pick the delimiter your file uses between columns (comma is common; exports from Europe often use semicolon).

Use NULL for empty field: prevents SQL errors when inserting missing values into nullable columns.

NOTE - you can change the column names below by overwriting the Field Name value.

Key: the first column is checked automatically. Confirm it matches your table’s primary key before generating UPDATE or DELETE (composite keys: check every key column).

# Field Name Data Type Max Size Key Include Trim Use NULL for Empty Field
Paste CSV above to load columns.

Map each vCard field to a CSV column. Include is checked automatically when a column is mapped; uncheck to skip that field in the file, or set Mapping to — none — to clear it. Use Check all / Uncheck all under the mapping table for every row at once. You can duplicate TEL / EMAIL / ADR rows to emit multiple values.

# VCF Field Mapping Include Others
Paste CSV above to load mapping options.
Include column:
Other statements:

Run this after you are happy with column mapping—output opens further down the page.

How Your Contacts Will Look After Conversion

Each row in your sheet becomes one person in the file—same idea your phone already uses for name, dial, and email.

Morgan Kim
Account manager
Phone +1 206 555 0142
Email morgan.kim@example.com
Lee Santos
Vendor · deliveries
Phone +44 20 7946 0958
Email lee@partner.example
Avery Patel
Freelance
Phone +91 22 5555 0199
Email avery@studio.example
Show vCard output — copy & download appears here
What this conversion produces — tap to read full detail

What this conversion produces

Create a vCard contact file from CSV rows. Use the mapping table to choose which columns supply names, phone numbers, emails, and other supported fields. Review the generated VCF, then copy it or download a .vcf file.

When to Convert CSV Contacts to VCF

Use VCF when the destination contact app accepts vCard or you want to share contacts as a .vcf file. Google Contacts accepts both CSV and vCard, so conversion is not always necessary. Check your destination app’s supported formats and import instructions before exporting.

Real-world uses

Export CRM or help-desk contacts and load them onto sales reps’ phones before a trip. Move a shared Excel “clients” tab into Google Contacts for the office line. Email a single .vcf bundle so a colleague can tap Import without seeing your whole sheet. Shift a household mailing list from CSV into iCloud for family devices.

Who uses this

Business owners updating handsets, sales teams reorganizing territories, freelancers sharing client lists with clients, and everyday users who just want their grid of people to land in an address book.

Why Contact Imports Fail (and How This Fixes Them)

Phone numbers as text

Problem

Spreadsheet apps can strip leading zeros or a leading +, and numbers without a country code may dial incorrectly after import.

Fix

Keep phone numbers as text so leading zeros and a leading + are preserved. Include international country codes where appropriate. This converter maps your values; it does not verify that a number is valid or automatically determine its country.

Wrong column mapping

Problem

Incorrect mapping can put a name, phone number, or email in the wrong field.

Fix

Review the mapping table and generated contacts before downloading.

Import errors on Android / iPhone

Problem

Some devices reject files when lines are broken, fields are empty, or the app does not recognize the mix of columns.

Fix

Preview the generated vCard in the output panel, fix odd characters or blanks, then save a clean .vcf and import again.

Duplicate contacts

Problem

Re-importing the same sheet or overlapping CRM exports can create twins in Google or on the handset.

Fix

Deduplicate in your sheet first, or merge carefully inside Google Contacts / Outlook after import.

From Spreadsheet to Phone Contacts (Step-by-Step)

  1. 1

    Paste or upload your CSV

    Use the Text or File tab. Your sheet can come from Excel, Google Sheets, or a CRM export—one row per person is ideal.

  2. 2

    Match columns to Name, Phone, and Email

    Open mapping options and point each vCard field at the right column so each value appears in the correct contact field.

  3. 3

    Generate your .vcf file

    Tap Convert, then copy or download the vCard bundle from the output area when it looks right.

  4. 4

    Import into your phone or contacts app

    Import the downloaded .vcf using your destination app’s supported workflow; steps vary by app and device.

Where You Can Use Your vCard File

  • Android

    Open Contacts, use Import (wording varies by phone), and choose your .vcf file.

  • iPhone & iCloud

    Use the Contacts app or iCloud import—pick the vCard bundle you saved from this page.

  • Google Contacts

    Google Contacts can import CSV or vCard. Use Import and choose your .vcf when that is the format you prepared—or keep CSV if that fits your account’s import options.

  • Outlook

    On Outlook for desktop, use File → Open & Export → Import/Export (wording varies by version) and follow the prompts for a vCard or contacts file. Outlook on the web uses a different import path—check Microsoft’s current help for your account type rather than assuming desktop menus.

What the vCard lines mean (plain language)

You do not need to edit this by hand—just a quick read so imports feel less mysterious.

Tiny example
BEGIN:VCARD
VERSION:4.0
FN:John Doe
TEL;TYPE=CELL:+1234567890
EMAIL;TYPE=INTERNET:john@example.com
END:VCARD
Field meanings (FN, TEL, EMAIL)
  • FN — the name you see on the contact card.
  • TEL — a phone line; CELL hints it is a mobile number.
  • EMAIL — the address the mail app should use.

When This Helps — and When to Pick Something Else

Use when

Use this path when the destination accepts vCard, when you are moving a list between systems that prefer .vcf, or when you want to share a contact pack without sending the full spreadsheet.

Avoid when

Skip browser vCard when your company already pushes contacts through full directory sync (SCIM/LDAP), or when relationships are messy enough that cleanup belongs in the CRM before any export.

Same spreadsheet, different next step

CSV → vCard

People, phones, and inboxes—share a .vcf and import into Contacts.

CSV → JSON

Apps, scripts, and APIs—great when a program will read the data next.

CSV → XLSX

Filters, pivots, and printouts—when the audience lives in Excel.

Why This Tool Works for Contact Imports

Keep phone numbers as text so leading zeros and a leading + are preserved. Include international country codes where appropriate. This converter maps your values; it does not verify that a number is valid or automatically determine its country.

Conversion runs in the browser—no upload to a conversion server—so you can map columns, review the generated contacts, then download or copy the .vcf when you are ready to import.

Contact import help

Format notes first; FAQs below are grouped so you can skim on a phone.

CSV to vCard overview

CSV to vCard overview

Turn CSV contact rows into a downloadable .vcf file for address books.

Paste or upload CSV, map columns to FN/TEL/EMAIL (and optional N/ADR), then convert. Use + on TEL/EMAIL/ADR for extra numbers on the same contact. Blank names export as Contact.

Input format notes

About CSV as the source

CSV is parsed as structured input for this page. Use complete rows, valid syntax, and consistent field names so the converter can preserve the important data when creating vCard.

Output format notes

About vCard as the output

vCard is generated from the parsed CSV data. Review the output before importing it into another system, especially when the destination expects strict columns, dates, or contact fields.

Conversion guide

How to convert CSV to vCard

  1. Paste CSV in the Text tab or upload a .csv file. Use Load Sample to try demo contacts.
  2. Under vCard mapping options, map columns to FN, TEL, EMAIL, and optional N/ADR/ORG. Check Include for each field you want.
  3. On TEL, EMAIL, or ADR, use + to add another number or email on the same contact—not another person. Use − to remove a duplicated mapping row.
  4. For structured names, use Family;Given;;;—semicolons stay structural. A blank name still exports as Contact.
  5. Select Convert, review the vCard text, then copy or download the .vcf.
  6. Use Clear to reset input, mappings, and output.

Contact import FAQs

CSV to vCard FAQs

Start with the three answers people need before import; open a topic below for everything else.

Most common questions

More questions by topic

Open one section at a time.

The row still exports. The card uses the placeholder name Contact when no usable name is mapped.

Use Load Sample for demo rows, and Clear to reset input, mappings, and output.

Use Family;Given;Additional;Prefix;Suffix—for example García;José;;;. Semicolons stay structural so apps can split first and last names.

No. Conversion runs in your browser on this page.

What you get for contact imports

  • Names and numbers stay in your browser tab while you map columns—nothing is sent to a converter server just to build the file.

  • Built for bulk contact lists: map once, preview, then import many people into Google Contacts, Outlook, or a handset.

  • You get standard .vcf text—easy to sanity-check, email to yourself, or hand off before anyone imports.

  • Map FN, TEL, and EMAIL to the right columns, preview the bundle, then import through Google Contacts, Outlook, or your phone’s Contacts app.