Got a tip for us? Let us know
|
|
#1 |
|
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! |
|
|
|
0
|
|
|
#2 | |
|
Quote:
|
||
|
|
0
|
|
|
#3 |
|
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.
|
|
|
|
0
|
|
|
#4 |
|
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
|
|
|
|
0
|
|
|
#5 |
|
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! |
|
|
|
0
|
|
|
#6 |
|
Address book
Thank you very much top solve
|
|
|
|
0
|
|
|
#7 |
|
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 5, 2008 at 12:16 AM. |
|
|
|
0
|
|
|
#8 |
|
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. |
|
|
|
0
|
|
|
#9 |
|
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. |
|
|
|
1
|
|
|
#10 |
|
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! |
|
|
|
1
|
|
|
#11 |
|
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
|
|
|
|
0
|
|
|
#12 |
|
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! |
|
|
|
0
|
|
|
#13 |
|
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 |
|
|
|
0
|
|
|
#14 | |
|
Quote:
|
||
|
|
0
|
|
|
#15 | |
|
Quote:
|
||
|
|
0
|
|
|
#16 | |
|
Quote:
jW
__________________
The Bearded Nerd 13" MacBook Pro; 64GB iPod touch "It's a real burn, being right so often." NoiseTrade.com/Walker |
||
|
|
0
|
|
|
#17 |
|
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 11:42 AM. |
|
|
|
0
|
|
|
#18 |
|
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 |
|
|
|
0
|
|
|
#19 |
|
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] |
|
|
|
0
|
|
|
#20 |
|
|
0
|
|
|
#21 |
|
|
0
|
|
|
#22 |
|
unhide columns
|
|
|
|
0
|
|
|
#23 | |
|
Many Thanks
Worked like a charm. Thanks for the neat trick! You've make me look good for the boss.
Quote:
|
||
|
|
0
|
|
|
#24 | |
|
Quote:
__________________
iMac 20-inch 2.0GHz 3GB memory Core 2 Duo 320GB MacBookPro 13" 2.26 GHz 2GB memory 320GB 16GB iPod touch |
||
|
|
0
|
|
|
#25 | |
|
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:
|
||
|
|
1
|
![]() |
|
«
Previous Thread
|
Next Thread
»
Similar Threads
|
||||
| thread | Thread Starter | Forum | Replies | Last Post |
| All Contacts images not showing up in address book | GreenApple29 | OS X Mavericks (10.9) | 0 | Jan 13, 2014 11:48 AM |
| Facetime contacts do not match Address Book | aoitsukinosuke | Mac Applications and Mac App Store | 0 | Mar 10, 2013 03:19 AM |
| Export, Import Yahoo Address Book | chattahoochee | MacBook | 1 | Feb 21, 2013 06:31 PM |
| Facebook contacts in address book | matteoit | OS X 10.8 Mountain Lion | 1 | Dec 23, 2012 11:06 AM |
| Outlook to Address Book Contacts | Tiki35 | Mac Basics and Help | 0 | Jun 19, 2012 10:53 PM |
|
All times are GMT -5. The time now is 08:34 AM.








Linear Mode
