13 Replies Latest reply: Mar 12, 2014 11:36 AM by rockmyplimsoul
HumphV Level 1 Level 1 (15 points)

I wish to export all my iphone contact data to a single excel worksheet. Is there a way to export the data to an xls or a csv format (not separate csv files for each contact). I have the contacts in both my iPhone and the iCloud, but iCloud allows export as a vCard only.


iPhone 4S, iOS 5.1.1
  • 1. Re: Export iPhone contacts to Excel (CSV or XLS)?
    KiltedTim Level 8 Level 8 (37,810 points)

    Not on the phone, no. You would need to export them from whatever address book you're syncing with iCloud on your computer if it offers that option.

  • 2. Re: Export iPhone contacts to Excel (CSV or XLS)?
    aThanasi Level 2 Level 2 (290 points)

    Not possible from within the icloud. If you are on a Mac, have your contacts appear in the Address Book. Next, select all of your contacts and drag/drop them into iWorks Numbers instead. It would work as excel sheet in that your contacts and contact data is displayed in a list which you can then print.

     

    If you are on a PC, use copytrans contacts. Run the program, plug in your iPhone to your PC, and hit on the Export button. Next, choose Excel as the export format:

     

    /___sbsstatic___/migration-images/195/19544108-1.jpg

     

    You will end up with a list of your contact data in an Excel spreadsheet.

  • 3. Re: Export iPhone contacts to Excel (CSV or XLS)?
    HumphV Level 1 Level 1 (15 points)

    Thank you for your answer - this solved my question.

  • 4. Re: Export iPhone contacts to Excel (CSV or XLS)?
    rfreschner Level 1 Level 1 (0 points)

    Is this supposed to work for all of the contact info?  I tried this with Numbers '09 and I got some info (name, phone #, email address), but no address, etc.

  • 5. Re: Export iPhone contacts to Excel (CSV or XLS)?
    marc1184 Level 1 Level 1 (0 points)

    It's easy...just watch this youtube video.  Export the vCards to your desktop, and then go here to convert them to a CSV. Worked like a charm, and I was able to open them with excel for Mac

  • 6. Re: Export iPhone contacts to Excel (CSV or XLS)?
    cdr478s Level 1 Level 1 (0 points)

    What process would I use to export contacts from someone's old iPhone 4 to 4s (personal to business phone). Need to export her contacts off the old phone and onto the new, but she doesn't have Outlook or anything on her PC that I am aware of. She has iCloud setup, but I am not seeing a way to export from that (unless I'm missing it). She does have gmail, wondering if anything could I sync to her gmail account somehow then export from there? Bottom line need to get it into her company Outlook so it can sync through Exchange.

  • 7. Re: Export iPhone contacts to Excel (CSV or XLS)?
    rockmyplimsoul Level 5 Level 5 (5,495 points)

    If she uses a computer to log into her iCloud account, she can export her contacts as a vCard file, which can then be imported into your iCloud account (when logged into iCloud via a computer, click on Contacts then look for the "gear" at the lower-left corner).  She can also do a similar thing from her GMail account, but if you want to import to your iCloud make sure she exports as vCard since that's all iCloud can read.


    There are also apps that export your contacts in a variety of formats and I think it then sends the exported file as an e-mail attachment.  That might be the easiest process, assuming that you both have the same app or at least compatible apps that can export/import the same file type.

  • 8. Re: Export iPhone contacts to Excel (CSV or XLS)?
    cdr478s Level 1 Level 1 (0 points)

    Thanks! She does have iCloud already enabled on the old phone and I see the control panel for iCloud on her computer. I'll look to see if I can find some more instructions on exporting while logged into iCloud. I didn't see much, and there was a screen we couldn't seem to get past. On gmail, She doesn't seem to think the contacts are in gmail, but only on her phone itself, but I'll have her open that up and check. That I definitely know how to export.

  • 9. Re: Export iPhone contacts to Excel (CSV or XLS)?
    shhhh Level 1 Level 1 (0 points)

    Thank you! I found your message buried in and around so many useless suggestions. So helpful!

  • 10. Re: Export iPhone contacts to Excel (CSV or XLS)?
    shier877 Level 1 Level 1 (10 points)

    sms-extractor-big-01.jpg

    Method 1: Sync your contacts with iCloud or with an address book app on your computer via a USB connection or with gmail contacts or Yahoo contacts. Or just back up your phone to iTunes or iCloud, then restore the backup after you restore the phone. It's an automatic part of the Restore process.

     

    Method 2: Use iPhone backup extractor program,

     

    I used Vibosoft iPhone backup extractor prgoram, it can export all data from iPhone to computer, for contacts, it can export to local hard drive and save as Excel format.

    http://www.vibosoft.com/ios/export-iphone-contacts-to-excel-csv-mac.html

  • 11. Re: Export iPhone contacts to Excel (CSV or XLS)?
    shier877 Level 1 Level 1 (10 points)

    thats the problem i cant sync anything to icloud, because there's an error... it say something about itunes can't copy iphone because there's an error, thats it, nothing else... so i cant have a safety copy in icloud or my computer...

  • 12. Re: Export iPhone contacts to Excel (CSV or XLS)?
    Chucks0103 Level 1 Level 1 (0 points)

    I'd like to make a copy of the contacts on my iphone (i have an iphone 4) and I use a MacBook Air, SnowLeopard --- but here's the concern/confusion:

     

    My iphone uses Exchange because I keep my contacts are google based and my e-mail is gmail.  So if I sync my phone to my computer via itunes, I am afraid I will just duplicate things and contacts will be all over the place.  (I've noticed that some of my contact info on my iphone do not even appear in my gmail contacts ---- but I think that may be for another day(!)).  I'd like to export my iphone contacts to excel (or wherever) (and I will also will want to export my gmail contacts to excel (which I will do another time)) for the purposes of seeing what gmail I am missing (which appear on my iphone). 

     

    (I think using the Exchange is what has been making things a little confusing for me).

    Thank you.

  • 13. Re: Export iPhone contacts to Excel (CSV or XLS)?
    rockmyplimsoul Level 5 Level 5 (5,495 points)

    Chucks0103 wrote:

     

    I'd like to export my iphone contacts to excel (or wherever) (and I will also will want to export my gmail contacts to excel (which I will do another time)) for the purposes of seeing what gmail I am missing (which appear on my iphone).

     

    (I think using the Exchange is what has been making things a little confusing for me).

    Exchange shouldn't have anything to do with it, and syncing your iPhone to your computer would not cause duplication.  But maybe clarify your set-up ... are all your contacts in Google, or do you have Google contacts as well as some other source? (e.g. Yahoo, iCloud, etc.)

     

    It sounds like you've set up your Gmail account as Exchange (good, but see warning below) so if all your contacts are in Google, you can export them as a .csv file from your computer, then import that into Excel (or whatever).  You can also export them as vcard to be imported into iCloud, if you wanted to leave Google.

     

    If you also have another separate source of contacts, where are they being stored?  Is your goal to merge multiple sources of contacts into one source?

     

     

     

    Chucks0103 wrote:

     

    My iphone uses Exchange because I keep my contacts are google based and my e-mail is gmail.

    If you've set up your Gmail account as Exchange, that is good but do realize that (a) you'll lose that capability once you change to a new iPhone someday, and (b) you should check your "All Mail" for things you thought you deleted.

     

    Google pulled the plug on Active Sync early 2012, but you can continue to use it if you had it set up prior to that date.  Once you activate a new device you won't be able to use Exchange for Gmail, unless you have a special Gmail account (i.e. business or education).  The good news is that as of iOS 7 a standard Gmail account set up in iOS includes syncing contacts to Google, just like you have it now as Exchange.  The bad news is that Gmail on iOS is still Fetch-based, not Push like with Exchange.

     

    The other effect of Google pulling the plug on Active Sync is that "Delete" no longer deletes, it Archives (even if you had gone to the m.google.com server to change your preference to delete items).  While I was on Exchange, I found a few months of stuff I thought I deleted in my All Mail, and it started when Google pulled the plug on Active Sync.