Register FAQ / Rules Forum Spy Search Today's Posts Mark Forums Read
Go Back   MacRumors Forums > Apple Systems and Services > OS X

Reply
 
Thread Tools Search this Thread Display Modes
Old Dec 13, 2007, 08:03 PM   #1
flyingfishgirl
macrumors newbie
 
Join Date: Dec 2007
Location: NYC
EXPORT Address Book contacts to Excel?

I currently keep all of my contacts in Address Book, and need to create mailing labels from a group of them (I already created and populated the group). If I try to "print labels" from address book, it tries to print a label for every address in the group -- so in cases where a contact has multiple addresses, it wants to print more than one. This process also won't let me edit the labels to modify names, add "Mr. & Mrs." etc.

I want to export the group of contacts to excel, so that I can delete the fields that I don't need for this particular project and then do a mail merge between excel and word, in which I can create the labels. But Address Book and excel don't seem to want to play together.

I downloaded Palm Desktop with the hope that I could use it as a conduit, but it won't accept the group v-card either.

I have searched everywhere for hints, but mostly just come up with hints for importing contacts to address book, and not exporting. I hope someone can help!


Thanks!
flyingfishgirl is offline   0 Reply With Quote
Old Dec 13, 2007, 09:43 PM   #2
unknown.exe
macrumors member
 
Join Date: Sep 2007
Location: Somewhere on Earth
Send a message via AIM to unknown.exe
Quote:
Originally Posted by flyingfishgirl View Post
I currently keep all of my contacts in Address Book, and need to create mailing labels from a group of them (I already created and populated the group). If I try to "print labels" from address book, it tries to print a label for every address in the group -- so in cases where a contact has multiple addresses, it wants to print more than one. This process also won't let me edit the labels to modify names, add "Mr. & Mrs." etc.

I want to export the group of contacts to excel, so that I can delete the fields that I don't need for this particular project and then do a mail merge between excel and word, in which I can create the labels. But Address Book and excel don't seem to want to play together.

I downloaded Palm Desktop with the hope that I could use it as a conduit, but it won't accept the group v-card either.

I have searched everywhere for hints, but mostly just come up with hints for importing contacts to address book, and not exporting. I hope someone can help!


Thanks!
Open excel and go to file > inport (i'm pretty sure that's an option on all office apps). Import your address book entries into excel... that's your best advice.
unknown.exe is offline   0 Reply With Quote
Old Dec 13, 2007, 11:50 PM   #3
flyingfishgirl
Thread Starter
macrumors newbie
 
Join Date: Dec 2007
Location: NYC
Quote:
Originally Posted by unknown.exe View Post
Open excel and go to file > inport (i'm pretty sure that's an option on all office apps). Import your address book entries into excel... that's your best advice.
Excel doesn't give you that option. I've tried using the "import"option in Enterouge, but it only seems to want to let me import mail or calendar files, and not contact files. Same for Palm Desktop. I also tried the Address Book to CSV exporter utility, but that didn't work.
flyingfishgirl is offline   0 Reply With Quote
Old Dec 14, 2007, 06:03 AM   #4
iSaint
macrumors 603
 
iSaint's Avatar
 
Join Date: May 2004
Location: South Mississippi y'all, near the water!
Send a message via AIM to iSaint
I'm not going to test it out, but there's an Export option in Address Book that allows you to create an archive. I don't think there's an option to select certain entries to export. I know other database programs such as ACT will do that for you.

Since we only send 80 Christmas cards, and I have 1,200 contacts, I keep a spreadsheet and make changes year to year.

BTW if you do export into a tab delimited file you can import that into Excel with ease.
__________________
Not Applicable
iSaint is offline   0 Reply With Quote
Old Dec 15, 2007, 01:24 AM   #5
tarquin
macrumors newbie
 
Join Date: Dec 2007
Mac Address Book Export

This is easy and I do it all the time:

http://gwenhiver.net/address-book-exporter.html

Download that which will export your address book to a .txt file. Then simply open in Excel and your good to go!

Hope this helps!
tarquin is offline   0 Reply With Quote
Old Aug 20, 2008, 07:24 AM   #6
Macknowit
macrumors newbie
 
Join Date: Aug 2008
Address book

Thank you very much top solve
Macknowit is offline   0 Reply With Quote
Old Sep 4, 2008, 11:02 PM   #7
mackitlad
macrumors newbie
 
Join Date: Sep 2008
Export Address Book to CSV

I haven't tried it yet but looks like there is one more option:
Address Book to CSV Exporter 1.3a
It is available for download from apple site:
http://www.apple.com/downloads/macos...vexporter.html

