Bulk Room Upload

To achieve a successful upload of your spreadsheet, please make sure it follows the template provided in STARS. Additionally, you may need to adjust the formats of specific fields.

If Excel prompts you to perform a data conversion when opening the spreadsheet, select Don't Convert.

To format a column, select it, then right click and navigate to format cells. You can also get here with the key chord Ctrl+1 (Cmd+1 on a mac).

Ensure that the cells are formatted accordingly:

Level

DeptID/Admin DeptID

Note that this formatting will depend on the length of your department IDs. UF's all have 8 digits so we use 8 0's.

BeInst, BeCat, and BeSubcat

These must all be codes i.e. 'EG' instead of 'Education and General'.

Effective Date

Once you have ensured that the cell formatting is correct, save the spreadsheet and try the upload again.

Optional fields

You can optionally choose to include optional fields in the spreadsheet upload. These are

• Area - a number in sq ft