Transferring contacts from Microsoft Excel to your iPhone is a three-stage process. First you must export the contacts from Excel to a Comma-Separated Values, or CSV, file. From there, you import the CSV contacts into Outlook, the native email program on your Windows computer. Finally, you sync those contacts from Outlook to your iPhone via iTunes.
Export Contacts From Excel
Click "File" on the main menu in Excel and select "Save As." Make sure you click "Save As" instead of "Save," otherwise Excel will save the contacts spreadsheet in the XLSX file format.
Video of the Day
Click the "Save as type" drop-down menu and select "CSV (Comma delimited)" from the list of available file types if you're using a Windows computer. If you're using a Mac, select "CSV (Macintosh)."
Enter a name for the CSV file in the "File name" field, click "Save" and then click "Yes" to confirm that you want to use the CSV file format. Make a note of the location where you save the CSV file as you will need it again when importing the contacts into Outlook.
Import Contacts to Outlook
Launch Outlook and click "File | Open & Export | Import/Export | Import From Another Program or File | Next."
Click "Comma Separated Values" on the list of available file formats and then click the "Next" button. On the following screen, browse for the CSV file you exported from Excel and double-click it.
Select how you want to handle duplicate contacts. You can replace duplicates, create duplicates or ignore duplicates altogether. Click "Next" when you've made your selection.
Select the folder into which you want to import your contacts. The Contacts folder is selected by default, and for most applications this folder need not be changed. However, you may elect to create a new folder or import your contacts into another existing folder. Click "Next" when you are finished.
Verify that the check box is checked next to the name of your CSV file, and then click the "Map Custom Fields" button. Map your fields by dragging and dropping contact data types together. For example, you need to drag and drop the name fields from your CSV file onto the corresponding name fields in Outlook. Drag from the left column to the right.
Click "Finish" to finish importing your contacts into Outlook.
Sync With IPhone Via iTunes
Connect your iPhone to your computer using its USB cable. Launch iTunes on the computer if it does not launch automatically. If you've connected your iPhone to your computer before, chances are iTunes will launch automatically.
Click the name of your iPhone on the Devices bar in the upper right corner of iTunes.
Click the "Info" tab on the horizontal menu bar and place a check mark in the "Sync Contacts With" check box. Select the Outlook email account into which you imported your Excel contacts, and then click the "Apply" button to transfer the contacts onto your iPhone. You may also have to click the "Sync" button depending on how your iPhone and iTunes are configured.
Design your Excel spreadsheet to help simplify the import process. Arrange the contacts so that they are categorized in columns. Put all of the contact names in the A column, for example, and then proceed through the columns inserting contact categories. You might, for example, put phone numbers is column B, mailing addresses in column C, and so forth.
If your iPhone does not appear in the upper right corner of iTunes, you may need to hide the iTunes sidebar. You do this by clicking "View" on the main menu in iTunes and selecting "Hide Sidebar."
Information in this article applies to Excel 2013, Outlook 2013 and iTunes 11. It may vary slightly or significantly with other versions or products.