For review, see the following site:
http://www.versiontracker.com/dyn/mo...&mode=feedback

Last edited by mackitlad; Sep 4, 2008 at 11:16 PM.
mackitlad is offline   0 Reply With Quote
Old Sep 8, 2008, 07:49 PM   #8
mackitlad
macrumors newbie
 
Join Date: Sep 2008
Address Book to CSV Exporter --- not good if you want entries kelp in csv

"Address Book to CSV Exporter 1.3a" tool I mentioned above isn't good if you would like to export contacts to a csv file and preserve it that way because the csv output isn't easy to read in spreadsheet; not sure if it works by splitting the csv to spreadsheet columns based on some separator. The tool download site says that the csv output is good for creating an export csv to later import using gmail's import functionality; however i did not try that out.
Instead, I started using gmail to store all my contact and its csv output goes good in spreadsheet.
mackitlad is offline   0 Reply With Quote
Old Jun 3, 2010, 07:41 PM   #9
MelRichBan
macrumors newbie
 
Join Date: Jun 2010
Export Vcards into Excel from Address Book

I searched and searched, I downloaded shareware solutions, I tried what Apple recommended on their own website, and finally found the easiest way to overcome this problem by thinking like a MAC user, not a PC user.

Remember that Excel is made by MICROSOFT. So, use your MAC software to create what you need (for me, I needed an Excel file of my contacts as the service I use for email marketing requires this for uploading):

1. Open Mac's Numbers software program.
2. Open Address Book, and click on the group or selection of contacts you need exported.
3. Drag them into an empty spreadsheet into Numbers.
4. If needed, re-save your new Numbers file while in Excel.

Seriously, it is that simple. NO export, NO import, NO headaches.

NOTE TO SELF: Next time, don't think like a PC user -- think INTUITIVELY.
MelRichBan is offline   1 Reply With Quote
Old Jun 26, 2010, 10:15 AM   #10
cavenewt
macrumors newbie
 
Join Date: Oct 2007
Numbers worked great!

MelRichBan:

GREAT suggestion! Highlighting names in AB and dragging them straight to a Numbers spreadsheet works like a charm. And I was looking for a third-party export tool. Fah!
cavenewt is offline   1 Reply With Quote
Old Jun 29, 2010, 11:14 AM   #11
andydufraine
macrumors newbie
 
Join Date: Jun 2010
a little help

sounds easy, when I tried it, I highlighted the contacts (turned them blue) tried to just move them over to an empty Numbers sheet and they wouldn't take - do I need to format the numbers page in any particular way or point the mouse to a specific field. thanks from a newbie http://cdn.macrumors.com/vb/images/smilies/smile.gif
andydufraine is offline   0 Reply With Quote
Old Aug 4, 2010, 09:26 AM   #12
dreamwhopper
macrumors newbie
 
Join Date: Mar 2005
Here is another option!

I use a great system for sending out cards, postcards and even gifts! Check it out.... www.ikathie.com

Let me know if you have any questions!
dreamwhopper is offline   0 Reply With Quote
Old Aug 7, 2010, 03:53 PM   #13
Chadest
macrumors newbie
 
Join Date: Aug 2010
Nice, but not quite there

MelRichBan's solutions is certainly the easiest and most 'mac-like'.
However it didn't quite work for me. When dragging a card from Address Book (v5.0.2 on OSX 10.6.4) into Numbers 09 (v2.0.3), all I got was Last Name, First Name, mobile phone, and email address.

Does anyone know how to tweak the process to get more data? Such as the address?
Thanks
Chadest is offline   0 Reply With Quote
Old Aug 11, 2010, 10:52 AM   #14
vdeg
macrumors newbie
 
Join Date: Aug 2010
Quote:
Originally Posted by Chadest View Post
MelRichBan's solutions is certainly the easiest and most 'mac-like'.
However it didn't quite work for me. When dragging a card from Address Book (v5.0.2 on OSX 10.6.4) into Numbers 09 (v2.0.3), all I got was Last Name, First Name, mobile phone, and email address.

Does anyone know how to tweak the process to get more data? Such as the address?
Thanks
You just need to unhide hidden columns - ALL address book fields are there (more than one needs)
vdeg is offline   0 Reply With Quote
Old Sep 30, 2010, 10:06 AM   #15
afh163
macrumors newbie
 
Join Date: Sep 2010
Quote:
Originally Posted by MelRichBan View Post
I searched and searched, I downloaded shareware solutions, I tried what Apple recommended on their own website, and finally found the easiest way to overcome this problem by thinking like a MAC user, not a PC user.

