exporting apple mail addresses to excel

[rob.matthews]

I use apple mail. I just got an email forwarded to me from my boss. The initial message was sent to thousands of other email addresses and I need to somehow (hopefully efficiently) place each address into its own cell in an excel sheet. What's the best way to go about doing this?

So far I've tried simply copying and pasting but they all go into a single cell. They also have all of these "real names" associated with the addresses that I don't want to include. The list is formatted like this within apple mail.

"Firstname Lastname" <firstlast@fake.com>

Thanks!

 

[GGJstudios]

You should edit your post and remove email addresses. You're violating the privacy of those people.
You can explain the same thing without displaying real email addresses by doing something like this:

"Firstname Lastname" <firstlast@fake.com>
​

Copy and paste the list into Word and clean them up there first.

 

[devburke]

I don’t know about Excel, but if you have Numbers available to you, you can just drag the contacts into there, and it will make a nice spreadsheet of them. You can then exclude the columns with data like Names and stuff. If you don’t have numbers, maybe highlighting all your contacts and exporting as a vCard, then converting to .csv with something like [URL="http://labs.brotherli.ch/vcfconvert/“]this[/URL] would work.