Question-and-Answer Resource for the Building Energy Modeling Community
Get started with the Help page
Ask Your Question

How can I extract my OpenStudio results to excel?

asked 2015-01-16 03:41:24 -0500

tfgjer's avatar

updated 2015-07-11 19:02:09 -0500

I would like to make my own graphs with the OpenStudio data.

edit retag flag offensive close merge delete


Have a look at this answer

Jamie Bull's avatar Jamie Bull  ( 2015-01-16 03:49:50 -0500 )edit

1 Answer

Sort by ยป oldest newest most voted

answered 2015-01-16 09:53:08 -0500

When OpenStudio runs it produces all of the E+ outputs that you can use in Excel to create graphs. I have found that the easiest way to do this is to copy and paste data from the eplustbl.htlm output file into an Excel spreadsheet. This file is located in the project folder -> run -> 4-EnergyPlus-0 -> eplustbl.htm. The file has tons of data in spreadsheet form and you can find out more about it in the EnergyPlus InputOutputReference document.

If that file doesn't have what you are looking for you can also look into the eplusout.sql file.

edit flag offensive delete link more


thanks very much for these valuable information, i did exactly what you said to export meter data to CSV and it worked but i don't know where to find the CSV file?

shahin1992's avatar shahin1992  ( 2016-04-28 22:04:23 -0500 )edit

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Training Workshops


Question Tools



Asked: 2015-01-16 03:41:24 -0500

Seen: 1,377 times

Last updated: Jan 16 '15