Remember that Excel is made by MICROSOFT. So, use your MAC software to create what you need (for me, I needed an Excel file of my contacts as the service I use for email marketing requires this for uploading):

1. Open Mac's Numbers software program.
2. Open Address Book, and click on the group or selection of contacts you need exported.
3. Drag them into an empty spreadsheet into Numbers.
4. If needed, re-save your new Numbers file while in Excel.

Seriously, it is that simple. NO export, NO import, NO headaches.

NOTE TO SELF: Next time, don't think like a PC user -- think INTUITIVELY.
I tried doing this and it doesn't let me drop into Numbers. The image that I'm dragging over just flies back into Address Book. Any idea why?
afh163 is offline   0 Reply With Quote
Old Sep 30, 2010, 10:15 AM   #16
Mal
macrumors 603
 
Mal's Avatar
 
Join Date: Jan 2002
Location: Orlando
Quote:
Originally Posted by afh163 View Post
I tried doing this and it doesn't let me drop into Numbers. The image that I'm dragging over just flies back into Address Book. Any idea why?
Make sure you're dropping them directly onto the spreadsheet cells, which will highlight in blue to indicate they are the destination.

jW
__________________
The Bearded Nerd
13" MacBook Pro; 64GB iPod touch
"It's a real burn, being right so often."
NoiseTrade.com/Walker
Mal is offline   0 Reply With Quote
Old Sep 30, 2010, 10:19 AM   #17
afh163
macrumors newbie
 
Join Date: Sep 2010
I highlight the cell in Numbers, then go to AB and highlight the contacts (tried doing all at once then opted to try just one contact to see if it worked). No luck. As I drag from AB to Numbers, Numbers is in the background and it doesnt register that I want to drop....

* I figured it out. I had to select contacts under "on my mac" as opposed to the list I was trying to use.

Last edited by afh163; Sep 30, 2010 at 10:42 AM.
afh163 is offline   0 Reply With Quote
Old Sep 30, 2010, 10:44 AM   #18
Mal
macrumors 603
 
Mal's Avatar
 
Join Date: Jan 2002
Location: Orlando
Ok, so just tested this. When I just dropped onto a blank spreadsheet, it wanted to create a new table with the information. When I edited the column headers to First Name, Last Name, etc, then it highlighted in blue and let me drop directly onto the table without creating a new one. Both ways, however, it did pull the information from Address Book, and didn't just snap back.


afh163, glad you figured it out, that wasn't the solution I would have suggested, so glad you saved me the trouble of being wrong, too.

jW
__________________
The Bearded Nerd
13" MacBook Pro; 64GB iPod touch
"It's a real burn, being right so often."
NoiseTrade.com/Walker
Mal is offline   0 Reply With Quote
Old Nov 3, 2010, 09:56 AM   #19
Celticfaere
macrumors newbie
 
Join Date: Mar 2004
Location: Florida
Send a message via AIM to Celticfaere
export to numbers you are brilliant!

This is brilliant!!! KISS--keep it simple stupid we forget what we love about mac sometimes.

Remember that Excel is made by MICROSOFT. So, use your MAC software to create what you need (for me, I needed an Excel file of my contacts as the service I use for email marketing requires this for uploading):

1. Open Mac's Numbers software program.
2. Open Address Book, and click on the group or selection of contacts you need exported.
3. Drag them into an empty spreadsheet into Numbers.
4. If needed, re-save your new Numbers file while in Excel.

Seriously, it is that simple. NO export, NO import, NO headaches.

NOTE TO SELF: Next time, don't think like a PC user -- think INTUITIVELY.[/QUOTE]
Celticfaere is offline   0 Reply With Quote
Old Dec 16, 2010, 02:30 PM   #20
LABachlr
macrumors newbie
 
Join Date: Jan 2008
Quote:
Originally Posted by vdeg View Post
You just need to unhide hidden columns - ALL address book fields are there (more than one needs)
How do you do that?

TIA
LABachlr is offline   0 Reply With Quote
Old Dec 19, 2010, 12:50 PM   #21
yennta
macrumors newbie
 
Join Date: Jul 2008
Quote:
Originally Posted by mal View Post
make sure you're dropping them directly onto the spreadsheet cells, which will highlight in blue to indicate they are the destination.

Jw
this absolutely works! Terrific.
yennta is offline   0 Reply With Quote
Old Dec 22, 2010, 11:54 AM   #22
gmaniPhone
macrumors newbie
 
Join Date: Apr 2010
unhide columns

Quote:
Originally Posted by LABachlr View Post
How do you do that?

