How to Transfer Contacts from Excel to iPhone?

It is boring and time-consuming to input each contact detail into corresponding fields of your iPhone Contacts manually, especially when you need to type a bunch of contacts. Believe it or not, now it is possible for you to type or copy&paste contacts by using Excel software and then transfer contacts you saved in Microsoft Excel spreadsheet to your iPhone contact list. No third-party software needs to be installed. Below are the detailed steps on how to transfer contacts from Microsoft Excel to iPhone.

Tips: Most of the time, we need to backup our iPhone data when we make necessary upgrades for our devices. In that case, I think you may need the iPhone to Computer Transfer. It is a versatile tool which can backup all iPhone contents, including contacts, call lists, photos, videos, music, bookmarks and more to your computer.

Follow the Guide to Sync Contacts from Excel to iPhone

Things you'll need for this task: iPhone USB cable.

Step 1: Save contacts in Excel into CSV format

Open the contacts spreadsheet in Microsoft Excel, click the icon of "Disk" and pop up a "Save" dialog box. Give a name for the file and choose ".csv" as the output format from the format list, then you can click the "Save" button.

Step 2: Import CSV files into Outlook Express

Turn to your computer main menu, click the button of "Start" and select the option of "Outlook Express". Choose the "File" menu and select "Address Book" from the "Import" drop-down menu. Find your CSV files from your computer hard drive and click the "Open" button to load it. Wait until Outlook Express notifies you that the loading has finished.

Step 3: Connect your iPhone to the computer and launch iTunes

Hook up your iPhone to the computer via the USB cable and then iTunes will open automatically. If not, you can click the button of "Start" and select iTunes to launch it. Choose the name of the iPhone in iTunes interface and open the tab of "Info".

Step 4: Sync CSV files to iPhone Contacts

Check the box besides the "Sync Contacts With" option and select "Outlook Express" from the drop-down list. Go back to the "Summary" tab and click the "Sync" button. Then, iTunes will begin to sync the CSV files from Outlook Express to your iPhone immediately. When the sync finishes, you can eject your iPhone from the computer. Open the iPhone Contacts, you will see the Excel files now display in your iPhone contact list.