how to export contacts to excel?
ANyone know how I can get names and emails from my Contacts list into Excel or Numbers?
MacBook Pro with Retina display, iOS 7.0.4
Apple Event: May 7th at 7 am PT
ANyone know how I can get names and emails from my Contacts list into Excel or Numbers?
MacBook Pro with Retina display, iOS 7.0.4
You probably have the answer to this by now (or the need has gone away), but perhaps this will help someone else who comes across this thread like I did. I too had a need to decipher a v-card file and found this (link, apparently from the University of NC) on-line yesterday. It worked surprisingly well, nothing major to download and no fees.
You probably have the answer to this by now (or the need has gone away), but perhaps this will help someone else who comes across this thread like I did. I too had a need to decipher a v-card file and found this (link, apparently from the University of NC) on-line yesterday. It worked surprisingly well, nothing major to download and no fees.
You're welcome. And you're right, it is incredibly easy and I do not have the Numbers app on this old Mac. I suspect there are plenty of other apps that will accomplish the same thing but I had no need to go any further than I did.
Export the contacts to the desktop, this will produce a vCard file, use a converter to convert it to a .csv file. Open that file with Excel.
Million times easier: just drag & drop the contact(s) you want from the contacts app into a new Numbers spreadsheet. Magically makes a table. Apparently this has been around for a long time. Wish I knew abt this earlier. It's awesome!
Phil...thanks! This was exactly what I wanted. Worked great.
Care to share with us the converter without which the answer is useless?
Amazing, so easy! Wish I knew this sooner. Thank you!
Thanks, this was incredibly simple! Wish I'd had this years ago, it took seconds to do, and is fantastic if you don't have the numbers app as suggested above!
I tried that and it didn't work, noticed this answer was published in 2014, did something change?
They must have changed something in Numbers or Contacts because it no longer works.
how to export contacts to excel?