Exporting Electrical Panel Schedules to Excel

[williams_cory_a]

I am trying to export an electrical panel schedule to an excel sheet but even when the view is active the Big R>Exports>Reports> Schedule is greyed out. Is there a better way to export an Electrical Panel schedule to excel?

[GungorOzay]

Hello,

You can use the Dynamo. Just download Dynamo final version. And in dynamo you have to add Packages ; Data-Shapes, bimorphNodes .

Than, just download attach script and run in your project.

[Zsolt.Varga · Accepted solution]

Hi @williams_cory_a,

I was able to reproduce this issue - I am not sure, why this option is not available for electrical panel schedules, so I went on and started an investigation to let the product team review the current product design in this regards. 

The status of the investigation is documented here: 

http://knowledge.autodesk.com/article/Revit-Exporting-Electrical-Panel-Schedules-to-Excel

This link will be active in a couple of hours and will be updated with news as soon as available. 

In the meantime you might want to give this 3rd-party tool a chance:

Panel Schedule Exporter

Also: I found a similar wish for enhancement reported on the Revit Ideas page here: 

Allow Export and Import of Panel Schedule Templates and other model settings

Please, feel free to vote for that enhancement request or to add further ideas.

I hope, you´ll find this information and the tool helpful.

In order to point other users to this information I will go ahead and mark this post as a solution - but I want to encourage you to continue the discussion or give feedback about the tool above in this thread.

Best regards,

[Anonymous]

Hello, I am not very good with using Dinamo. Could you please be more specific about the procedure? Should I open the desired panel schedule first and then run this script thourh Dynamo Player or select the panel schedule from the Project Browser and then run the script? Either way I get empty Excel to open (and error message). What am I doing wrong?

Thanks

[GungorOzay]

Can you send your dynamo screenshot ? And be sure you have already dynamo package ; Data-Shapes, bimorphNodes

[Anonymous]

This is what I get when I open the panel schedule and run the script
through Dynamo. I am using Dynamo 2.0.1.5055 and Revit 2017. As a result,
Excel would open and it would be empty.
You can see I have add-ons already loaded.
Thanks

[image: image.png]

[GungorOzay]

i thing image not attached. Can you try again please ?

[Anonymous]

Here is the snapshot of my screen.
Thanks

[GungorOzay]

Sorry, but i still couldn't see your screenshot.  I thing you still didn't attached to here.

[Anonymous]

The reply on Autodesk portal takes me to Gmail and I attached the file but
it did not get through.
Do you have an alternate email that I can use?
Thanks
Vlade

[Ashkan_Kermanian]

If you have Bluebeam, you can export your panel schedule through File> Export>Excel

---

@williams_cory_a wrote:

I am trying to export an electrical panel schedule to an excel sheet but even when the view is active the Big R>Exports>Reports> Schedule is greyed out. Is there a better way to export an Electrical Panel schedule to excel?

---

[Anonymous]

how to solve this?

---

@GungorOzay wrote:

Hello,

You can use the Dynamo. Just download Dynamo final version. And in dynamo you have to add Packages ; Data-Shapes, bimorphNodes .

Than, just download attach script and run in your project.

---

[Anonymous]

---

@Ashkan_Kermanian wrote:

If you have Bluebeam, you can export your panel schedule through File> Export>Excel

---

@williams_cory_a wrote:

I am trying to export an electrical panel schedule to an excel sheet but even when the view is active the Big R>Exports>Reports> Schedule is greyed out. Is there a better way to export an Electrical Panel schedule to excel?

---

---

Interesting. I wasn't aware of this feature. I need to give it a try.

[fabiosato]

Hello,

You have to download the Dynamo packages, please check in the Dynamo forums.

[benjamin_miranda]

@Gungor.Ozay, tried the dyn file above but exporting i get a blank excel sheet (see short clip below). Appreciate if you can shed a light on this.

[benjamin_miranda]

Never mind I've sorted it by replacing "Element.Name" to "String from Object".

[GungorOzay]

Hello,

Uninstall your Data-Shape package. And download last Data-Shape Package. It will work.

[benjamin_miranda]

I just actually downloaded/installed the datashape package before this test.

[Anonymous]

Hi,

I found this trick.

1. place your panel schedule on sheet.

2.Export the sheet into PDF.

3.Open PDF in xchange Editor.

4.Save as .xls from file menu in xchange editor.

Done

Attached file is my output, which is as same as panel schedule in Revit.

[Michael.Meyers615]

2.5 years later, updated those nodes, and had to update the GetData to the new version but worked like champ! thank you sir!