Import properties

Import buildings

In order to import buildings, it is mandatory to provide the location details and a unique id for each building. The location details can be given in as coordinates, national building id, or address details. For further details, see Overview. In addition, further details of a building can be imported by optional headers.

Mandatory Headers

In addition to a unique building id, a full address, a national building id, or coordinates are mandatory to import a building. 

Column title 

Description

Allowed values

Column title 

Description

Allowed values

Building id AND

A unique building id.

Unique string

Latitude and longitude OR

Make a column for latitude and a column for longitude. The coordinates are to be inside the building.

Numeric

National building id OR

Specifies the unit in a building. The full address of the building is required when using the Unit specifier without Unit id. Unit specifier value can be anything which is unique within the given address.

Any string

Country code, postcode, street address and city

Make a column for each of the four titles. Country code can take values FI, CA, CH, PL, SE, PT, UK, US.

String

Optional headers

Column title

Description

Allowed values

Column title

Description

Allowed values

Group id

Used to identify which group this property belongs to. If this is not given, it'll be created automatically.

Any string

Group name

Name of the property group. If this is not given, it'll be created automatically for you.

Any string

Building name

Name of the property building. If this is not given, it'll be created automatically for you.

Any string

Building prototype

Usage type of the property building.

detached house, terraced house, office, apartment, commercial building, row house, school, retail building, industrial building, generic building, garage, warehouse and holiday home.

Electricity energy type



grid electricity

Heating energy type



electric heating, district heating, oil boiler, gas boiler, ground-source heat pump, wooden pellet burner, solar hot water collector, gas condensing boiler, water source heat pump, eluppvärmining, fjärrvärmning, olja, and bergvärmepump

Building floor area

Gross floor area of the building in m2.

Integer

Floors

Amount of levels in the building. Ground floors is counted as one. 

Integer

Floor height

(Average) floor height in the building in metres.

Integer

Build year

Build year of the building.

Integer

Building volume

The volume of a building in m3.

Integer

Facade

The facade material of the building.

brick, concrete, metal, plaster, wood

Roof

The roof material of the building

bitumen, metal, tile

Car parking

Type of car parking

None, Parking space, Garage, Carport, Undercover parking

Lot size in m2

Lot size in m2

Numeric

Own lot

Own lot

Boolean

Is waterside lot

Is waterside lot

Boolean

End year of lot lease

End year of lot lease

Numeric

Garden building(s)

Garden building(s)

Boolean

Is housing company

Is housing company

Boolean

Property image URL

Property image URL

Text

Import custom properties

It is possible to import values for the building's custom property value fields such as property image. Prior to a custom field import, however, it is mandatory to create the field for a portfolio. For more information about creating a custom field, please refer to the Settings page.

To import value for the custom property field, enter the title of the property field as a header to the Excel sheet as it would be any normal field. If there are multiple fields with the same title, first field will be used, but it remains undecided, which one.

Import Units

Certain headers are mandatory in order to import a unit, but additional details can also be imported by optional headers.

Mandatory Headers

A unit id is mandatory in order to import a unit. A unit id has to be unique in a portfolio. In addition, units are required to be linked to a building or a group (or both) by a building id or a group id.

Column title 

Description

Allowed values

Column title 

Description

Allowed values

Unit id

Specifies the unit in a portfolio. If this is not given, it'll be created automatically.

Any string

Building id OR

The id of the building where the unit is located

Any string

Group id OR

The id of the property group where the unit is located

Any string

Optional headers

Column title 

Description

Allowed values

Column title 

Description

Allowed values

Unit name

Name of the property unit. If this is not given, it'll be created automatically.

Any string

Unit description

Free text field for the description of the unit. Also, all information under the headers in your file that are not listed in these instructions will be presented here. NOTE: rows, where the header is misspelt will appear here.

Any string

Unit price

Property units total value in local currency. Current date will be used as the value date.

Integer

Total floor area

Unit's total floor area in m2

Integer

Unit Habitable Floor Area

Unit habitable floor area in m2

Integer

Unit usage type

Type of usage purpose of the unit. Allowed values are: Residential, Office, Retail, Storage or Other

String

Unit floor

Unit's floor. Number 1 being ground floor.

Integer

Condition

Unit's condition

Excellent, New, Good, Mediocre, Poor

Number of rooms

Number of rooms

Integer

Sauna

Type of sauna. Only for residential units in Finland.

Yes, No, Sauna building, Lakeside sauna

Type of Balcony

Type of balcony

Balcony, Glazed Balcony, French Balcony

Type of Kitchen

Type of kitchen

Kitchen, Open Plan Kitchen, Kitchenette

Type of Terrace

Type of terrace

Yes, No, Glazed Terrace

Has fireplace

Has fireplace

Boolean

Monthly Maintenance Fee

Monthly maintenance fee 

Integer

Monthly Housing Loan Fee

Monthly housing fee

Integer

Mortgage Application Id 

Mortgage application Id

String

Import custom properties

It is possible to import values for the unit's custom property value fields such as property image. Prior to a custom field import, however, it is mandatory to create the field for a portfolio. For more information about creating a custom field, please refer to the Settings page.

To import value for the custom property field, enter the title of the property field as a header to the Excel sheet as it would be any normal field. If there are multiple fields with the same title, the first field will be used, but it remains undecided, which one.