Skip navigation

exporting contacts to an numbers spreadsheet

1466 Views 6 Replies Latest reply: Dec 3, 2013 4:15 PM by DaveTheDreaded RSS
Greg Vrchoticky Level 3 Level 3 (615 points)
Currently Being Moderated
Jun 22, 2013 8:16 AM

How do I export a contact group to numbers '09?

Mac mini, OS X Mountain Lion (10.8.3), 2.3 ghz i7/4 gb of RAM
  • Barney-15E Level 7 Level 7 (33,305 points)
    Currently Being Moderated
    Jun 22, 2013 8:41 AM (in response to Greg Vrchoticky)

    Just drag the group into a Numbers document. It will only bring in basic info.

     

    If you want more info, you can create an Automator Workflow or Service which will export the contacts to a tab-delimited file which can be opened with Numbers.

    Screen Shot 2013-06-22 at 10.36.11 AM.png

    You must select all the indivdual contacts you want to include, so for a group, select the group, then select a contact, then cmd-a to select all.

    The first action gets the selected contacts.

    The second action gets the information you specify. Note that it is set for spreadsheet format.

    The third action copies it all to the clipboard.

     

    Paste into a Numbers Spreadsheet.

     

    Note that there are various options on how to get the contacts. Using the selection is the most convenient as you can get any set you want.

     

    An Automator Service will show up in the Services contextual menu, Services menu on the Application Menu, and can have a keyboard shortcut set. For a Service, it can get what you have selected, but I don't know of a way to get the contacts, so just set it to No Input in Contacts. The "Get Selected Contact Items" action will get the necessary items. You can set the shortcut in the Keyboard System preferences.

     

    A Workflow can be run by double-clicking. It doesn't have an input like the Service.

    If this is just a one-time thing, use a workflow and you don't even have to save it. Just run it and don't save it.

  • Topher Kessler Level 6 Level 6 (9,305 points)
    Currently Being Moderated
    Jun 22, 2013 8:50 AM (in response to Greg Vrchoticky)

    You will need to use a program that can import contact information, and I don't believe Numbers will do this. The Contacts program can only output as vCards or as a PDF listing, but the layout of this prevents it from being copied into a spreadsheet easily.

     

    If you simply need a list, then perhaps the Contacts PDF option will work for you. To do this, select your group and then choose "Export as PDF" from the File menu, and you should have a formatted listing of the group's contact information.

  • Topher Kessler Level 6 Level 6 (9,305 points)
    Currently Being Moderated
    Jun 22, 2013 8:54 AM (in response to Barney-15E)

    Hey, thats a good tip!

  • DaveTheDreaded Calculating status...
    Currently Being Moderated
    Dec 3, 2013 7:20 AM (in response to Barney-15E)

    When I drag a group from Contacts to Numbers, absolutley nothing happens. When I drag just one contact from a group into a field on a spreadsheet, again nothing happens. Are you sure this is how to get basic info into a spreadsheet in Numbers?? I tried using Automator Workflow but not sure if I chose the correct instructions! Any further help would be invaluable.

  • Barney-15E Level 7 Level 7 (33,305 points)

    It doesn't appear to work in the new version of Numbers, only the old one.

     

    The instructions for Automator is in the screen shot above.

  • DaveTheDreaded Level 1 Level 1 (0 points)
    Currently Being Moderated
    Dec 3, 2013 4:15 PM (in response to Barney-15E)

    Thanks Barney, I somehow managed to get the Automator working. Not sure what I was doing wrong, but kept at it following your screen shots. A big help!

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.