Export to Excel - Truncated matrices due to Excel column limit (openLCA 2.5.0)

Question

Hi, 

While working on a contribution analysis, I noticed that the “Direct impact contributions” matrix in the Excel export is truncated. It seems this is due to Excel’s 16384 column limit. I could not find any way to extend that limit, so this means that for any product system with more than 16384 processes, the exported matrices are incomplete, right? 

Is there a way to export the matrix as a CSV, or transposed so that processes are in rows instead of columns? Or do you have any other idea how to solve this issue? 

Thanks!

Aaron

Answer 1

Hey,

same problem here.

Did find a solution ?

Simon

Comments

Hi Simon,

in the end I used the 'impact analysis' tab in the results window. There I grouped there by processes and set the no show threshold to 0%, then unfolded all impact categories one-by-one and then copied all entries. I pasted that in Excel and did some reformating until I could use it for the analysis.

Hope this helps.

Aaron

---

Thank you, but I've found a solution with the Python API. I asked ClaudeCode for a script to generate a .csv file (without column limits) with the results, by providing it this guide: https://greendelta.github.io/openLCAJython-manual/introduction/index.html. It worked very well and it's very flexible. You can do many things with it, including generating graphs.