Loading...

Reference: A List of Contact Import *.csv or *.xls Headers Detected by WORK[etc]#10

Importing DataContact Import Tool
We know how important it is to bring your existing contacts into WORK[etc] with the minimum of fuss, and so WORKetc attempts to auto-match a lot of fields for you. Most apps which allow you to export contacts are supported, provided you can export your data to a .csv or .xls file.

If you're able to customise your *.csv or .xls  export, below is a list of supported import fields which are auto-detected by WORK[etc]:

Website
website
www
homepage

Salutation
salutation
title

FullPersonName
name
displayname
display name
fullpersonname

Email_Primary
email address - work
email
e-mail
email address
e-mail address
emailaddress
email (primary)
email1


EmailAlt1
email2
email address - home
emailalt1
email alt1

EmailAlt2
emailalt2
email alt2

EmailAlt3
emailalt3
email alt3

FirstName
first name
firstname
given name
givenname
fname

LastName
surname
last name
lastname
sname

MiddleName
middlename
middle name

Comment
notes

Mobile
phone number - mobile
mobile
mobile phone
cell
cell phone

Gender
gender
sex

FullAddress_Home
home address
fulladdress (home)

FullAddress_Work
work address
business address
fulladdress (work)

FullAddress_Billing
billing address
fulladdress (billing)

Street_Home
address
address - home street
street
street1
home street
home address street
personal address street
street (home)

StreetLine2_Home
street2

City_Home
address - home city
suburb
suburb/city
city
home suburb/city
home suburb
home city
home address city
personal address city
city (home)

PostalCode_Home
address - home zip
post code
postcode
postal code
pcode
home pcode
home postcode
home postal code
home address zip
home zip
zip
personal address zip
postalcode (home)

StateOrProv_Home
address - home state
state
state/prov
home state/prov
home state
home address state
personal address state
stateorprov (home)

Country_Home
address - home country
personal address country
country
home address country
home country
home country/region
country (home)

Phone_Home
tel no
contact no
tel
phone number - home
phone
telephone
home phone
phone (home)

PhoneExt_Home
home phone ext
home phone extension
phoneext (home)

Fax_Home
phone number - fax
fax
home fax
fax number
fax (home)

Street_Work
address - work street
business address street
business street
work street
street (work)

City_Work
address - work city
business address city
business suburb/city
business suburb
business city
work city
city (work)


PostalCode_Work
address - work zip
business address zip
business pcode
business postcode
business postal code
business zip
work zip
postalcode (work)

StateOrProv_Work
address - work state
business address state
business state/prov
business state
work state
stateorprov (work)

Country_Work
address - work country
business address country
business country
business country/region
work country
country (work)

Phone_Work
phone number - work
work phone
work phone 1
business phone
phone_office
phone (work)

PhoneExt_Work
work phone ext
work phone extension
business phone ext
phoneext (work)

Phone_Work
business phone 2
work phone 2

Fax_Work
business fax
work fax
fax (work)

Street_Billing
address - billing street
billing address street
billing street
billing_address_street
street (billing)

City_Billing
address - billing city
billing address city
billing suburb/city
billing suburb
billing city
billing_address_city
city (billing)

PostalCode_Billing
address - billing zip
billing address zip
billing pcode
billing postcode
billing postal code
billing_address_postalcode
postalcode (billing)

StateOrProv_Billing
address - billing state
billing address state
billing state/prov
billing state
billing_address_state
stateorprov (billing)

Country_Billing
address - billing country
billing address country
billing country
billing country/region
billing_address_country
country (billing)

Phone_Billing
phone number - billing
billing phone
phone (billing)

PhoneExt_Billing
billing phone ext
billing phone extension
phoneext (billing)

Phone_Billing
billing phone 2

Fax_Billing
billing fax
fax (billing)

CompanyName
companyname
company name
company

CompanyPosition
jobtitle
company position
companyposition
company job title
position
job title

Tags_CommaDelimited
tags (commadelimited)
tags (comma delimited)
tags

Lead_OwnerName
lead owner
lead (ownername)

Lead_SalesProcess
lead_process
lead process

Lead_Stage
lead_stage
lead stage

Contact_SharedWith
contact (shared with)
contact shared with
shared with
share with

Comment
comment
comment1
latest comment 1

Comment2
comment2
latest comment 2

Comment3
comment3
latest comment 3

Comment4
comment4
latest comment 4

Type
type

IsPrimaryContact
isprimarycontact
is primary contact


Related Articles
Reference: What Contact Fields Can I Import Data Into?#227
Shows you what contact fields you can import data into
2 people found this useful.