Go Back   MacRumors Forums > Apple Systems and Services > OS X

Reply
 
Thread Tools Search this Thread Display Modes
Old Jan 30, 2011, 02:52 AM   #26
majdi
macrumors newbie
 
Join Date: Jan 2011
Location: Dammam, Saudi Arabia
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.
Now, this is what I call integration & ease of use.
majdi is offline   0 Reply With Quote
Old Feb 21, 2011, 06:51 PM   #27
konieczn
macrumors newbie
 
Join Date: Jun 2010
Is there anyway to reverse this process? I have a numbers spreadsheet with lot's of information in it (names, addresses, email addresses, phone numbers, etc), is there a way to import that information into my contacts on my iMac? I appreciate any help I may receive.
konieczn is offline   0 Reply With Quote
Old Mar 4, 2011, 08:02 PM   #28
tillamook
macrumors newbie
 
Join Date: Jun 2009
Addresses didn't import

Followed the advice to drag and drop the contacts onto a blank Numbers spreadsheet. Seemed to work great until I noticed that the addresses weren't copied onto the spreadsheet. Names, phones, & emails came thru fine.
tillamook is offline   0 Reply With Quote
Old May 5, 2011, 12:15 PM   #29
DavidCaronDC
macrumors newbie
 
Join Date: May 2011
Thank You!

I have searched all over the place to learn how to do this. Numbers and Apple Rock!





David Caron
David Caron Design
http://www.davidcarondesign.com/webs...gn-company.php
DavidCaronDC is offline   0 Reply With Quote
Old Aug 4, 2011, 09:53 AM   #30
berylrb
macrumors newbie
 
Join Date: Jun 2008
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.
Oh Man, I'm back in MacHeaven thanks MelRichBan. BTW my ultimate aim is to get these contacts emails into Constant Contact!
berylrb is offline   0 Reply With Quote
Old Aug 22, 2011, 09:50 PM   #31
amarsden
macrumors newbie
 
Join Date: Aug 2011
Thank you for a great post!

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 am still un-learning the PC mindset. Thank yo so much for this simple solution - worked like a charm - and saved me so much time!!!

You rock!
amarsden is offline   0 Reply With Quote
Old Sep 6, 2011, 05:50 PM   #32
Nelle Flanders
macrumors newbie
 
Join Date: Sep 2011
Kudos! This is a perfectly brilliant solution!

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.
Thank you so very much for sharing this simple solution! I'm merging and purging multiple corporate address books and this will literally save me days.
Nelle Flanders is offline   0 Reply With Quote
Old Dec 22, 2011, 04:03 PM   #33
dkornf
macrumors newbie
 
Join Date: Dec 2011
Help get this to work?

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 still can't get this to work. I highlight some names in Address Book and drag them to an open empty file in Numbers, but a circle with a line through it pops up and then when I release the mouse, the names just fly back to Address Book. What else do I need to do?

Thanks so much!
dkornf is offline   0 Reply With Quote
Old Jan 19, 2012, 12:04 AM   #34
isellhouses
macrumors newbie
 
Join Date: Jan 2012
One Small Problem

This works really well except for one thing I can't seem to figure out. I've unhidden all columns and I still can't get numbers that I have labeled as "iPhone" in address book. I've tried making a custom column in numbers called iPhone, but that still doesn't work. If I go back into address book and change the "iPhone" label to "mobile" then the number shows up on the spreadsheet. I don't really want to go through all 500 contacts and do this. Any help out there???
isellhouses is offline   0 Reply With Quote
Old Feb 4, 2012, 01:07 PM   #35
raulwrojas
macrumors newbie
 
Join Date: Feb 2012
Quote:
Originally Posted by dkornf View Post
I still can't get this to work. I highlight some names in Address Book and drag them to an open empty file in Numbers, but a circle with a line through it pops up and then when I release the mouse, the names just fly back to Address Book. What else do I need to do?

Thanks so much!
Hola! So, I'm hoping that you can help me out too. I don't have Numbers and would like to export from my address book to Excel or another file (I think a txt file would work) where I can separate the first name, last name and email address. Ultimately, I would like to import them into MailChimp.

THANKS IN ADVANCE!

~r
raulwrojas is offline   0 Reply With Quote
Old Feb 28, 2012, 11:06 PM   #36
danialmoore0302
macrumors newbie
 
Join Date: Feb 2012
Sure... but you can also edit it in Entourage once you've got the info in there. Why not just organize your contacts in Entourage?

...

I'm not sure that Excel can directly import data from the Office Address Book... At least, I haven't done it and I just checked and see no command for that.

Entourage will export a tab-delineated text file that Excel can import. You can then make your edits, save and use Word to do the mail-merge as it would from any other Excel worksheet.
__________________
Top universities in america
danialmoore0302 is offline   0 Reply With Quote
Old Mar 10, 2012, 04:00 PM   #37
Haidar
macrumors newbie
 
Join Date: Mar 2012
EXPORT Address Book contacts to Excel?

Hello ! I have same problem. I want to get all my adress book contacts into an excel fil. I really dont know what is NUMBERS SOFTWARE IS !!! What is this and how to find it in my macbook ?

Thanx in advance

