topic Exporting Electrical Panel Schedules to Excel in Revit MEP Forum

Exporting Electrical Panel Schedules to Excel

williams_cory_a — Mon, 05 Feb 2018 16:26:18 GMT

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?

Re: Exporting Electrical Panel Schedules to Excel

GungorOzay — Mon, 12 Feb 2018 14:07:50 GMT

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.

Re: Exporting Electrical Panel Schedules to Excel

Zsolt.Varga — Mon, 12 Feb 2018 16:22:08 GMT

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,

Re: Exporting Electrical Panel Schedules to Excel

Anonymous — Fri, 29 Jun 2018 00:35:01 GMT

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

Re: Exporting Electrical Panel Schedules to Excel

GungorOzay — Fri, 29 Jun 2018 05:50:04 GMT

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

Re: Exporting Electrical Panel Schedules to Excel

Anonymous — Fri, 29 Jun 2018 17:17:26 GMT

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]

Re: Exporting Electrical Panel Schedules to Excel

GungorOzay — Sat, 30 Jun 2018 07:02:46 GMT

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

Re: Exporting Electrical Panel Schedules to Excel

Anonymous — Mon, 02 Jul 2018 15:39:26 GMT

Here is the snapshot of my screen.
Thanks

Re: Exporting Electrical Panel Schedules to Excel

GungorOzay — Mon, 02 Jul 2018 15:52:44 GMT

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

Re: Exporting Electrical Panel Schedules to Excel

Anonymous — Mon, 02 Jul 2018 15:55:26 GMT

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

Re: Exporting Electrical Panel Schedules to Excel

Ashkan_Kermanian — Fri, 15 Mar 2019 17:00:24 GMT

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?

Re: Exporting Electrical Panel Schedules to Excel

Anonymous — Tue, 28 May 2019 09:59:59 GMT

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.

Re: Exporting Electrical Panel Schedules to Excel

Anonymous — Tue, 28 May 2019 20:32:03 GMT

@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.

Re: Exporting Electrical Panel Schedules to Excel

fabiosato — Fri, 07 Jun 2019 00:12:23 GMT

Hello,

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

Re: Exporting Electrical Panel Schedules to Excel

benjamin_miranda — Mon, 25 Nov 2019 10:38:28 GMT

@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.

Re: Exporting Electrical Panel Schedules to Excel

benjamin_miranda — Mon, 25 Nov 2019 12:06:23 GMT

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

Re: Exporting Electrical Panel Schedules to Excel

GungorOzay — Mon, 25 Nov 2019 12:14:31 GMT

Hello,

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

Re: Exporting Electrical Panel Schedules to Excel

benjamin_miranda — Mon, 25 Nov 2019 12:48:30 GMT

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

Re: Exporting Electrical Panel Schedules to Excel

Anonymous — Tue, 25 Aug 2020 14:03:55 GMT

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.

Re: Exporting Electrical Panel Schedules to Excel

Michael.Meyers615 — Fri, 04 Sep 2020 00:03:08 GMT

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