Importing and exporting data¶
Note
This section is a work in progress.
This section explains the different ways of importing and exporting data to and from a Spine database.
Excel¶
In this section the excel import/export functionality is explained.
To import/export an excel file, select a Data store and open the Tree view. Then select File -> Import or File -> Export from the main menu.
Format¶
The excel files for import/export are formatted in the following way:
Tip
An easy way to get a excel template is to export an existing spine-database to excel.
Object classes:
Object timeseries:
Relationship classes:
Relationship timeseries:
When importing, all sheets with a valid format are imported, whereas sheets with invalid format are simply ignored. When exporting all object classes and relationship classes are exported. Only parameter values with timeseries data are exported in the timeseries format.