Last edited by Haidar; Mar 10, 2012 at 04:08 PM.
Haidar is offline   0 Reply With Quote
Old Mar 10, 2012, 04:11 PM   #38
Haidar
macrumors newbie
 
Join Date: Mar 2012
Quote:
Originally Posted by tarquin View Post
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!
Hello , I have same problem and I did downloaded this program ABE but it doesnt open ! Whenever I open it some message appear says POWER PC IS NO LONGER SUPPORTED! Pls if u know why just tell me.

Thanx in advance.
Haidar is offline   0 Reply With Quote
Old Apr 22, 2012, 11:49 AM   #39
nolacarey
macrumors newbie
 
Join Date: Apr 2012
worked like a charm!!

you da best! i did have to go to 'table>show hidden columns' to display addresses, etc., and voilá, i could export to an excel file. great tip!!!
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.
nolacarey is offline   0 Reply With Quote
Old May 6, 2012, 11:58 AM   #40
steppy52
macrumors newbie
 
Join Date: May 2012
worked! now what about...

I've added some custom fields in my Apple Address Book. When I drop contacts onto/into Numbers those fields are not coming along with the others.

I've unhidden columns.

ideas? advice? commiseration?

thanx.
steppy52 is offline   0 Reply With Quote
Old Jun 3, 2012, 12:26 PM   #41
braintoniq
macrumors newbie
 
Join Date: Jan 2008
Location: Boulder, CO
Send a message via AIM to braintoniq
Well, damn. That was the coolest trick I've learned in at least a year. Many thanks, MelRichBan.

For posterity, this works as of 6-3-12, with Lion and latest versions of Numbers and 10.7.4.


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.
braintoniq is offline   0 Reply With Quote
Old Jun 3, 2012, 06:29 PM   #42
BradC74
macrumors newbie
 
Join Date: Jun 2012
Still issues with dragging to numbers

Great suggestion in dragging from Address Book to Numbers.

However, it only seems to work from the 'On My Mac' section of the Address Book.

When trying to drag from 'Public Folders' however, it won't work.

Anybody have any idea why? Or how to fix? Doesn't make any sense to me.

Thanks.
BradC74 is offline   0 Reply With Quote
Old Jun 3, 2012, 07:53 PM   #43
HenryAZ
macrumors regular
 
Join Date: Jan 2010
Location: South Congress AZ
One other method is to sync your Address Book contacts with GMail contacts. GMail lets you export a .csv file from your contacts, and the .csv will import into lots of things.
HenryAZ is offline   0 Reply With Quote
Old Jun 21, 2012, 10:33 AM   #44
karolsky2005
macrumors newbie
 
Join Date: Nov 2008
Location: Italy
to a great Macuser

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 LOVE YOU, MelRichBan, you're phantastic! I had transfer only 1586 contact...
How old are you? I need to kiss you!

Great man!
karolsky2005 is offline   0 Reply With Quote
Old Nov 3, 2012, 10:28 PM   #45
Deonne
macrumors newbie
 
Join Date: Nov 2012
Thank you!!!

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 have wanted to do this EXACT process quite a few times in the past, looked for good options, ultimately decided the time I spent searching would've been better spent just doing the task manually. THIS IS BEAUTIFUL!!!!! Love the solution so much that I created a MacRumors account to log in and tell you THANKS!
Deonne is offline   0 Reply With Quote
Old Nov 15, 2012, 05:50 PM   #46
steppy52
macrumors newbie
 
Join Date: May 2012
Terrific....but custom fields?

An outstanding tip and useful method.

I too have custom fields that do NOT come through to Numbers.

All the other fields are there. Can anyone help out on this?

thnx!
steppy52 is offline   0 Reply With Quote
Old Nov 19, 2012, 05:06 PM   #47
bnewcol
macrumors newbie
 
Join Date: May 2011
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.
Where is Numbers? Does this come automatically on Macs as I am not finding it on ours. Is it a program you have to buy?
bnewcol is offline   0 Reply With Quote
Old Nov 21, 2013, 06:19 AM   #48
v3nt
macrumors newbie
 
Join Date: Apr 2010
no longer works?

Doesn't seem to work with Mavericks and new numbers and contacts. Why is this so complicated!
v3nt is offline   0 Reply With Quote
Old Dec 10, 2013, 03:11 PM   #49
kayt76
macrumors newbie
 
Join Date: Dec 2013
Location: NC
Can't Find Numbers Either ??!

[QUOTE=v3nt;18401869]Doesn't seem to work with Mavericks and new numbers and contacts. Why is this so complicated!
__________________
17" MacBook Pro Retina Display; iPhone 5
kayt76 is offline   0 Reply With Quote

Reply
MacRumors Forums > Apple Systems and Services > OS X

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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 10:48 AM
Facetime contacts do not match Address Book aoitsukinosuke Mac Applications and Mac App Store 0 Mar 10, 2013 01:19 AM
Export, Import Yahoo Address Book chattahoochee MacBook 1 Feb 21, 2013 05:31 PM
Facebook contacts in address book matteoit OS X 10.8 Mountain Lion 1 Dec 23, 2012 10:06 AM
Outlook to Address Book Contacts Tiki35 Mac Basics and Help 0 Jun 19, 2012 09:53 PM

Forum Jump

All times are GMT -5. The time now is 01:22 AM.

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

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