Skenarios support

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 43 Next »

You can import properties, renovations, maintenances and leases by an Excel document on SkenarioLabs service's Import & Export-page. Excel sheets can contain only predefined set of columns.

How to

Go to the Export & Import view.

Choose the portfolio where data should be imported or create a new one.

For new portfolios, you can give a title for the portfolio. 

Before import, you can also choose if SkenarioLabs should assume all properties to have their renovation history done by assumed renovations. If you choose not to generate historical renovations, all needed renovations and repairs are scheduled for the next year.

After a successful upload, you will be informed which sheets and rows in the uploaded file are invalid and not uploaded to the SkenarioLabs database. A row might be declared invalid if a mandatory cell is empty, or there is a spelling error. Fix these rows appropriately according to these instructions.  

Import file format

The first row in the Excel file is a header row, but the order of the headers is not fixed. For headers, you can use lower and upper case letters as you wish, but a misspelling yields an erroneous result.

Below the header row are the actual data rows. Import Excel can only be used to upload new properties; it cannot be used to update existing properties. However, renovation, lease and maintenance costs and descriptions can be updated by import.


A building is a fundamental element in SkenarioLabs and thus any imported unit or renovation has to be tied to a building. A building can be imported by an address (which is composed of a country code, city, postcode and street address)

Column titleDescriptionAllowed values
Country code
FI, UK, PT, SE, or PL

The name of the city or town.

PostcodePost codeString
Street addressstreet address of the buildingString

 or by a vtj-prt (only applicable in Finland)

Column titleDescriptionAllowed values
vtj-prtPermanent Construction ID (VTJ-PRT) is issued to all buildings in Finland. It can be used to identify the exact location of the building. Enter only if you know the actual ID.String

As almost any type of import has to be tied to a building, it has to be imported with building details (that is, address or vtj-prt) or a building ID. These two methods have a significant difference; the latter assumes the building in question is already in SkenarioLabs database, whereas the latter makes no such assumption but creates the building if needed. Units can be imported also with group id only.

  • No labels