iPad Best way to add contacts from an excel sheet

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

  1. macrumors newbie

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


    Thanks
     
  2. macrumors 601

    brand

    Joined:
    Oct 3, 2006
    Location:
    127.0.0.1
    #2
    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

    Joined:
    Feb 7, 2013
    #3
    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

    Joined:
    Oct 7, 2010
    #4
    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 68040

    D.T.

    Joined:
    Sep 15, 2011
    Location:
    Vilano Beach, FL
    #5
    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

    KeepCalmPeople

    Joined:
    Sep 5, 2012
    Location:
    San Francisco Bay Area, California
    #6
    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