Why does the iPhone Reject an Excel File?
The iPhone has no import option for XLS, XLSX or CSV files. Contacts on iOS read vCard files and synced accounts.
The iCloud site imports vCard files only. Apple states on its page for importing contacts on iCloud.com that a vCard with many people becomes a separate entry for every person.
You need a middle step. Convert the Excel sheet or add it to an account that syncs with the iPhone.
| Method | Needs | Cost |
|---|---|---|
| Mac Contacts app | A Mac and iCloud | Free |
| Converter software | A Windows PC and iCloud | Paid |
| Google account sync | A Google account | Free |
How do You Prepare the Excel File for an Import?
A clean sheet prevents most import errors on the iPhone. Apple lists the rules for a CSV file on its page for importing contacts on a Mac.
- Put one contact in one row and add a header row with names like First Name, Last Name, Phone and Email.
- Remove line breaks inside a contact cell.
- Give every address the same number of fields. Add empty fields where you need them.
- Select File, then Save As and choose CSV (Comma delimited).
Heads Up. Save a copy of the Excel sheet before you convert it. Open the CSV file in a text editor to confirm that commas separate the fields.
How do You Import Excel Contacts Through a Mac?
Method #1: Mac Contacts App (Free)
Who it suits. Anyone with a Mac and an Apple Account. Extra application. None.
- Open the Contacts app on the Mac.
- Select File and then Import. Choose the CSV file and select Open.
- Review the field labels. Select Do not import for a column you do not need.
- Confirm the import.
- Open Settings on the iPhone and select your name. Select iCloud, then Show All and switch on Contacts.
Apple states that contacts sync to every device on the same Apple Account when Contacts is switched on in iCloud settings. The Mac flags duplicates during the import so that you can review them.
How do You Convert Excel Contacts to a vCard File?
Method #2: Excel to vCard Converter (Paid)
Who it suits. Owners of a Windows PC and a large sheet. Extra application. Converter software and Microsoft Excel.
The SysTools Excel to vCard Converter reads CSV, XLS, XLSX, TXT, XLSM, XLSB and XLTX files. The software maps every vCard field to an Excel column.
- Start the converter and select Browse to add the Excel file.
- Preview the contacts and select Next.
- Map the Excel columns to the vCard fields and select Next.
- Tick Allow import of blank addresses when the sheet holds empty addresses and you choose vCard 4.0.
- Choose the destination folder and select Convert.
Import the VCF file next. Sign in at icloud.com, open Contacts and choose the import option from the menu. Apple labels it Import Contact.
Select the VCF file and then open Settings on the iPhone. Switch on Contacts in iCloud.
The converter vendor lists support for Windows 10 and older versions. The demo version previews the contacts before you buy.
How do You Sync a Sheet With a Google Account?
Method #3: Google Account Sync (Free)
Who it suits. People who already use Gmail. Extra application. None.
- Open Google Contacts in a browser and select Import.
- Choose the CSV file and select Import.
- Open Settings on the iPhone, select Contacts and then Accounts.
- Select Add Account and then Google and sign in.
- Switch on Contacts and select Save.
Google lists these phone steps on its page for syncing Google Contacts with a mobile device. The contacts appear in the Contacts app after the sync.
How do You Check the Imported Contacts on the iPhone?
Open the Contacts app on the iPhone and wait a few minutes. Large lists need more time.
- Open Settings, select your name and then iCloud. Confirm that Contacts is switched on.
- Select Settings, then Contacts and then Default Account to see where new contacts go.
- Search the iPhone for one contact by name to test the import.
Where Else do You Go From Here?
- Read the guide to import CSV contacts to iCloud for the steps on the iCloud site.
- Add a ready VCF file with the guide to import a VCF file into an iPhone.
- Use the Excel to vCard migration guide for the field mapping steps.
- Convert a CSV file from another app with the guide to export CSV contacts to vCard.
- Bring Microsoft 365 contacts over with the guide to add Office 365 contacts to an iPhone.
Frequently Asked Questions
Can You Import an Excel File to an iPhone?
No. The iPhone has no import option for Excel files. Convert the sheet to a CSV or vCard file and sync it through iCloud or a Google account.
Which File Format does iCloud Accept for Contacts?
The iCloud site imports vCard files with the VCF extension only.
How do You Convert an Excel Sheet to a VCF File?
Use an Excel to vCard converter. The free route imports the CSV file into Google Contacts and exports the contacts as a vCard file.
Does a Mac Import a CSV File Into Contacts?
Yes. Choose File, then Import in the Contacts app and select the CSV file. Review the field labels before you confirm.
Why do the Contacts Not Show on the iPhone?
Contacts in iCloud is switched off or the default account is another account. Check both settings.
How should an Excel Contact Sheet Look?
Use one contact per row in the CSV file, a header row and the same number of fields in every address. Remove line breaks inside a cell.
Does the iPhone Sync a Google Account for Contacts?
Yes. Add the Google account under Contacts and Accounts in Settings and switch on Contacts.
Author's Verdict
Use the Mac Contacts app or a Google account for a CSV file that must reach the iPhone. Both routes cost nothing.
Choose the converter when you own a Windows PC and need field mapping for a large sheet.
Key Takeaways
- An iPhone cannot import an Excel file.
- A CSV file reaches the iPhone through a Mac or a Google account.
- iCloud accepts vCard files only.
Related Guides