Requirements for Employee Data

The Employee Import requires the following:

  • Each row must represent a single person.

Data Dictionary

The table below lists the columns that are the main fields to import.

Column Name Description and Example Column Required?

Email

Employee's company email.

jadams@company.com

Yes

First Name

Employee's first name.

Thomas

Yes

Last Name

Employee's last name.

Adams

Yes

Department

The department the employee belongs to.

Human Resources

Yes

Team

The type of employee. Such as Full-time, Part-time, Contractor, etc.

Human Resources International

Yes

Type

This is the type of employment.

Part time

Yes

Title

Employee's title.

Human Resources Intern

No

Reporting To

Employee's manager.

Thomas Smith

No

Location

This populates the employee’s location. Also, this field is used to populate the HR Location drop-down in the Building.

For more details, see Building and Employees Location Relationship.

Boston

Yes

Remote

These employees will not be coming back into the office or they have no office near them to go to. They will either work strictly from home or are a field worker.

In this column you can use either:

  • True
  • False

Learn more about Remote Employees, see When to Set up Remote Employees and No Desk Need Employees.

No

No Desk Needed

These employees are part of the back-to-work hybrid model, where they have an office near their home location.

In this column you can use either:

  • True
  • False

Learn more about Remote Employees, see When to Set up Remote Employees and No Desk Need Employees.

No

Phone

Employee's phone number.

xxx-xxx-xxx

No

Employee ID

1002

No

Additional Columns

If you want the following columns can be included in the Employe import file too. These files can be set up after your initial import.

Column Name Example Column Required?
Employee External ID   No
Building   No
Floor   No
Seat

The seat the employee is assigned to.

HQ-123

No
Seat Type

 

No
Seat Effective Date

 

No
Employee Assets/Needs

 

No
Note

 

No
Area (sqft)

 

No
Area (m^2)

 

No
Cost Center

 

No
Sub-Cost Center

 

No
Start Date

 

No
End Date

 

No
Secondary Seat

 

No
Neighborhoods

 

No
Seat Code

 

No
Employee Workplace Group Seat

 

No
Workplace Group

 

No
Badge

For more details, see Badge Swipe Integration or Aruba ClearPass Integration.

No

Example

For example, the initial employee import file is set up only with the columns needed.

employee_import_file1.png

Import Template File

Download the initial Employee Import Template File below