How to turn numbers spreadsheet into VCard? June 2016

I haven't tried this but Numbers File menu Export has an option to export to a CSV file.

According to Help in the current Contacts app, it will import from a CSV file. Once the contacts are in the Contacts app on your Mac they will sync to your iPhone if you have the following turned on:

Mac: Apple menu > System Preferences > iCloud

iPhone: Settings > iCloud > Contacts

See the information below from Contacts Help:

If you’re importing a tab-delimited or CSV file, make sure it’s formatted correctly using a text editor such as TextEdit:

• Remove any line breaks within a contact’s information.
• Make sure that fields in a tab-delimited file are separated by a tab, instead of by another character. Don’t include spaces before or after tabs.
• Make sure that fields in a CSV file are separated by a comma, instead of by another character. Don’t include spaces before or after commas.
• Make sure all addresses have the same number of fields. Add empty fields as needed.

1. In Contacts, choose File > Import, select the file, change the encoding if necessary, then click Open.
2. If you’re importing a text file, review the field labels.
• If the first card contains headers, make sure the headers are correctly labeled or marked “Do not import.” Any changes you make to this card are made to all cards in the file. To not import the headers card, select “Ignore first card.”
• To change a label, click the arrows next to the label and choose a new label. If you don’t want to import a field, choose “Do not import.”

If your goal is to just get names and phone numbers from Numbers into Contacts you don't need to mess with CSV and vCard. Often a short script will be quicker.

For example, say you have your Numbers table like this, three columns, with nothing in the Header Row:

... Then the script below will add these to Numbers. (No scripting knowledge needed to run).

1. Copy-paste script below into Script Editor (in Applications > Utilities menu).
2. Click anywhere in the Numbers table with the names and numbers.
3. Click the triangle 'run' button in Script Editor.

First test with a few to make sure this is working as you want.

If your table is set up differently, for example with first and last names together in the same cell, then the script would need some small changes. If you also have address information you want to add to Contacts, that is also quite easy to do.

SG

tell application "Numbers"

tell front document's active sheet

tell (first table whose selection range's class is range)

set vv to (rows whose first cell's value is not missing value)'s cells's value

end tell

end tell

end tell

repeat with i in vv's items

my addToContacts(i's first item, i's second item, i's third item)

end repeat

to addToContacts(firstName, lastName, phoneNum)

tell application "Contacts"

set thePerson to ¬

makenewpersonwith properties {first name:firstName, last name:lastName}

makenewphoneat end of thePerson'sphoneswith properties {value:phoneNum}

save

end tell

end addToContacts