Resolve Common Import Errors

This article addresses common importing errors and provides corrective steps. It includes a table of contents with issues such as a green import bar indicating no data added, a white screen during import, and unrecognized employee numbers. For the green import bar issue, it suggests checking for similar dropdown options in the spreadsheet. The white screen error may stem from file format issues or large file sizes. The article advises converting Excel files to CSV or vice versa and ensuring only relevant data is copied. If the system cannot interpret the file, users should remove any formulas. The article also highlights the importance of correct employee numbers and matching pay schedule names for successful data imports. Each section offers specific guidance to resolve these issues efficiently.

  • May 19, 2026
  • Knowledge

Title
Resolve Common Import Errors
Article Text
This feature is included in the Core, Pro, and Elite packages.

This article covers the most common importing errors and the steps to correct them before trying again.

Table of Contents

Green import bar, but no data was added to the employee profile

What’s going on: This could be due to tables, fields, or dropdown options being too similar. 

For example, you have a dropdown list field for additional departments that employees report to. In the list, there are two options that are very similar, “Finance Office” and “Finance Offices." In the spreadsheet, you may have accidentally entered “Finance Offices" instead of “Finance Office." This would cause the data to be blank in the employee profile because the list item did not match.

To fix this, follow these steps:

  • Go to Settings  >  Employee Fields.
  • Choose the field with the list item(s) you need to fix.
  • Edit the list item(s).
  • Review your spreadsheet to ensure the data is entered correctly.

White screen

What’s going on: There are a few things that could be affecting the import.

  • Try changing the file from an Excel file to a CSV file or vice versa. Sometimes this can correct the backend formatting that caused the issue.
  • The file size might be too large. Try copying and pasting the data into a new spreadsheet:
    • Grab only the data and copy it. Drag your mouse over what you want to capture. You should not use the triangle above row A1 to capture the data or grab the entire sheet. There can be hidden data or formatting in the empty rows or columns, so you do not want those to transfer to your new spreadsheet.
  • A slow internet connection and a large file can cause a timeout and a white screen.

Unable to interpret file

What’s going on: Your sheet is referencing a formula. Copy the fields and “Paste as Values."

Try this: You can use Find & Select > Formulas to find formulas easily. Make sure to remove any formulas.

Employee number not found

What’s going on: Employee number is incorrect or is not included in the employee profile. This field is vital as it tells the system which employee to send the information to. 

Unable to load pay schedule using name

What’s going on: The pay schedule has not been created, or the pay schedule name does not match. The spelling, capitalization, and spacing in the pay schedule name must match. 

You can add that or fix the name in Settings > Employee Fields > Pay Schedule. This must be set up before you can import information from the Compensation table.

URL Name
2021892