Import data from Excel sheet

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.

Overview

A building is a fundamental element in SkenarioLabs and it is the first thing you import, all following imports will be tied to a building. Furthermore, in the following imports, an imported item will be tied to building by a building id. This is good to keep in mind when planning imports; for example, if you will also be importing building renovations and you have an id which links a renovation to a specific building, this id should be the building id.


Importing a building requires a unique building id and the location details. The location can be provided as 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
City

The name of the city or town.

String
PostcodePostcodeString
Street addressStreet address of the buildingString

 or as a national building id (vtj-prt in Finland)

Column titleDescriptionAllowed values
National building idFinland: Permanent 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

or as coordinates

Column titleDescriptionAllowed values
LatitudeLatitude within a building.

Numeric

LongitudeLongitude within a building.Numeric