Setup spreadsheet errors

If you have errors in your spreadsheet, the system generates an error  (kickout) spreadsheet. You can download this spreadsheet, fix the errors, and upload it into the application.

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. Use the Import button to upload the error spreadsheet in UtilityManagement.
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 spreadsheet.
   
3. Download and open the kickout spreadsheet.
   
4. Fix the error and save the kickout spreadsheet.
   
5. Upload and review the status.