TIA
In Numbers, select the Table, then under Table menu, UNHIDE all columns.

voila!
gmaniPhone is offline   0 Reply With Quote
Old Jan 4, 2011, 02:59 PM   #23
rocklifter
macrumors newbie
 
Join Date: Mar 2008
Many Thanks

Worked like a charm. Thanks for the neat trick! You've make me look good for the boss.



Quote:
Originally Posted by MelRichBan View Post
I searched and searched, I downloaded shareware solutions, I tried what Apple recommended on their own website, and finally found the easiest way to overcome this problem by thinking like a MAC user, not a PC user.

Remember that Excel is made by MICROSOFT. So, use your MAC software to create what you need (for me, I needed an Excel file of my contacts as the service I use for email marketing requires this for uploading):

1. Open Mac's Numbers software program.
2. Open Address Book, and click on the group or selection of contacts you need exported.
3. Drag them into an empty spreadsheet into Numbers.
4. If needed, re-save your new Numbers file while in Excel.

Seriously, it is that simple. NO export, NO import, NO headaches.

NOTE TO SELF: Next time, don't think like a PC user -- think INTUITIVELY.
rocklifter is offline   0 Reply With Quote
Old Jan 4, 2011, 05:05 PM   #24
montycat
macrumors 6502
 
Join Date: Mar 2007
Location: Florida
Quote:
Originally Posted by MelRichBan View Post
I searched and searched, I downloaded shareware solutions, I tried what Apple recommended on their own website, and finally found the easiest way to overcome this problem by thinking like a MAC user, not a PC user.

Remember that Excel is made by MICROSOFT. So, use your MAC software to create what you need (for me, I needed an Excel file of my contacts as the service I use for email marketing requires this for uploading):

1. Open Mac's Numbers software program.
2. Open Address Book, and click on the group or selection of contacts you need exported.
3. Drag them into an empty spreadsheet into Numbers.
4. If needed, re-save your new Numbers file while in Excel.

Seriously, it is that simple. NO export, NO import, NO headaches.

NOTE TO SELF: Next time, don't think like a PC user -- think INTUITIVELY.
Thanks for the info
__________________
iMac 20-inch 2.0GHz 3GB memory Core 2 Duo 320GB
MacBookPro 13" 2.26 GHz 2GB memory 320GB 80GB iPod Classic iPhone 3GS 16GB
16GB iPod touch Magic Trackpad
montycat is offline   0 Reply With Quote
Old Jan 28, 2011, 09:03 PM   #25
GRaysman
macrumors newbie
 
Join Date: Jan 2011
This was the BEST advice! I created a Christmas Card List of 65 names within a half hour, including formatting the Numbers page, colors, fonts, etc. Thank you so much!



Quote:
Originally Posted by MelRichBan View Post
I searched and searched, I downloaded shareware solutions, I tried what Apple recommended on their own website, and finally found the easiest way to overcome this problem by thinking like a MAC user, not a PC user.

Remember that Excel is made by MICROSOFT. So, use your MAC software to create what you need (for me, I needed an Excel file of my contacts as the service I use for email marketing requires this for uploading):

1. Open Mac's Numbers software program.
2. Open Address Book, and click on the group or selection of contacts you need exported.
3. Drag them into an empty spreadsheet into Numbers.
4. If needed, re-save your new Numbers file while in Excel.

Seriously, it is that simple. NO export, NO import, NO headaches.

NOTE TO SELF: Next time, don't think like a PC user -- think INTUITIVELY.
GRaysman is offline   1 Reply With Quote

Reply
MacRumors Forums > Apple Systems and Services > OS X

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
thread Thread Starter Forum Replies Last Post
Mail seems to be adding contacts without my permission to Address Book. WTF? iRock1 Mac OS X 10.7 Lion 6 Nov 8, 2011 12:44 PM
Just deleted all of my address book contacts?? peanutismint OS X 4 Jul 4, 2011 05:44 PM
Export address book contacts to SIM card? carrollf OS X 2 Feb 20, 2010 10:18 AM
Export Address Book Contacts for Gmail dilbert4life Mac Applications and Mac App Store 0 Nov 10, 2008 08:32 AM
CompuServe (OS X) Exporting Address Book Contacts LimeiBook86 Mac Basics and Help 2 Nov 6, 2006 09:35 PM


All times are GMT -5. The time now is 06:52 AM.

Mac Rumors | Mac | iPhone | iPhone Game Reviews | iPhone Apps

Mobile Version | Fixed | Fluid | Fluid HD
Copyright 2002-2013, MacRumors.com, LLC