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

Prefix

Name title, Name prefix

Last name

Last, Surname

First name

First, Given name, Forename

Suffix

Name suffix, Professional suffix, Academic suffix

Nickname

Maiden name

Job title

Department

Job department

Company

Phone (first available number)

Main phone

Work phone

Home phone

Mobile

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

Home fax

Work fax

Pager

Beeper

Other phone

Email (first available address)

Email address

Work email

Home email

Other email

URL (first available URL)

Work URL

Home URL

Other URL

Birthday

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

Yahoo

Work Yahoo

Home Yahoo

Other Yahoo

Address

Street address (first available street address)

Street

City (first available city)

Town

State (first available state)

Zip

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

Note

Notes

Published Date: Sep 4, 2015
Helpful?