export a group of contacts to numbers

How can I export a group of individual contacts to numbers spreadsheet? What I want to accomplish is to create a spreadsheet from 13 different individuals from my contacts. Or do the same thing using a smart group that I created using those names.

MacBook Pro 13″, macOS 11.0

Posted on Dec 12, 2020 4:33 PM

Reply
Question marked as Top-ranking reply

Posted on Dec 12, 2020 9:35 PM

  1. Open the Numbers app with a fresh new table ready or a blank area on a sheet
  2. Open the Contacts app
  3. Select the contacts you want (not a group, need to select the actual contacts)
  4. Drag and drop them on the Numbers table or in the blank area on a sheet.


If you want them in the same table, you will want to drag and drop them all at the same time. The columns are based on the information in the contacts and they are different for different contacts. For instance, one contact might have a "main" phone number and another might have "home" phone number. If drag and dropped separately they will create different columns., the data won't align.


There have been recent reports that doing this for "large" numbers of contacts (like in the 100+ range) can crash the recent version of Numbers. You would think you could simply do large numbers in smaller batches, which works in general, but you are likely to get a slightly different mix of columns each time.


2 replies
Question marked as Top-ranking reply

Dec 12, 2020 9:35 PM in response to lowell214

  1. Open the Numbers app with a fresh new table ready or a blank area on a sheet
  2. Open the Contacts app
  3. Select the contacts you want (not a group, need to select the actual contacts)
  4. Drag and drop them on the Numbers table or in the blank area on a sheet.


If you want them in the same table, you will want to drag and drop them all at the same time. The columns are based on the information in the contacts and they are different for different contacts. For instance, one contact might have a "main" phone number and another might have "home" phone number. If drag and dropped separately they will create different columns., the data won't align.


There have been recent reports that doing this for "large" numbers of contacts (like in the 100+ range) can crash the recent version of Numbers. You would think you could simply do large numbers in smaller batches, which works in general, but you are likely to get a slightly different mix of columns each time.


This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

export a group of contacts to numbers

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.