Loading...
Home
User Guide
Announcements
Beta Forums
Feature Suggestions
Jobs @ WORK[etc]
Report Bugs
Training & Setup
Reference: A List of Contact Import *.csv or *.xls Headers Detected by WORK[etc]
#10
Importing Data
Contact 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.
[Getting Started]
Core Concepts
(7)
Getting Started Guide for Consultants
(1)
Importing Data
(6)
Interface Tips & Tricks
(29)
Overviews
(11)
Account Settings
Customer Portal
(7)
Interface, Language, and Location
(6)
Manage My Account
(7)
Permissions
(7)
Adding & Customizing Records
Custom Fields
(5)
Web Forms
(7)
Apps & Integrations
API - Developers
(3)
Box.com Integration
(2)
Email Dropbox Functionality
(5)
Evernote Integration
(2)
Google Apps Integration
(7)
Google Contact Sync
(2)
Outlook Add-in
(1)
Skype Click-to-Call
(1)
WORK[etc] Desktop TImer Tool
(1)
Xero Integration
(3)
Calendar
Calendar Sync & Settings
(5)
Using the Calendar
(8)
Contact Management (CRM)
Alerts
(1)
Companies
(3)
Contact Import Tool
(7)
Contact Settings
(3)
Contact Tags
(5)
Contacts
(23)
Contractors
(1)
Employees
(11)
People
(2)
Documents & File Attachments
Blogs
(2)
Documents
(5)
Files
(1)
Knowledge Base
(2)
Email Campaigns & Support Cases
E-mail Campaigns
(11)
Email Management
(9)
Support Cases
(8)
Finances & Billing
Account Summary
(3)
Expenses
(3)
Invoice Design
(4)
Invoicing & Billing Settings
(7)
Invoicing / Billing
(15)
Purchase History
Quickbooks
(1)
Taxes
(2)
Miscellaneous
Global Search
(3)
Miscellaneous
(2)
Project Management
Gannt Chart
(6)
General Project Questions
(10)
Project Access
(1)
Project Activity
(2)
Project Budgets
(2)
Project Collaborating
(4)
Project Overviews
(7)
Project Template
(2)
Reporting & Exporting
Exporting Data
(6)
Reports
(4)
Smart Lists
(3)
Sales
Commissions
(1)
Product Catalog(ue)
(4)
Quotes
(3)
Sales Leads
(13)
ToDos & Timesheets
Timesheets
(7)
ToDos (Tasks)
(7)
Zealotry and Advanced Tips
"WORK[etc] and You"
(4)
SQL Export
(2)
Tips from Power Users
(7)
© 2013
WORK[etc]
| UI v3.1 [BETA] |
Privacy Policy