Export contacts to a CSV file

Question

Level 1

9 points

Export contacts to a CSV file

I'm trying to export my nearly 4,000 contacts from my Mac to a CRM system. Seems like the best intermediary is exporting from Apple Contacts to a CSV file. I've read the advice online that you can drag and drop from Contacts to Numbers, and when I tested with a handful of contacts, it seemed to work great. But when I try to drag and drop all 4,000 of my contacts, I get the spinning wheel for a minute or so, and then I have just a blank Numbers template. So it seems like it can't handle that many contacts. Is there another way to do this?

Sonoma 14.6.1

Numbers 14.1

Posted on Aug 19, 2024 4:34 PM

Reply

Answer 1

SGIII

Level 8

36,134 points

Aug 20, 2024 5:29 AM in response to Fly Line

Fly Line wrote:

Repeating doesn't work, unfortunately. I have do a couple hundred at once, no problem. But then if I repeat, the second batch overlaps onto the first.

Not sure I understand why there would be overlap if you make sure to drag and drop each batch to a different place in Numbers, then put it all together.

SG

Reply

Answer 2

Fly Line Author

Level 1

9 points

Aug 20, 2024 8:40 AM in response to SGIII

I did specifically make it a point to add extra lines at the bottom of the sheet and then drag and drop the next batch there. It worked on my second batch, but then when I tried a third batch, Numbers refused it.

Is there any other way to export Contacts to another format besides going through Numbers?

Reply

Answer 3

SGIII

Level 8

36,134 points

Aug 20, 2024 8:46 AM in response to Fly Line

There may be other ways, but going through Numbers is probably the easiest.

If you can drag and drop twice, no reason you can't drag and drop three times, right?

Just a matter of getting used to the process and working out the little kinks, such making sure you're dropping onto empty cells.

SG

Reply

Answer 4

SGIII

Level 8

36,134 points

Aug 19, 2024 6:33 PM in response to Fly Line

4,000 may be too many to do all at once.

Have you tried selecting a smaller number? Then repeat.

SG

Reply

Answer 5

Fly Line Author

Level 1

9 points

Aug 19, 2024 10:11 PM in response to SGIII

Repeating doesn't work, unfortunately. I have do a couple hundred at once, no problem. But then if I repeat, the second batch overlaps onto the first.

Reply