Go Back   MacRumors Forums > iPhone, iPod and iPad > iPad

Reply
 
Thread Tools Search this Thread Display Modes
Old Feb 21, 2013, 07:59 PM   #1
firestone12
macrumors newbie
 
Join Date: Jan 2012
Best way to add contacts from an excel sheet

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


Thanks
firestone12 is offline   0 Reply With Quote
Old Feb 21, 2013, 08:10 PM   #2
brand
macrumors 68040
 
brand's Avatar
 
Join Date: Oct 2006
Location: 127.0.0.1
Quote:
Originally Posted by firestone12 View Post
I got a excel sheet that has about 1800 contacts on them, how do I add them to my Ipad?
If all you have is an Excel spreadsheet and an iPad then your only option is to type them in by hand.
brand is offline   0 Reply With Quote
Old Feb 21, 2013, 08:49 PM   #3
medwards5025
macrumors newbie
 
Join Date: Feb 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.
medwards5025 is offline   0 Reply With Quote
Old Feb 21, 2013, 09:12 PM   #4
macsrcool1234
macrumors 6502a
 
Join Date: Oct 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.
macsrcool1234 is offline   1 Reply With Quote
Old Feb 21, 2013, 10:45 PM   #5
D.T.
macrumors 68030
 
D.T.'s Avatar
 
Join Date: Sep 2011
Location: 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.
__________________
"I am not in danger, Skyler. I am the danger. A guy opens his door and gets shot, and you think that of me? No, I am the one who knocks." ~Walter White
D.T. is offline   0 Reply With Quote
Old Feb 21, 2013, 10:53 PM   #6
KeepCalmPeople
macrumors 6502a
 
KeepCalmPeople's Avatar
 
Join Date: Sep 2012
Location: 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...
KeepCalmPeople is offline   0 Reply With Quote

Reply
MacRumors Forums > iPhone, iPod and iPad > iPad

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Similar Threads
thread Thread Starter Forum Replies Last Post
When I add contacts into my iCloud/iPhone, any way to auto-add to Google Contacts? iHavequestions iCloud and Apple Services 4 Nov 26, 2013 05:01 PM
sheet naming when exporting numbers file to excel daz1985 Mac Applications and Mac App Store 0 Sep 9, 2013 04:02 PM
How do I add contacts? entraik iOS 7 1 Jun 10, 2013 09:46 PM
Excel: How to add a table into a single cell champ01 Mac Applications and Mac App Store 3 Jan 18, 2013 02:38 PM
Contacts and iMessage contacts don't seem to add up? RamGuy OS X 10.8 Mountain Lion 0 Oct 6, 2012 07:23 AM

Forum Jump

All times are GMT -5. The time now is 06:52 PM.

Mac Rumors | Mac | iPhone | iPhone Game Reviews | iPhone Apps

Mobile Version | Fixed | Fluid | Fluid HD
Copyright 2002-2013, MacRumors.com, LLC