Skip navigation

Export iPhone contacts to Excel (CSV or XLS)?

50602 Views 13 Replies Latest reply: Mar 12, 2014 11:36 AM by rockmyplimsoul RSS
HumphV Level 1 Level 1 (15 points)
Currently Being Moderated
Sep 11, 2012 5:57 AM

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
  • KiltedTim Level 8 Level 8 (35,975 points)
    Currently Being Moderated
    Sep 11, 2012 6:50 AM (in response to HumphV)

    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.

  • aThanasi Level 2 Level 2 (270 points)
    Currently Being Moderated
    Sep 12, 2012 9:20 AM (in response to HumphV)

    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.

  • rfreschner Level 1 Level 1 (0 points)
    Currently Being Moderated
    Dec 1, 2012 6:22 AM (in response to aThanasi)

    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.

  • marc1184 Level 1 Level 1 (0 points)
    Currently Being Moderated
    Jan 25, 2013 9:28 AM (in response to HumphV)

    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

  • cdr478s Level 1 Level 1 (0 points)
    Currently Being Moderated
    Feb 4, 2013 5:37 PM (in response to HumphV)

    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.

  • rockmyplimsoul Level 5 Level 5 (5,375 points)
    Currently Being Moderated
    Feb 4, 2013 6:26 PM (in response to cdr478s)

    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.

  • cdr478s Level 1 Level 1 (0 points)
    Currently Being Moderated
    Feb 4, 2013 6:25 PM (in response to HumphV)

    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.

  • shhhh Level 1 Level 1 (0 points)
    Currently Being Moderated
    Sep 9, 2013 9:29 PM (in response to marc1184)

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

  • shier877 Level 1 Level 1 (10 points)
    Currently Being Moderated
    Dec 9, 2013 10:38 PM (in response to HumphV)

    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

  • shier877 Level 1 Level 1 (10 points)
    Currently Being Moderated
    Dec 9, 2013 10:39 PM (in response to HumphV)

    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...

  • Chucks0103 Level 1 Level 1 (0 points)
    Currently Being Moderated
    Mar 12, 2014 9:40 AM (in response to HumphV)

    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.

  • rockmyplimsoul Level 5 Level 5 (5,375 points)
    Currently Being Moderated
    Mar 12, 2014 11:36 AM (in response to Chucks0103)

    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.

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.