<aside>
<img src="notion://custom_emoji/3550dc93-80a1-47ad-8751-1d4a1f9bbcc8/330f8539-b2f0-8087-944f-007a48bfca7d" alt="notion://custom_emoji/3550dc93-80a1-47ad-8751-1d4a1f9bbcc8/330f8539-b2f0-8087-944f-007a48bfca7d" width="40px" />
This feature is available to Scale licence clients only. If you are interested in access, please contact your Account Operations representative to discuss upgrading your package.
</aside>
What's new
- Asset groups and their underlying assets appear as separate rows in the GRESB asset-level spreadsheet
- Underlying asset rows are highlighted in purple to distinguish them from the asset group row
- Column A flags which rows are underlying assets and should be removed before upload
- This row structure is reproduced across all relevant tabs (e.g., Energy, Building Certifications, Efficiency Measures)
How it works
- Download the GRESB asset-level spreadsheet from Data Collection Portal → Portfolio → Asset List
- The spreadsheet includes one row per asset group and one row per underlying asset within each group, across all tabs
- Review the underlying asset rows (highlighted in purple) to understand the data for each member asset
- Manually enter or calculate the aggregated value for the asset group row — using whichever logic is appropriate (e.g., sum, weighted average, qualitative judgement)
- If the asset group row references a formula that depends on the underlying asset rows, copy the calculated value and paste it as a value only (Ctrl+C → Paste Special → Values) before deleting the underlying rows
- Delete all purple underlying asset rows across every tab before uploading
- Upload the spreadsheet as normal
Note: If underlying asset rows are not deleted before upload, they will be included in the submission. Always confirm all purple rows have been removed.
Tip: Formulas referencing underlying asset rows will return an error or empty value once those rows are deleted. Save values before removing source rows.
Where to find it
Data Collection Portal → Portfolio → Asset List → Download
Select the GRESB report type and download the asset-level spreadsheet. Asset group rows are included automatically when asset groups exist in the portfolio.
Additional notes