Numbers ‘09: Mapping Column Names to Address Book Field Names

This article has been archived and is no longer updated by Apple.
Mapping Column Names to Address Book Field Names

The following table summarizes the Address Book fields that Numbers supports. The synonyms are alternative names you can use to add a particular Address Book field value.

Address Book field names
Field name synonyms


Name title, Name prefix

Last name

Last, Surname

First name

First, Given name, Forename


Name suffix, Professional suffix, Academic suffix


Maiden name

Job title


Job department


Phone (first available number)

Main phone

Work phone

Home phone


Mobile phone, Mobile telephone, Cell phone, Cell telephone, Cellular, Cellular phone, Cellular telephone

Home fax

Work fax



Other phone

Email (first available address)

Email address

Work email

Home email

Other email

URL (first available URL)

Work URL

Home URL

Other URL


AIM (first available address)

IM, IM handle, IM name, IM address, Chat, Chat handle, Chat name, Chat address

Work AIM

Work IM, Work IM handle, Work IM name, Work IM address, Work chat handle, Work chat name, Work chat address

Home AIM

Home IM, Home IM handle, Home IM name, Home IM address, Home chat, Home chat handle, Home chat name, Home chat address

Other AIM

Other IM, Other IM handle, Other IM name, Other IM address, Other chat, Other chat handle, Other chat name, Other chat address


Work Yahoo

Home Yahoo

Other Yahoo


Street address (first available street address)


City (first available city)


State (first available state)


Zip code, Postal code

Country (first available country)

Work address

Work street address

Work street, Work address

Work city

Work town

Work state

Work zip

Work zip code, Work postal code

Work country

Home address

Home street address

Home street, Home address

Home city

Home town

Home state

Home zip

Home zip code, Home postal code

Home country

Other address

Other street address

Other street, Other address

Other city

Other town

Other state

Other zip

Other zip code, Other postal code

Other country



Published Date: Sep 4, 2015