Missing phone format
Problem
Local numbers without a country code often import as wrong, blank, or “do not dial” entries.
Fix
Use +country code before the number, then convert—your .vcf matches what carriers expect.
CSV to vCard
Contact import
Turn Spreadsheet Contacts into Phone-Ready vCard Files
Builds standard .vcf bundles from contact grids for sales reps, small-business owners, and anyone importing names into Google Contacts, Outlook, or a handset—without exporting through another vendor.
ConversionTab folds vCards in your browser: numbers and emails are not uploaded to a conversion backend.
Map columns, convert, then download—your list stays local until you attach the file to mail or cloud storage.
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.
Need a custom import format?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.
CSV file
Drop a .csv file here, or click to browse
.csv or plain text — max 25 MB. Loads into the same editor as the Text tab; use Convert after the mapping table below.
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.
| # | 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:
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
Each row becomes a contact entry: display name, phone numbers, email, and optional address or company lines, written as standard vCard text you can open on a laptop or send to a phone for import.
Use this output next
VCF → SQL
Stage contacts before a controlled database import.
VCF → JSON
Feed directories and sync jobs with structured objects.
VCF → XLSX
Review TEL/EMAIL columns with spreadsheet filters.
VCF → CSV
Normalize cards into a grid for dedupe and CRM cleanup.
Why phones ask for vCard, not CSV
Most phones and contact apps cannot import a plain CSV address book. People keep names and numbers in spreadsheets or CRM exports, then get stuck: the file opens in Sheets or Excel, but Google Contacts, Outlook, and iPhone or Android import dialogs expect vCard (.vcf) instead of rows.
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)
Wrong column mapping
Problem
If “name” points at a phone column, you get blank cards or two people merged into one.
Fix
Use mapping options so display name, mobile, and email each pick the right column before you export.
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
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
Match columns to Name, Phone, and Email
Open mapping options and point each vCard field at the right column so cards are not empty or merged wrong.
-
3
Generate your .vcf file
Tap Convert, then copy or download the vCard bundle from the output area when it looks right.
-
4
Import into your phone or contacts app
Use Contacts → Import on Android or iPhone, or Import in Google Contacts or Outlook—pick the file you saved here.
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
From Google Contacts, use Import in the menu and upload the .vcf—great for shared team inboxes.
-
Outlook
Desktop or web Outlook: File → Open & Export → Import/Export (or similar) and select your vCard.
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:3.0
FN:John Doe
TEL;TYPE=CELL:+1234567890
EMAIL;TYPE=INTERNET:john@example.com
END:VCARDField 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 you need contacts on a phone or tablet, when you are moving a list between systems that accept vCard, 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
Include country codes on phone numbers when you can; map display name, mobile, and email to the right fields before export; skim for duplicates so you do not import the same person twice.
Conversion runs in the browser—no extra upload step—so names and numbers stay on your device while you adjust mapping. Download or copy vCard text when you are ready to import into Google Contacts, Outlook, or your phone’s Contacts app.
Continue with other formats
CSV → HTML
Use when the web or a CMS needs a pasteable table fragment.
CSV → ICS
Export to calendar apps when rows represent meetings or shifts.
CSV → SQL
Use when the next hop is INSERT-ready text for a database load.
CSV → YAML
Use when Git, Helm, or CI expects indentation-first config.
CSV → JSON
Use when APIs, fixtures, or mobile clients need structured objects.
When to pick this over other options
Use this path when you need contacts on a phone or tablet, when you are moving a list between systems that accept vCard, or when you want to share a contact pack without sending the full spreadsheet.
Practice note
Include country codes on phone numbers when you can; map display name, mobile, and email to the right fields before export; skim for duplicates so you do not import the same person twice.
Browser-first execution
Conversion runs in the browser—no extra upload step—so names and numbers stay on your device while you adjust mapping. Download or copy vCard text when you are ready to import into Google Contacts, Outlook, or your phone’s Contacts app.
Explore more conversions
Back to CSV from other formats
XLSX → CSV
Strip workbook binaries when loaders only accept UTF-8 CSV.
YAML → CSV
Materialize config lists into a grid ops can annotate before merge.
ICS → CSV
Spread VEVENT fields across columns for spreadsheet-based planning.
Other CSV exports for the next system
CSV → PDF
Freeze tables for legal, procurement, or print-room workflows.
CSV → XLSX
Package typed workbooks when humans—not parsers—must sign off.
CSV → XML
Serialize rows to elements when XSD or SOAP is the contract.
Cross-format tools worth bookmarking
YAML → JSON
YAML config blocks compiled into runtime JSON.
JSON → SQL
JSON payloads promoted into INSERT-ready relational text.
Contact import help & FAQs
Format notes and the full Q&A set you already trust—rearranged so you can skim fast on a phone.
CSV to vCard overview
CSV to vCard Converter Overview
The CSV to vCard Converter helps you transform CSV into vCard effortlessly, designed for contact files.
Perfect for vCard compatibility, this tool ensures secure, fast, and precise results for cross-platform sync.
You can either paste your CSV data directly into the input field or upload a file. Select vCard as the desired output format, and the converted file will be ready in moments.
Your converted vCard file is ready to download. Simply save it to your device.
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 VCF?
- Step 1: Enter Text or Upload File - Begin by providing your data in CSV format. You can either type it in manually or upload a CSV file containing the information you want to convert to VCF. Ensure that the CSV file adheres to the required structure for accurate conversion. Use Load Sample to try the built-in example.
- Step 2: Map columns to vCard fields - Open vCard mapping options. Each vCard property can be linked to a CSV column; use Include to control what is written. For EMAIL, TEL, and ADR, pick a type (e.g. Home, Work, Car) and use + / - for extra values. Types are inferred from column names such as Email Home or Phone Car when possible.
- Step 3: Click the 'Convert' Button - When mapping looks correct, click Convert to generate VCF.
- Step 4: Copy Result Data or Download File - Copy the resulting VCF text or click Download to save a
.vcffile. Use Clear to reset input and output.
Converted VCF Output:
BEGIN:VCARD VERSION:4.0 UID:f8e0bd14-57a3-4a8c-89a0-34794eb971f7 N:;Aimee;;; FN:Aimee EMAIL;TYPE=HOME:Mckenna_Toy24@yahoo.com ADR;TYPE=HOME:;;698 Rohan Pine;Baytown;LA;30314;United States TEL;TYPE=CAR:262-665-9227 x945 URL:https://ethical-developmental.com NOTE:Remote-friendly\; prefers email. TITLE:Mechanical Engineer ORG:Hegmann - Lueilwitz BDAY:20100928 END:VCARD BEGIN:VCARD VERSION:4.0 UID:b089c817-3ef4-4d21-84f5-1b8c17ef65b4 N:;Laverne;;; FN:Laverne EMAIL;TYPE=ADDITIONAL:Eloy46@gmail.com ADR;TYPE=BILL:;;417 Lillian Locks;Tucson;AZ;85701;United States TEL;TYPE=VIDEO:520-581-7516 x007 URL:https://outlying-lamb.org/ TITLE:Software Engineer ORG:Conn - Leuschke BDAY:19950429 END:VCARD
Contact import FAQs
CSV to VCF (vCard) FAQs
Start with the three answers people need before import; open a topic below for everything else. The full official copy stays available at the bottom for search and printing.
Most common questions
Start here
3. What happens after entering CSV data?
Upon entering CSV data, users are directed to the 'Output Options' section, where the crucial process of mapping CSV columns to vCard fields takes place. Accurate mapping is essential for ensuring that the resulting vCard file contains the desired contact information.
Q4
4. What are the special requirements for mapping Email, Phone, and Address?
Mapping Email, Phone, and Address columns involves specific requirements to achieve correct conversions:
- Email: Users must select both the column type (e.g., Email Home) and the corresponding vCard field (e.g., Email). This ensures that the email address is correctly categorized.
- Phone: Similar to Email, Phone mapping requires users to specify both the column type (e.g., Phone Home) and the desired vCard field (e.g., Tel).
- Address: Address mapping involves assigning the column type (e.g., Address Home) to the appropriate vCard field (e.g., ADR).
These specific mappings ensure that contact details are accurately represented in the vCard format.
Q8
8. How do I get the VCF output?
Once the mapping and settings are complete, users can initiate the conversion process by clicking the 'Convert' button. The resulting VCF data is displayed in a textarea, providing users with two options:
- Copy: Users can copy the generated VCF data for use elsewhere.
- Download: Users can download the VCF file, with the option to specify a custom file name if desired.
This flexibility ensures that users can choose the most suitable method for accessing their converted data.
More questions by topic
Open one section at a time. Answers are unchanged from the official FAQ text.
For multi-valued fields, such as multiple email addresses, ConversionTab provides two methods:
- Combine in a Single Column: Users can include multiple values in a single column, separating them using a specified separator (e.g., Email 1, Email 2, Email 3).
- Add Rows: Alternatively, users can click the '+' button to add additional rows for each value. The '-' button allows users to remove incorrect mappings or unwanted rows.
This flexibility ensures that multi-valued fields are handled efficiently.
ConversionTab offers users two convenient ways to input their CSV data:
- Text Tab: Users can manually enter CSV data as a valid string in this tab.
- File Tab: Users can upload their CSV file through the 'Drop/Browse File' feature, making it easy to work with existing data.
Furthermore, users have the option to specify custom settings such as the number of lines to skip and the field separator, allowing for precise data parsing.
ConversionTab provides additional features to enhance the user experience:
- Sample CSV: Click Load Sample to fill the editor with example rows (two contacts) so you can see how headers map to vCard fields.
- Reset: Use Clear to wipe input and output before a new conversion.
The CSV to VCF conversion feature on ConversionTab allows users to seamlessly transform CSV data into VCF (vCard) format, commonly used for contact information storage. Users have two input options: 'Text' and 'File.'
The 'Include' column is a crucial part of the conversion process. It provides a checkbox for each vCard field. Users can check or uncheck these checkboxes to control whether specific vCard fields are included or excluded in the resulting vCard file. This gives users full control over which information is included based on their preferences.
ConversionTab provides the convenience of auto-mapped columns and their corresponding formats:
| # | VCF Field | Mapping | Format |
|---|---|---|---|
| 0 | UID | UID | Unique Identifier |
| 1 | TITLE | Title | Title of Contact |
| 2 | FN | Full Name | Full Name of Contact |
| 3 | TEL | Phone Voice | Voice Phone Number |
| 4 | N | N | Name Components |
| 5 | Email Work | Email Address (Work) | |
| 6 | CATEGORIES | CATEGORIES | Contact Categories |
| 7 | ADR | Address Home | Home Address |
| 8 | URL | URL | Website URL |
| 9 | NOTE | NOTE | Additional Notes |
| 10 | ORG | Organization | Organization Name |
| 11 | BDAY | Birthday | Date of Birth (YYYYMMDD) |
| 12 | GENDER | GENDER | Gender Information |
| 13 | ROLE | ROLE | Contact's Role |
| 14 | IMPP | IMPP | Instant Messaging Protocol |
| 15 | GEO | GEO | Geographical Coordinates |
This auto-mapping simplifies the conversion process by recognizing and configuring common columns automatically.
View complete vCard help & reference
Same questions and answers as above, in the original single-page order—useful if you prefer one continuous scroll, text search, or printing.
1. How does the CSV to VCF conversion work on ConversionTab?
The CSV to VCF conversion feature on ConversionTab allows users to seamlessly transform CSV data into VCF (vCard) format, commonly used for contact information storage. Users have two input options: 'Text' and 'File.'
2. What are the input options for CSV data?
ConversionTab offers users two convenient ways to input their CSV data:
- Text Tab: Users can manually enter CSV data as a valid string in this tab.
- File Tab: Users can upload their CSV file through the 'Drop/Browse File' feature, making it easy to work with existing data.
Furthermore, users have the option to specify custom settings such as the number of lines to skip and the field separator, allowing for precise data parsing.
3. What happens after entering CSV data?
Upon entering CSV data, users are directed to the 'Output Options' section, where the crucial process of mapping CSV columns to vCard fields takes place. Accurate mapping is essential for ensuring that the resulting vCard file contains the desired contact information.
4. What are the special requirements for mapping Email, Phone, and Address?
Mapping Email, Phone, and Address columns involves specific requirements to achieve correct conversions:
- Email: Users must select both the column type (e.g., Email Home) and the corresponding vCard field (e.g., Email). This ensures that the email address is correctly categorized.
- Phone: Similar to Email, Phone mapping requires users to specify both the column type (e.g., Phone Home) and the desired vCard field (e.g., Tel).
- Address: Address mapping involves assigning the column type (e.g., Address Home) to the appropriate vCard field (e.g., ADR).
These specific mappings ensure that contact details are accurately represented in the vCard format.
5. What is the 'Include' column?
The 'Include' column is a crucial part of the conversion process. It provides a checkbox for each vCard field. Users can check or uncheck these checkboxes to control whether specific vCard fields are included or excluded in the resulting vCard file. This gives users full control over which information is included based on their preferences.
6. What are the auto-mapped columns and their formats?
ConversionTab provides the convenience of auto-mapped columns and their corresponding formats:
| # | VCF Field | Mapping | Format |
|---|---|---|---|
| 0 | UID | UID | Unique Identifier |
| 1 | TITLE | Title | Title of Contact |
| 2 | FN | Full Name | Full Name of Contact |
| 3 | TEL | Phone Voice | Voice Phone Number |
| 4 | N | N | Name Components |
| 5 | Email Work | Email Address (Work) | |
| 6 | CATEGORIES | CATEGORIES | Contact Categories |
| 7 | ADR | Address Home | Home Address |
| 8 | URL | URL | Website URL |
| 9 | NOTE | NOTE | Additional Notes |
| 10 | ORG | Organization | Organization Name |
| 11 | BDAY | Birthday | Date of Birth (YYYYMMDD) |
| 12 | GENDER | GENDER | Gender Information |
| 13 | ROLE | ROLE | Contact's Role |
| 14 | IMPP | IMPP | Instant Messaging Protocol |
| 15 | GEO | GEO | Geographical Coordinates |
This auto-mapping simplifies the conversion process by recognizing and configuring common columns automatically.
7. How can I handle multi-valued fields like multiple email addresses?
For multi-valued fields, such as multiple email addresses, ConversionTab provides two methods:
- Combine in a Single Column: Users can include multiple values in a single column, separating them using a specified separator (e.g., Email 1, Email 2, Email 3).
- Add Rows: Alternatively, users can click the '+' button to add additional rows for each value. The '-' button allows users to remove incorrect mappings or unwanted rows.
This flexibility ensures that multi-valued fields are handled efficiently.
8. How do I get the VCF output?
Once the mapping and settings are complete, users can initiate the conversion process by clicking the 'Convert' button. The resulting VCF data is displayed in a textarea, providing users with two options:
- Copy: Users can copy the generated VCF data for use elsewhere.
- Download: Users can download the VCF file, with the option to specify a custom file name if desired.
This flexibility ensures that users can choose the most suitable method for accessing their converted data.
9. Is there an example CSV and a way to reset the input/output data?
ConversionTab provides additional features to enhance the user experience:
- Sample CSV: Click Load Sample to fill the editor with example rows (two contacts) so you can see how headers map to vCard fields.
- Reset: Use Clear to wipe input and output before a new conversion.
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.