Upload Worker Information Task: Use Spreadsheet

On this page, we'll go through how you can use the spreadsheet method to upload your workers' information into Zenefits to complete the Add Your Workers' Information task.

Method 1: Template

To use the template spreadsheet method, you'll need to download our template. This will download a blank Excel spreadsheet with prefilled formatting and column headers.

While we recommend taking this time to include as much information as you can, the most important fields to include will be:

HR fields:

  • First Name
  • Last Name
  • Email Address
  • Work Location
  • Status (Active or Terminated)
  • Hire Date
  • Termination Date
  • Employment Type
Benefits fields:
  • Legal Gender
  • Job Title
  • Street Address
  • Date of Birth
  • SSN
Time & Attendance fields:
  • Compensation Type
  • Pay Rate
Payroll fields: 
  • Bank Account & Routing Number
  • Payment Method (Direct Deposit or Check)
  • FLSA Classification
  • Tax Withholdings
  • Banking Information

Method 2: Bring Your Own File

To use your own spreadsheet to upload your worker information into Zenefits, you'll click Use Spreadsheet, then drag and drop the file.
After the file uploads, you'll need to map the data from your spreadsheet into Zenefits.
Data Grid Mapping
On the left side, you'll see the Zenefits labels. On the right side, you will select from the column headers in your spreadsheet.

What should I do if the Zenefits field isn't captured in the spreadsheet?

You can bypass this step for now and enter the information manually in a later step.

What do I do if the column from my spreadsheet gets a message next to it?

If the column you select causes a message to pop up next to it that says Map values - Add then you'll need to provide some additional clarification to map the info into Zenefits.
  1. Click Add

    Data Grid Value Mapping

  2. In the window that pops up, you'll see a list of Zenefits populated fields on the left. On the right, you'll select from the drop down of imported values to map your spreadsheet to Zenefits fields.
Any fields that aren't mapped will not be imported to Zenefits system. If you have fields that don't map to Zenefits--for example, you have no interns in your spreadsheet, then it's fine to leave the drop-down blank.

This mapping process is repeated for the following main categories:
  • Required Info
    • First Name
    • Last Name
    • Email Address
    • Work Location
    • Status
  • Employment Info
    • Hire Date
    • Termination Date
    • Employment Type
    • Compensation Type
    • Pay Rate
    • FLSA Classification
    • Job Title
    • Department
  • Tax Info
    • Federal Tax Withholding Allowances
    • Federal Additional Withholding
    • Federal Filing Status
    • State Tax Withholding Allowances
    • State Additional Withholding
    • State Filing Status
    • Local Tax Withholding Allowances
    • Local Additional Withholding
    • EIN
    • Business Name
    • Tax Classification
    • Exempt Payee Code
    • FATCA Exemption
  • Bank Info
    • Payment Method
    • Bank Account #1 Nickname
    • Bank Account #1 Type
    • Bank Account #1 Routing Number
    • Bank Account #1 Number
    • Bank Account #1 Distribution
    • Bank Account #2 Nickname
    • Bank Account #2 Type
    • Bank Account #2 Routing Number
    • Bank Account #2 Number
    • Bank Account #2 Distribution
  • Personal Info
    • Middle Name
    • Preferred Name
    • Legal Gender
    • Gender Identity
    • Personal Pronouns
    • Date of Birth
    • Social Security Number
    • Street Address
    • Street Address 2
    • City
    • State/Province
    • Country
    • Zip Code
    • Personal Phone
    • Work Phone Number
Once you confirm that all fields you would like to import from your spreadsheet into Zenefits are mapped, you can click Finish. At this point, you'll be brought to an overview of all of the information you've uploaded from your spreadsheet. If any required fields were left blank, then you'll see a red error icon next to the individual's name.

This error message means a required field was left blank. If you don't see a red square around an empty on the tab you're on, you can click to the other tabs (Required Info, Employment Info, Tax Info, Bank Info, Personal Info) to correct the validation. Hovering over the red icon will display exactly which cell needs validation.

Once you've fixed all the validation errors, click Submit. While you can submit the data with missing information, we recommend getting everything squared away during this setup flow. Missing information now can cause issues with your company's use of Zenefits down the road.

Was this answer helpful?  

Still need our help? Our support team is waiting to help you. Contact us