iPad Best way to add contacts from an excel sheet

Discussion in 'iPad' started by firestone12, Feb 21, 2013.

  1. macrumors newbie

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

  2. macrumors 601


    Oct 3, 2006
    If all you have is an Excel spreadsheet and an iPad then your only option is to type them in by hand.
  3. macrumors newbie

    Feb 7, 2013
    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.
  4. macrumors 6502a

    Oct 7, 2010
    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.
  5. macrumors 601


    Sep 15, 2011
    Vilano Beach, FL
    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.
  6. macrumors 65816


    Sep 5, 2012
    San Francisco Bay Area, California
    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...

Share This Page