Your contacts as a table, one value to a cell
File ▸ Open My Contacts reads the address book on your Mac; File ▸ Open a Contacts File reads a
.vcf exported from anywhere — vCard 2.1, 3.0 and 4.0. Either way you get one row per contact and one
value per cell: first name and last name in their own columns, a mobile number under Mobile, a work number
under Work phone, and the street, postcode and city of each address in columns of their own.
A column only appears when some contact has something for it, so a file of names and phone numbers is not thirty columns wide. Somebody with two mobile numbers gives the table a Mobile 2. Labels people typed themselves — Holiday home — are kept as they wrote them.
Then send them where they need to go
Export the table as CSV or Excel for a mail merge, a CRM import or a newsletter tool; filter it to one city; find duplicates by email address; or check it with column rules before it goes anywhere.
