Export property data in an Excel file

You can export an Excel document on Skenarios service's Import & Export-page. The exported Excel contains two sheets, one for buildings and one for units. Please, note that all the information uploaded into the Skenarios' service by Excel Import may not be included in the exported Excel, hence we recommend you to save your original Excel file to prevent possible loss of information.

How to

Go to the Export & Import view.

Choose a portfolio to be exported; portfolio 'Helsinki' is chosen in the adjacent figure.

Click 'Create Export', the export process will start. For small portfolios, the download link will appear almost immediately and you can download the export file.

For large portfolios, the processing will take a while and the link will appear once the export is done. You will get a notification if this is the case. You can see the completed export file when you refresh the page.

Renovations

An exported Excel represents building level renovations for the next decade in great detail. Each year has its own column for yearly total renovation costs, and the following column presents the details of the total costs. The details column manifests the renovated building parts and their costs. The exported Excel contains also a column for the total renovation costs in a decade per a building floor area.

Building details sheet

<year> renovation details - Details of yearly renovation costs. Renovated parts and their costs in a given year are listed. Contains both Assumed and Planned renovations.
<year> renovations - Yearly renovation costs of a building given in local currency. Contains both Assumed and Planned renovations.
Address - The street address of a building.
Build Year - The construction year of a building.
Building ID - Identifies a building uniquely in a portfolio
Building Name - Name of the building
Building prototype - Type of the property
Cooling Demand (kWh/m2/a) - The cooling demand of the property.
Decade costs per floor area - Total renovation costs of the upcoming decade of a building given in local currency. Contains both Assumed and Planned renovations.
Decade total costs - Total costs of 10 years renovations
Electricity - The electricity source of a building.
Electricity Demand (kWh/m2/a) - Electricity consumption of the property.
Facade Area - The gross facade area of a building in square meters.
Floor Area - The gross floor area of a building in square meters.
Floors - The number of floors in a building.
Group id - Identifies a group uniquely in a portfolio
Group name - Name of the property group
Heating - The heating source of a building.
Heating Demand (kWh/m2/a) - Heating consumption of the property.
Solar Potential (kWh/a) - Potential solar energy production of a building, if the building rooftop is equipped with solar panels.
Usage purpose - Usage code of the building. 11 stands for residential.

Unit details sheet

If the portfolio has any units, the second sheet has details of them.

Unit ID - Identifies the unit uniquely in a portfolio
Building ID - Identifies the building uniquely in a portfolio
Group ID - Identifies the group uniquely in a portfolio
Unit Name - Name of the unit
Description - Description of the unit
Address - Address of the unit
Estimated unit value - The latest estimated value of the unit
Floor area - Floor area of the unit
Floor - Floor number of the unit
Bathroom renovation & Cost - Year and cost of the next coming renovation
Kitchen renovation & Cost - Year and cost of the next coming renovation
Heating system renovation & Cost - Year and cost of the next coming renovation
Maintenance - List of last 5 years maintenances done to this unit
Total cost - Total cost of the previous maintenances
Maintenance description - Descriptions of the previous maintenance works

Updated on: 27/04/2021