Skip to content

Exporting Multiple Revit Schedules to a Spreadsheet at Once Using Dynamo

This article describes how to use Dynamo to export multiple schedules at once. Exporting schedules can be tedious using the traditional Revit export dialog. If you have to export more than a couple of schedules at regular intervals during design, this can be a great opportunity to use Dynamo to automate. Like Google likes to say: Don’t hate, automate!

  • Collect the schedules you want to export using Dynamo. In this example, we are presuming that we don’t want to export all schedules in a project, but only those that have a pre-defined prefix of our choice. The easiest way is to use the All Elements of Type node and feed it the Schedule Views (Element Types node) from the project.
  • Use the List.FilterByBoolMask node to use the defined prefix to reduce the entire set of Revit schedules to those you are interested in exporting.
  • Generate a list of file paths by combining the start of the path and schedule prefix, the schedule name and the file extension (.csv for comma separated values).
  • Use the ScheduleView.Export node and configure settings using the ScheduleExportOptions.ByProperties node.

The following video describes the entire process. Sample file for download here (Dynamo 2.0).

Posted in
Edwin Guerra

Edwin Guerra

Edwin is a BIM Consultant with Summit BIM Consulting Ltd., a leading provider of BIM consulting services based in Vancouver, BC. Edwin brings to his projects advanced skills in data visualization, workflow development, workflow implementation, automation, research, project management and communication. He believes that there is great opportunity within the AECO industry to streamline processes and workflows to deliver high performance buildings.

Leave a Comment

  • This field is for validation purposes and should be left unchanged.