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

Problem with spreadsheets in EnergyPlus

asked 2019-05-06 16:31:36 -0600

Telis's avatar

updated 2020-01-25 18:23:32 -0600

Hello. I am using the EnergyPlus for energy simulation of a building. The problem I have is with the format of the outpouted files and especially with spreadsheets. I am running E+ and at the end I am unable to process the data. An example of what my excel outputs seem like is the following image. I don't know what to do please help me, I have to finish my diploma thesis. Thanks

edit retag flag offensive close merge delete

2 Answers

Sort by ยป oldest newest most voted

answered 2019-05-07 10:44:54 -0600

Binghang's avatar

updated 2019-05-07 10:47:55 -0600

you also can split the data in excel

  1. Select the data range in column A
  2. Start from [Data] menu > >[Data tools] tab >[Tex to Columns] button> choose "Delimited" , next >choose "comma" as delimiters, finish.

refer to

edit flag offensive delete link more

answered 2019-05-06 18:15:26 -0600

santoshphilip's avatar

Try importing it as a CSV file into excel

edit flag offensive delete link more


It worked! Thank you. I imported the csv file via the data tab ''from text'' and the problem was fixed

Telis's avatar Telis  ( 2019-05-06 18:38:24 -0600 )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: 2019-05-06 16:31:36 -0600

Seen: 422 times

Last updated: May 07 '19