Spreadsheet errors (kickout)

Last updated April 30, 2026

When you upload a setup spreadsheet and EnergyCAP detects errors in your data, it automatically generates an error spreadsheet—also called a kickout spreadsheet. Only the rows with errors are included, so you can focus on fixing just what went wrong. Once you've corrected the errors and re-uploaded the file, EnergyCAP processes the remaining records.

Correct errors on an error (kickout) spreadsheet

  1. Download the error spreadsheet.

    Setup Spreadsheets Log with an arrow pointing to the 1 record link in the Errors column for the Collections Sheet update.
  2. Review the error message and make your corrections in the spreadsheet.
  3. Import the corrected spreadsheet into EnergyCAP.
  4. Review the spreadsheet log for your results and repeat the process as needed.

Error messages

  • Each row in the error (kickout) spreadsheet is a different error.
  • The first column states the error message.
  • The incorrect cell in each row is highlighted.

Example

  1. This update sheet has a duplicate organization code.
    Spreadsheet of Organization Information with Organization Code and Organization Name columns, where the code Reporting entered in the Organization Code Update column on the Police row is labeled as a duplicate of the Reporting organization.
  2. After the file is uploaded, a banner message indicates an error. The failed column provides a link to download the error (kickout) spreadsheet.
    Setup Spreadsheets Log with a red banner that Update Buildings & Organizations completed with failures and instructions to correct failures using the error spreadsheet, and the failed update row highlighted.
  3. Download and open the spreadsheet.
    Error spreadsheet with an Error Messages column reading Duplicate place found for GOV and the Organization Code Update cell for ACADEMY set to GOV and highlighted.
  4. Fix the error and save the spreadsheet.
    Error spreadsheet with an Error Messages column reading Duplicate place found for GOV and the Organization Code Update cell for ACADEMY corrected to Academy1.
  5. Upload and review the status.
    Setup Spreadsheets Log with a green banner that Update Buildings & Organizations completed, and the Successful column showing 1 record outlined.