iPad Best way to add contacts from an excel sheet

firestone12 said:

I got a excel sheet that has about 1800 contacts on them, how do I add them to my Ipad?

Click to expand...

If all you have is an Excel spreadsheet and an iPad then your only option is to type them in by hand.

If you have Outlook you can import your spreadsheet into Outlook, and then iTunes will sync your iPad contacts with Outlook.

However, if you got an iPad so you didn't have to mess with Microsoft, I don't know.

Without knowing the exact structure of the spreadsheet its difficult to tell for sure but excel is pretty powerful. Try something along the lines of:

1. Export the file to a commonly used type, I recommend CSV.
2. If you have Excel, hopefully you also have Outlook and can import the files (look on the net, there are quite a few guides)
3. Sync iPad to Outlook.

If you are on a mac try using Address Book instead of Outlook for the import.

If you don't have Outlook and/or don't want to go through any kind of connected sync, you can export them to CSV (like recommended above), upload them into a GMail account, and sync your contacts to your iOS device to that same account.

You should be able to convert all your contacts in your Excel file into a single vCard file (there are free programs on the web for this). You can then import the vCard file contents into your Contacts at icloud.com.

I haven't tried though...