Spreadsheet errors (kickout)

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.
   
   
   
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.
   
2. After the file is uploaded, a banner message indicates an error. The failed column provides a link to download the error (kickout) spreadsheet.
   
3. Download and open the spreadsheet.
   
4. Fix the error and save the spreadsheet.
   
5. Upload and review the status.