Can employers and related contacts be imported?

Written By Josh Biller

Last updated 6 days ago

As part of the onboarding process, we can import employer data for you. To do so, we require data to be provided to us in two spreadsheets (CSV Files). A template for each is attached to this article.

Employers Import File - Click to Download CSV Template

COLUMN	REQUIRED / OPTIONAL	DESCRIPTION
Business Name	Required	Must be unique, no two Business names may be the same.
Address 1	Optional
Address 2	Optional
City	Optional
State	Optional	Two-Letter Abbreviation
Zip Code	Optional
Fax	Optional
Website	Optional
Notes	Optional
Tags	Optional	Comma-separated
Opportunity Types	Optional	Comma-separated (see options below)
Career Cluster	Optional	Numeric - See options below
Career Pathway	Optional	Numeric - See options below
Non Profit	Optional
DBA	Optional
Business Type	Optional
Email	Optional
Phone	Optional
LinkedIn	Optional
Facebook	Optional
Instagram	Optional
X (Twitter)	Optional
YouTube	Optional

Employer Contacts Import File - Click to Download CSV Template

COLUMN	REQUIRED / OPTIONAL	DESCRIPTION
Business Name	Required	Must be the same as the name of an existing employer
First Name	Required
Last Name	Required
Title	Optional
Email Address	Optional
Work Phone	Optional
Cell Phone	Optional
Preferred Contact Method	Optional	Work Phone, Cell Phone, or Email
Notes	Optional
Secondary Email	Optional
Tags	Optional	Comma-separated
Opportunity Types	Optional	Comma-separated (see options below)
Salutation	Optional	ie. Mr., Mrs., Dr.
Department	Optional
LinkedIn	Optional
Facebook	Optional
Instagram	Optional
X (Twitter)	Optional
YouTube	Optional

OPPORTUNITY TYPES:

Apprenticeship / Pre-Apprenticeship
Career Fair / Career Day
Career Interest Survey
Career Research Project
Cooperative Education
Diversified Occupations
Entrepreneurship
Externship
Full-time Employment
General Work Experience
Guest Speaker
Industry-Based Project / Live Work
Informational Interview
Internship (Unspecified)
Internship (Paid)
Internship (Unpaid)
Job Shadow
Mentorship
Mock Interview
Practicum / Clinical Experience
School-Based Enterprise
Service Learning
Summer Employment
Volunteer / Community Service
Workplace Tour / Field Trip

CODE	CAREER CLUSTER NAME
1	Agriculture, Food and Natural Resource Cluster
2	Architecture and Construction Cluster
3	Arts, Audio/Video Technology and Communications Cluster
4	Business, Management and Administration Cluster
5	Education and Training Cluster
6	Finance Cluster
7	Government and Public Administration Cluster
8	Health Science Cluster
9	Hospitality and Tourism Cluster
10	Human Services Cluster
11	Information Technology Cluster
12	Law, Public Safety, Corrections and Security Cluster
13	Manufacturing Cluster
14	Marketing Sales and Service Cluster
15	Science, Technology, Engineering and Mathematics Cluster
16	Transportation, Distribution, and Logistics Cluster

CODE	CAREER PATHWAY NAME
1.1	Food Products and Processing Systems Pathway
1.2	Plant Systems Pathway
1.3	Animal Systems Pathway
1.4	Power Structure and Technical Systems Pathway
1.5	Natural Resources Systems Pathway
1.6	Environmental Service Systems Pathway
1.7	Agribusiness Systems Pathway

CODE	CAREER PATHWAY NAME
2.1	Design/Pre-Construction Pathway
2.2	Construction Pathway
2.3	Maintenance/Operations Pathway

CODE	CAREER PATHWAY NAME
3.1	Audio and Video Technology and Film Pathway
3.2	Printing Technology Pathway
3.3	Visual Arts Pathway
3.4	Performing Arts Pathway
3.5	Journalism and Broadcasting Pathway
3.6	Telecommunications Pathway

CODE	CAREER PATHWAY NAME
4.1	Management Pathway
4.2	Business Financial Management and Accounting Pathway
4.3	Human Resources Pathway
4.4	Business Analysis Pathway
4.5	Marketing Pathway
4.6	Administrative and Information Support Pathway

CODE	CAREER PATHWAY NAME
5.1	Administration and Administrative Support Pathway
5.2	Professional Support Services Pathway
5.3	Teaching/Training Pathway

CODE	CAREER PATHWAY NAME
6.1	Financial and Investment Planning Pathway
6.2	Business Financial Management Pathway
6.3	Banking and Related Services Pathway
6.4	Insurance Services Pathway

CODE	CAREER PATHWAY NAME
7.1	Governance (Legislators and general government executives and staff) Pathway
7.2	National Security Pathway
7.3	Foreign Service Pathway
7.4	Planning Pathway
7.7	Public Management and Administration Pathway

CODE	CAREER PATHWAY NAME
8.1	Therapeutic Services Pathway
8.2	Diagnostics Services Pathway
8.3	Health Informatics Pathway
8.4	Support Services Pathway
8.5	Biotechnology Research and Development

CODE	CAREER PATHWAY NAME
9.1	Restaurants and Food/Beverage Services Pathway
9.2	Lodging Pathway
9.3	Travel and Tourism Pathway
9.4	Recreation, Amusements and Attractions Pathway

CODE	CAREER PATHWAY NAME
10.1	Early Childhood Development and Services Pathway
10.2	Counseling and Mental Health Services Pathway
10.3	Family and Community Services Pathway
10.4	Personal Care Services Pathway
10.5	Consumer Services Career Pathway

CODE	CAREER PATHWAY NAME
11.1	Network Systems Pathway
11.2	Information Support Services
11.3	Interactive Media Pathway
11.4	Programming and Software Development Pathway

CODE	CAREER PATHWAY NAME
12.1	Correction Services Pathway
12.2	Emergency and Fire Management Services Pathway
12.3	Security and Protective Services Pathway
12.4	Law Enforcement Services Pathway
12.5	Legal Services Pathway

CODE	CAREER PATHWAY NAME
13.1	Production Pathway
13.2	Manufacturing Production Process Development
13.3	Maintenance, Installation and Repair Pathway
13.4	Quality Assurance Pathway

CODE	CAREER PATHWAY NAME
14.1	Management and Entrepreneurship Pathway
14.2	Professional Sales and Marketing Pathway
14.3	Buying and Merchandising Pathway
14.5	Marketing Information Management and Research Pathway
14.7	E-Marketing Pathway

CODE	CAREER PATHWAY NAME
15.1	Engineering and Technology Pathway
15.3	Science and Mathematics Pathway

CODE	CAREER PATHWAY NAME
16.1	Transportation Operations Pathway
16.2	Logistics Planning and Management Services Pathway
16.3	Warehousing and Distribution Center Operations Pathway
16.4	Facility and Mobile Equipment Maintenance Pathway
16.7	Sales and Service Pathway