Exporting databases
Exporting databases in openLCA allows users to extract and save data in various formats for further analysis or sharing.
openLCA supports data export in many formats, offering adaptability to different needs:
- Ecospold: Allows exporting impact assessment methods and processes.
- Excel: Enables exporting processes, analysis results, Monte Carlo simulation results, and more.
- ILCD Network Export: Allows exporting data in the XML-based format adapted from the International Life Cycle Data system format.
- SimaPro CSV: Provides compatibility for exporting data in SimaPro CSV format.
- JSON-LD: Allows exporting databases in JSON-LD format, which is a standard for linked data encoding.
To export data from openLCA, follow these steps:
- Activate the database you want to export from by double-clicking on it.
- Click on "File" and select "Export" to open the export wizard.
Exporting data from an active database
- Here we provide specific instructions for exporting different data types:
- Ecospold: Choose either "Impact method"s or "Processes" after clicking on "EcoSpold". Select the destination directory and the datasets to export, then click "Finish".
Selecting data/processes to be exported
-
Excel: To export processes as Excel files, select "Processes" after clicking on "Excel". Specify the export directory and the processes to export, then click "Finish". Each process will be saved as an individual Excel file.
-
ILCD ZIP-file: Select "ILCD Zip-File" in the export wizard. Choose an export directory and the database elements to export in ILCD format. Click "Finish".
Selecting the destination and the data set for the ILCD export
-
SimaPRo CSV: You can choose between exporting LCIA methods or processes in SimaPro CSV. Then click on "Next" to select the elements you whant to export, select a recipient folder for the CSV and and eventually click on "Finish".
-
JSON-LD: openLCA allows to export your database as JSON-LD. This allows you to efficiently export selected datasets (processes, product systems etc even on a folder level). Also, you can export the default provider for product inputs and waste outputs. For this, select "JSON-LD" in the export wizard. Choose an export directory and the database elements to export, then click "Finish".
Selecting the dataset/s and destination for the JSON-LD export
Note: The option "Export default providers of product inputs and waste outputs" will not only export the provider link but also the linked processes. This is important if you only export the processes but not the whole database.
For details about JSONLD click here.
Copy function
openLCA allows users to easily copy information from any table and paste it into other applications like Excel or Notepad. Please check "Importing and exporting data" section for details.