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

how to edit idf files using the excel software?

asked 2018-11-14 04:10:48 -0500

Philip Caesar Ebit's avatar

Hi all, I am doing building energy modeling using energyplus. The data that I gathered is many because of the big building that I modeled. Now, I found difficulty in editing and making schedules in the idf editor because of the many data. Is there a way I can edit values or input values using the MS Excel software? I would like to ask for help. Thank You and God Bless.

edit retag flag offensive close merge delete

3 Answers

Sort by ยป oldest newest most voted

answered 2018-11-14 09:04:58 -0500

You might want to use Schedule:File object instead. See here

edit flag offensive delete link more


thank you for your advised Sir Jason, I will try working that way.

Philip Caesar Ebit's avatar Philip Caesar Ebit  ( 2018-11-14 18:32:32 -0500 )edit

answered 2018-11-14 04:51:22 -0500

updated 2018-11-14 04:52:23 -0500

You can find plenty of ideas here and here.

edit flag offensive delete link more


thank you Adam for you answer. I downloaded the macro file and installed it in my excel software, but when I used it there is an error in copying to clipboard. Is there any way how to fix this? And one thing also, I see in the program that it need this References: Microsoft Forms Object 2.0, needed for using the Clipboard, what will I do to have this?

Philip Caesar Ebit's avatar Philip Caesar Ebit  ( 2018-11-14 18:31:08 -0500 )edit

If all you need to edit in the IDF is the schedules, go with Jason's suggestion. That is a more straightforward way to do it.

adambgnr's avatar adambgnr  ( 2018-11-15 02:49:21 -0500 )edit

answered 2019-09-24 16:28:34 -0500

PeterSchild's avatar

Try EpXL (EnergyPlus-Excel). It's an Excel-based alternative to both IDF Editor and EP Launch. It can handle large models. EpXL's homepage is

edit flag offensive delete link more

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: 2018-11-14 04:10:48 -0500

Seen: 793 times

Last updated: Nov 14 '18