How to Import Contacts from Excel or CSV into iPhone, Gmail, or Outlook

You have a list of contacts in Excel or CSV — from a CRM export, event sign-up, or old database — and you need them in your iPhone, Gmail, or Outlook. Most of those apps don’t import CSV or Excel directly; they expect vCard or VCF (contact card) files. The fix is simple: convert your CSV to vCard/VCF, then import. This guide walks you through it step by step, with free tools that run in your browser so your contacts never leave your device.

---

What You Need: CSV or Excel → vCard/VCF

vCard (often saved as .vcf) is the standard format for contact data. iPhone, Gmail, Outlook, and most address books accept it. So the process is:

1. Have your contacts in Excel or CSV — one row per contact, columns for name, email, phone, etc.
2. Convert CSV to vCard/VCF — map your columns to contact fields (name, email, phone, company, etc.).
3. Import the VCF file into iPhone, Gmail, or Outlook.

If your list is in Excel, export or save it as CSV first (File → Save As → CSV), then use the converter. The Tooladex CSV to vCard and CSV to VCF tools do the conversion in your browser; no uploads, no account.

---

Step 1: Prepare Your Contact List (Excel or CSV)

Your file should have one row per contact and column headers in the first row. Common columns:

• Name, Full Name, Contact Name — contact name
• Email, E-mail, Email Address — email
• Phone, Mobile, Telephone, Cell — phone number
• Company, Organization — company
• Title, Job Title — job title

You don’t need every column — name and at least one of email or phone is enough. Extra columns (address, notes, etc.) can be mapped if the converter supports them. Avoid merged cells and multiple header rows; keep one clear header row and data below.

From Excel: Save as CSV (File → Save As → choose “CSV (Comma delimited)” or similar) so the converter can read it.

---

Step 2: Convert CSV to vCard / VCF

1. Open the CSV to vCard Converter or CSV to VCF Converter. Both produce VCF files that work everywhere.
2. Upload your CSV (or paste content if the tool allows).
3. Map columns to contact fields. The tool will show your CSV columns and let you assign each to a vCard field (e.g. “Name” column → Name, “Email” column → Email). Match what you have.
4. Convert and download the .vcf file (or multiple .vcf files if one per contact).

The file(s) are ready to import. Processing happens in your browser — your contact list is not sent to a server.

---

Step 3a: Import Contacts into iPhone

From a single VCF file (all contacts in one file):

1. Send the .vcf file to your iPhone (e.g. email it to yourself, AirDrop, or save to iCloud Drive / Files).
2. On iPhone, open the Mail app (or Files / link where you saved it).
3. Tap the .vcf attachment or the file.
4. Tap “Add All X Contacts” (or add them one by one). Confirm.
5. Contacts are saved to your iPhone Contacts (and sync to iCloud if you use iCloud Contacts).

From multiple VCF files: Open each file and add the contacts the same way. Or merge them into one VCF before importing if your converter supports that.

Tip: If you have many contacts, importing one VCF with all of them is usually faster than many small files.

---

Step 3b: Import Contacts into Gmail

1. On a computer, go to Google Contacts and sign in.
2. Click Import in the left sidebar (or “Create contact” → “Import”).
3. Click Select file and choose your .vcf file (or the CSV file if Gmail offers direct CSV import — Gmail can sometimes import CSV too; for CSV exported from our tool as VCF, use the VCF).
4. Confirm Import. Gmail will add the contacts to “My contacts” or the label you choose.
5. They’ll sync to the Gmail app on your phone and to your Google account.

If you have one VCF with many contacts, Gmail imports them all in one go. For multiple VCFs, repeat the import for each file.

---

Step 3c: Import Contacts into Outlook

Outlook on the web (outlook.com):

1. Go to Outlook.com and sign in.
2. Open People (contacts) from the app launcher (grid icon).
3. Click Manage → Import contacts (or Import).
4. Choose Outlook CSV or vCard (.vcf) if offered. Select your .vcf file.
5. Complete the import. Contacts appear in your Outlook people list.

Outlook desktop (Windows/Mac):

1. Open Outlook → File → Open & Export → Import/Export (or Import from File menu depending on version).
2. Choose Import a vCard file (.vcf) or Import from another program or file and follow the wizard.
3. Select your .vcf file and choose the destination folder (e.g. Contacts).
4. Finish. Contacts are in Outlook and sync if you use an account that supports contact sync.

---

Tips for a Smooth Import

• Column mapping: Match your CSV columns to the right vCard fields. Wrong mapping (e.g. phone in the email field) will put data in the wrong place.
• Encoding: Save your CSV as UTF-8 if you have accents or special characters so names and companies display correctly after import.
• Duplicate contacts: After importing, check for duplicates in the app (iPhone: Contacts; Gmail/Outlook: merge or deduplicate if the app offers it).
• Backup: Keep your original Excel/CSV as a backup before converting and importing.

---

Privacy and Security

The Tooladex CSV to vCard and CSV to VCF converters run entirely in your browser. Your CSV is not uploaded to any server. Conversion happens on your device, so contact data stays private — suitable for personal lists, client contacts, and event attendee data.

---

FAQ

What’s the difference between vCard and VCF?
vCard is the format; VCF is the usual file extension (.vcf). The two Tooladex tools both output VCF files that work on iPhone, Gmail, Outlook, and other contact apps.

Can I import directly from Excel without converting to CSV first?
The converters accept CSV. Export your Excel sheet as CSV (Save As → CSV), then convert to VCF. It only takes a moment.

My CSV has multiple phone columns (e.g. Mobile and Work). Can I map both?
If the converter supports multiple phone or custom fields, map them. Otherwise you may get one phone per contact; check the tool’s mapping options.

Will the contacts sync to my phone after I import to Gmail or Outlook?
Yes, if you’re signed in with the same Google or Microsoft account on your phone. Gmail and Outlook contacts sync across devices when sync is enabled.

I have hundreds of contacts. Will it work?
Yes. Convert to one or more VCF files and import. Large imports may take a few seconds; the apps will add all contacts.

Do I need to create an account to use the converters?
No. Open the tool, upload your CSV, map columns, convert, and download — no sign-up required.

---

Importing contacts from Excel or CSV into iPhone, Gmail, or Outlook is a two-step process: convert to vCard/VCF with the CSV to vCard or CSV to VCF converter, then import the VCF file into your app. Prepare a clear CSV with one row per contact and the right column mapping for a smooth import.