Register FAQ / Rules Forum Spy Search Today's Posts Mark Forums Read
Go Back   MacRumors Forums > iPhone, iPod and iPad > iPad

Reply
 
Thread Tools Search this Thread Display Modes
Old Feb 21, 2013, 06: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, 07: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, 07: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, 08: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, 09:45 PM   #5
D.T.
macrumors 68020
 
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.
__________________
"It is not daily increase but daily decrease; hack away the unessential." ~Bruce Lee
D.T. is offline   0 Reply With Quote
Old Feb 21, 2013, 09:53 PM   #6
KeepCalmPeople
macrumors 6502a
 
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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -5. The time now is 05:43 AM.

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

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