Export iPhone contacts to Excel (CSV or XLS)?

I spoke with Apple to get the answer to converting Apple contacts to .csv. The first step is to select desired entries from your Contacts. (I selected all.) Next go into Numbers and clear all the columns and rows by clicking on dot in upper left hand corner of the table and select Cut. Now, drag and drop selected contacts onto the empty numbers screen. Finally, after examining and editing your result, simply select File>Export to csv. The support person says that she hears it works with Excel too, but I plan to just convert from Numbers as I couldn't the contacts to drag and drop directly.

There is an app for that now :
Export Contacts To Excel, PDF on the App Store

Hope you like it .

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

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:

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

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.

Copy Trans will only export 50 contacts for free (or 150 if you advertise for them on FaceBook) for something that APPLE should provide for FREE (or its $19.95/29.95 for a partial package of their software - not even the full version) - for something that I have not even been shown works)! File transfer should be easy and straight forward and have no added charges...how are businesses supposed to continue investing in apple products if they continue making it impossible to do simple things like exporting contacts lists.

I am rather angry as I write this. I need to create a ONE time backup of my contacts to EXCEL/ACCESS to automate a part of my office. I have downloaded itunes, which is supposed to do this ... but I cannot find it in the menu system, I have installed icloud on a laptop I borrowed and it didn't work. I just need to do my job...I dont want or need music or need to be "{PUSHED}" into purchasing things that are routine for other vendors. Why make it easier for Droid to continue chipping away at market share apple?

Ok, venting done...does anyone have a straight forward free (non-infected) solution? I only have 320 contacts on this phone.

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

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.

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.

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

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.

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.

Another method that's a bit dirty, but works is to export them from iCloud in the vCard format, then import them into your Gmail account, and then export them from Gmail as a CSV file.

Again, a bit dirty, especially if you already have contacts in said Gmail account, but it doesn't require third party software.

The best solution after a lot search that suited my requirement was to download an App "contacts kit" on to the iPhone. Extract all the contacts from iPhone (across groups) in .csv file, mail it to your email id and then import it into contacts on the iMac.

This worked smooth as a whistle.

regards

Ravi

mstonewindwardcovellc wrote:

Ok, venting done...does anyone have a straight forward free (non-infected) solution? I only have 320 contacts on this phone.

Where are your contacts kept? iCloud? Google? Just on the iPhone (i.e. not linked to any email account)?

If they're in iCloud, use your computer to go to www.icloud.com and select Contacts, then select all contacts and export as a single .vcard file. You can try fiddling with .vcard to see if you can get to the promised land, but if you can't get that into Excel or Access then try importing .vcard into a Gmail account, then export from Gmail to .csv format.