EcoEditor for ecoinvent version 3 now available
This page here describes the MS Excel macro EcoSpoldAccess for handling of ecoSpold v1 XML datasets. Please note that the ecoSpold v1 format is no longer used for submission of new datasets to the ecoinvent database. For the current submissions to the next versions of the ecoinvent database (i.e. currently to version 3), the new tool "ecoEditor for ecoinvent version 3" has been developed to create, edit, review and upload datasets. --> More information and download here ...

EcoSpoldAccess Download

On this page you can download the EcoSpoldAccess software component and the corresponding licence agreement. This macro for MS Excel serves to convert the XML files downloaded from the ecoinvent database to an Excel spreadsheet file. It is also possible to use this macro to create XML files compatible to the EcoSpold data format from an Excel spreadsheet.

Please note that the conversion Excel2EcoSpold of results files may take some time (up to 10 to 20 minutes) depending on the Excel Version used and its settings. If you encounter problems and you would need the Excel-files for LCA calculations, please contact the ecoinvent support. If you just like have a look at the files, please use the function "View EcoSpold document ..." of the EcoSpold software.

To install the EcoSpoldAccess software component version 1.9.17 on your PC, download the file  EcoSpoldSetup.1.9.17 to your computer and run the executable. In case you use older versions of the EcoSpold software, please make sure that you deinstall all old versions before installing the new one. The procedure to deinstall previous versions is described in the EcoSpold documentation.

Please make sure that your system meets the following requirements for installing the EcoSpoldAccess:

• Operating system: Windows XP Service Pack 3 or Windows Vista
• Microsoft Excel: Version 2003 or newer

If your system does not meet the operating system requirements you can manually install the Microsoft Xml Parser Version 6. It can be downloaded without charge from the Microsoft websites (Microsoft Core XML Services (MSXML) 6.0). If you want to use the EcoSpoldAccess Software with Microsoft Excel XP please install EcoSpoldSetup.1.9.10. Please be aware that this version is no longer supported, will not work on Microsoft Vista and may contain out of date data.

The installation will add the button bar "EcoSpoldAccess" in Excel. To convert XML files, that you have downloaded from the ecoinvent database, run Excel and click on the button "EcoSpold2Excel".

Further information is contained in the documentation file (DocumentationEcoSpold1.3.pdf), which can be found in the subdirectory "ecospold\Doc" of the installation directory you selected. The ecospold directory also contains the XML-Scheme and a description of the EcoSpold data format along with sample files. Please note that the sample files only contain fictitious data.

R. Heijungs developed a software that facilitates the conversion steps between CMLCA and EcoSpold of representations of the four statistical distributions uniform, triangular, normal and lognormal. 

Downloads