ABOUT ENERGY STAR PARTNER RESOURCES

Search by Topic:

How do I add properties using Spreadsheet upload templates? Follow

On the My Properties (home) page, on the bottom left, under "Manage Portfolio" click on: "Upload and/or update multiple properties"

Then follow these steps:

  1. Create your properties
    • Download the “Add Properties Template” (upper right).
    • Fill in this spreadsheet with your basic property information (name, address, gross floor area, etc) for all the properties you want to add. If you populate this spreadsheet by cutting and pasting data from another spreadsheet, you will be over-riding our data quality checks. Please double check every field to ensure it is valid. 
    • Upload this spreadsheet in the “Upload Spreadsheet” box (lower left), select “Add New Properties” as the “Type of Upload” and browse for the file you just filled in, then click “Upload.”
  2. Create the meters for all your properties.
    • Click on “Create an Upload Template” (lower right).
    • Select the task: Add Meters to Existing Properties; and select the properties that you want to for this task.
    • Create & Download the Template
    • Fill in this Spreadsheet with the required information.
    • Go back to the “Upload and/or Update multiple properties” page. In the “Upload Spreadsheet” box (lower left), select “Add Meters to Existing Properties” as the “Type of Upload.” Then browse for the file you just filled in and click “Upload.”
  3. Add Bill Data to your Existing Meters for all your properties.
    • Click on “Create an Upload Template” (lower right).
    • Select the task of: Add Bills to Existing Meters; and select the properties to include, the types of meters, and how many bills you want to enter for each.
    • Create & Download the Template
    • Fill in the Spreadsheet Template with the required information.
    • Go back to the “Upload and/or Update multiple properties” page. In the “Upload Spreadsheet” box (lower left), select “Add Bills to Existing Meters” as the “Type of Upload.” Then browse for the file you just filled in and click “Upload.”
  4. Update the "Use Details" for each property.
    • Each property type has a different set of required Use Details. (See list)
    • When the property was created in step 1, "default" values for each Use Detail were added so you could start seeing metrics. You'll want to update these values.
    • Use the Update Use Details spreadsheet to update these values.
    • Note, because this is an "Update" and not an "edit" you will have to change the date of the change to be one day after the "Current As Of" date.

**Note: you can NOT add properties that are parking garages or swimming pools through the spreadsheets, your property can have parking or a swimming pool, but it can't be the main property type.

Have more questions? Submit a request