How to Import Contacts From Excel to iPhone: Convert to VCF and Add Them All at Once
How to import contacts from Excel to iPhone: save the sheet as CSV, convert it to a VCF file free in your browser, then add every contact at once.

On this page
- Can you import contacts from Excel to an iPhone directly?
- Which method should you use?
- How to import contacts from Excel to iPhone with a free converter
- How do you import a VCF file through iCloud.com?
- How do you get Excel contacts onto an iPhone without converting?
- Can you import contacts from Excel on a Mac?
- A worked example from our own client work
- Why do imported contacts come out wrong?
- How many contacts can you add to an iPhone at once?
- Is it safe to convert a contact list online?
- What if your contacts are not in a spreadsheet yet?
- Frequently asked questions
- Conclusion: key takeaways
- Editorial policy
- Content transparency
- About the author
Here is how to import contacts from Excel to iPhone: save the sheet as a CSV file, convert that CSV into a VCF (vCard) file, then open the VCF on your iPhone and tap Add All Contacts. The iPhone Contacts app cannot read an Excel or CSV file directly, so the conversion step is the one that matters. Our free CSV to VCF converter does it in your browser in under a minute, with the columns matched for you.
Below we cover every route we use with client contact lists: the browser converter, iCloud.com, Google Contacts sync and the Mac Contacts app, plus the Excel formatting problems that break phone numbers and names.
Quick answer: Convert the spreadsheet to vCard, then import the vCard.
- Step 1: In Excel, choose File, Save As and pick CSV UTF-8 (Comma delimited).
- Step 2: Drop the CSV into the free Excel to vCard converter, check the column matching and download the .vcf.
- Step 3: Email or AirDrop the .vcf to your iPhone, open it and tap Add All Contacts, or import it at icloud.com/contacts.
- No conversion option: import the CSV into Google Contacts and sync your Google account to the iPhone.
- Before you start: format phone columns as text so Excel does not strip the plus sign or leading zeros.
Free LeadCanal tools for this guide
Check and fix it yourself in a few seconds, no signup needed.
Can you import contacts from Excel to an iPhone directly?
No. iPhone Contacts accepts vCard (.vcf) files, not .xlsx or .csv files. If you email yourself a spreadsheet and tap it, the iPhone opens a preview of the sheet and offers no option to add the rows as contacts.
That leaves two paths:
- Convert first: turn the spreadsheet into a single VCF file that holds every contact, then open it on the iPhone or upload it to iCloud.
- Go through a service that reads CSV: Google Contacts and Outlook both import CSV files. Once the contacts sit in that account, the iPhone syncs them.
We use the first path for one-off lists, because the contacts end up in iCloud with no extra accounts involved. We use the second when a client already keeps their phone book in Google Workspace.
Which method should you use?
| Method | Cost | File uploaded? | Needs a computer? | Best for |
|---|---|---|---|---|
| LeadCanal CSV to VCF converter + iPhone | Free | No, runs in your browser | No, works on the iPhone too | Most lists, from 5 to several thousand rows |
| Converter + iCloud.com import | Free | Only the finished VCF, to your own iCloud | Easier on a computer | Large lists and syncing to every Apple device |
| Google Contacts CSV import + sync | Free | Yes, the CSV goes to Google | Easier on a computer | People who already use Gmail or Google Workspace |
| Outlook CSV import + sync | Included with Outlook | Yes, to Microsoft | Yes | Business accounts on Exchange or Microsoft 365 |
| Mac Contacts app | Free | No | Yes, a Mac | Mac users who want to review fields first |
| Third-party iPhone apps | Often paid or ad-supported | Depends on the app | No | Repeated imports straight from a phone |
How to import contacts from Excel to iPhone with a free converter
This is the method we use most, and it is the one we built our spreadsheet to contacts converter for.
Step 1: Prepare and save the sheet as CSV
- Put one contact per row and one field per column, with a header row such as First Name, Last Name, Company, Email, Mobile.
- Select the phone columns and set the cell format to Text before you paste or type numbers. This keeps the plus sign and leading zeros.
- In Excel on Windows or Mac, choose File, Save As (or Save a Copy) and pick CSV UTF-8 (Comma delimited). UTF-8 keeps accented names such as José or Zoë intact.
- In Google Sheets, use File, Download, Comma-separated values. In Apple Numbers, use File, Export To, CSV.
Step 2: Convert the CSV to VCF
- Open the free CSV to VCF tool on your computer or directly in Safari on the iPhone.
- Choose your CSV file. The tool reads comma, semicolon, tab and pipe separated files, so exports from European Excel versions work too.
- Check the column matching. First name, last name, full name, company, job title, two emails, mobile, work, home and other phones, address fields, website, LinkedIn URL, birthday and notes are matched from your headers. Change any that look wrong.
- Leave First row is a header ticked if your sheet has headings.
- Click Convert to VCF and download the file. It is written in vCard 3.0, the version iPhone, Android, Google and Outlook all read.
If you only have a Full Name column, the tool splits it into first and last name for you. Rows with no name, email, phone or company are skipped, and the result message tells you how many.
Step 3: Add the VCF to the iPhone
- Send the .vcf to yourself by email, AirDrop or Messages, or save it to the Files app.
- Tap the file. The iPhone shows a preview of the contacts it found.
- Tap Add All Contacts (the button shows the number, for example Add All 248 Contacts).
- Open the Contacts app and search a few names to confirm phones and emails landed in the right fields.
If you see no add button after opening the file from Files, use the share button and choose Contacts, or use the iCloud.com method below.
How do you import a VCF file through iCloud.com?
iCloud is the better route for big lists or when you want the contacts on your iPhone, iPad and Mac at the same time. Apple’s iCloud user guide describes the import like this:
- Go to icloud.com/contacts on a computer and sign in with your Apple Account.
- Click the add button and choose the option to import a contact (vCard).
- Select the .vcf file from the converter.
- On the iPhone, make sure iCloud Contacts sync is switched on in Settings under your name, iCloud.
Each person in a multi-contact vCard becomes a separate entry in All Contacts. Apple also has an iPhone guide to importing contacts that covers SIM cards and other accounts.
How do you get Excel contacts onto an iPhone without converting?
Google Contacts can read a CSV file. Google’s import contacts help page explains the import, and the flow is short:
- Open contacts.google.com on a computer and click Import.
- Choose your CSV and import it. Google works best with its own column names, so a sheet with odd headers can map badly.
- On the iPhone, add the same Google account in the Contacts settings (Contacts Accounts, Add Account, Google) and switch Contacts on.
The downside is that your list now lives in a Google account. That is fine for your own contacts, but a client or customer list should not end up in a personal Gmail account just to reach a phone. Outlook works the same way through its CSV import and an Exchange or Microsoft 365 account on the iPhone.
Can you import contacts from Excel on a Mac?
Yes. The Contacts app on macOS imports vCard files through File, Import, and it can also take a CSV or text file and ask you to review how each column maps to a field. Once the contacts are in the Mac’s iCloud account, they appear on the iPhone. If the field review feels fiddly, convert the sheet with the VCF converter first and import the vCard instead.
A worked example from our own client work
A typical case for us: a client sends an Excel export from their CRM with 300 field sales contacts and wants them on a new team iPhone before a trade show. The columns are Contact Name, Account, Title, Work Email and Cell.
- We open the sheet, set the Cell column to Text and find a few numbers that Excel had already turned into scientific notation, such as 4.47E+11. We re-paste those from the CRM.
- We delete two blank rows and a totals row at the bottom, then save as CSV UTF-8.
- In the converter, Contact Name maps to Full name, Account to Company, Title to Job title, Work Email to Email and Cell to Mobile phone. We confirm the mapping and convert.
- We preview the first contact in the tool, AirDrop the .vcf to the phone and tap Add All Contacts.
- We spot-check five contacts, and turn on the iPhone’s duplicate merge where the phone already held some of the same people.
The whole job takes a few minutes, and the list never leaves the laptop and the phone.
Why do imported contacts come out wrong?
| Problem | Likely cause | Fix |
|---|---|---|
| Phone shows 4.47E+11 | Excel stored the number as a number | Format the column as Text and re-enter, or prefix with an apostrophe |
| Leading 0 or + is missing | Same number formatting issue | Format as Text before saving; use international format such as +44 |
| Names show odd symbols | CSV saved in a non-UTF-8 encoding | Save as CSV UTF-8 and convert again |
| Everything lands in one field | Semicolon separated file or no header | Our tool detects separators; check the column matching and header box |
| Only one contact imported | File opened in an app that reads only the first card | Import at icloud.com/contacts, or export one .vcf per contact |
| Contacts appear twice | The list overlaps existing contacts | Use the duplicate merge prompt in Contacts, or dedupe in Excel first |
| Contacts missing on the iPhone | Imported into an account that is not synced | Check which account holds them and switch Contacts sync on |
For desktop Outlook, which opens only the first contact in a combined file, tick One .vcf file per contact in the converter and you get a ZIP of single cards.
How many contacts can you add to an iPhone at once?
Apple does not publish a hard limit for a vCard import. We have imported lists in the thousands without trouble, but very large files load faster through iCloud.com than from a Mail attachment. If a list is huge, split it into smaller files with the CSV splitter, then convert each part.
Is it safe to convert a contact list online?
A contact list is other people’s personal data: names, phone numbers and often home addresses. Many online converters upload that file to their server to process it.
Our converter runs entirely in your browser, so the CSV is never uploaded to LeadCanal or anyone else, and nothing is stored once you close the tab. The tool also only opens CSV, TSV and TXT files and checks each file before reading it. If you later need the contacts back in a spreadsheet, the VCF to CSV converter works the same private way.
What if your contacts are not in a spreadsheet yet?
If the names and numbers sit in a plain text list, turn it into columns with the TXT to CSV converter. Our guide on converting TXT to CSV explains delimiters and messy line breaks. Then convert the CSV as above.
Frequently asked questions
How to import contacts from Excel to iPhone without iTunes?
Save the sheet as CSV, convert it to VCF, then open the VCF on the iPhone or import it at icloud.com/contacts. No iTunes, Finder sync or cable is needed.
Can I import a CSV file straight into iPhone Contacts?
No. The iPhone reads vCard files only. Convert the CSV to VCF first, or import the CSV into Google Contacts and sync that account.
Can I do the whole thing on my iPhone?
Yes. Save the CSV to Files, open the converter in Safari, convert and download the VCF, then open it from Files and add the contacts.
Which vCard version works best with iPhone?
vCard 3.0 is the safest choice. It is what our converter writes, and iPhone, Android, Google and Outlook all read it reliably.
Will contact photos import from Excel?
No. A spreadsheet holds text, not images, so photos have to be added on the iPhone afterwards.
How do I import contacts from Excel to Android instead?
Convert to VCF the same way, then open the Contacts app, go to settings, choose Import and pick the .vcf file.
Can I add the contacts to a group?
On iCloud.com you can drag imported contacts into a list after the import. The iPhone itself does not assign a group during a vCard import.
How do I undo a bad import?
There is no undo button. Delete the wrong contacts on iCloud.com, where you can select several at once, fix the CSV and import again.
Conclusion: key takeaways
The answer to how to import contacts from Excel to iPhone is always the same: get the sheet into vCard format, then let the iPhone or iCloud add every card in one go. Clean phone columns first and the rest takes minutes.
- iPhone Contacts reads VCF files, so convert the spreadsheet before importing.
- Save from Excel as CSV UTF-8 to keep accented names intact.
- Format phone columns as text so Excel keeps plus signs and leading zeros.
- Open the VCF and tap Add All Contacts, or import it at icloud.com/contacts.
- Google Contacts can import CSV directly, but your list then sits in that account.
- Convert contact lists in a browser tool that never uploads the file.
Ready to move your list? Open the free CSV to VCF converter, or browse all our free file tools.
Key takeaways
Importing Excel contacts to iPhone
| 1 | iPhone Contacts reads VCF files, so convert the spreadsheet before importing. |
| 2 | Save from Excel as CSV UTF-8 to keep accented names intact. |
| 3 | Format phone columns as text so Excel keeps plus signs and leading zeros. |
| 4 | Open the VCF and tap Add All Contacts, or import it at icloud.com/contacts. |
| 5 | Google Contacts can import CSV directly, but your list then sits in that account. |
| 6 | Convert contact lists in a browser tool that never uploads the file. |
Editorial policy
LeadCanal publishes practical guides for people who work with files and contact data every day. We write from hands-on use of the tools we build, check steps against official Apple and Google help pages, describe menus generally where they change between versions, and update articles when platforms change.
Content transparency
This article was researched with keyword and search results data and checked against official documentation from Apple and Google. LeadCanal offers the free tools mentioned here, including the CSV to VCF converter, VCF to CSV converter, CSV splitter and TXT to CSV converter. We have no affiliation with Apple, Google or Microsoft.
About the author
This guide was written by the LeadCanal team. We build verified B2B contact lists and run cold email infrastructure for clients, which means moving CSV lead lists and VCF contact files between CRMs, spreadsheets and phones daily. We built our browser-based converters to make that work faster and more private.