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

#EnergyPlus How to imported eio file into spreadsheet programs

asked 2022-12-30 20:35:31 -0500

HE Shi's avatar

updated 2023-01-04 10:16:37 -0500

According to the Documentation:The eio file or portions of it can be easily imported into spreadsheet programs and more analysis done there I tried but failed.So i wanna kown how to imported eio file into spreadsheet programs.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2023-01-03 10:40:52 -0500

The eio file is comma separated variable (csv) format and can be read by spreadsheet programs. In excel, select File/Open and browse to the eio file can click that file. You should see a pop-up like this:

image description

Make sure delimited is selected and click next. Then in the Delimiters box click comma. You can now choose Finish and the eio should open.

image description

edit flag offensive delete link more


I also find it useful to use a text editor with book marking capabilities (e.g. textpad) to copy only the lines I'm interested in (by searching for a specific object type, name or property) and then going thorough the above procedure.

willyJohan's avatar willyJohan  ( 2023-01-05 19:19:53 -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

1 follower


Asked: 2022-12-30 20:35:31 -0500

Seen: 64 times

Last updated: Jan 03 '23