Exporting Multiple Revit Schedules to a Spreadsheet at Once Using Dynamo
May 28, 2018 •
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 Dynamo
Related Posts
Data Quality: What is it and why is it important?
We often hear, even on a project with a theoretical BIM process, the comment: “Our contract is to deliver a...
LOD – Level of Data, Level of Development, Level of Detail or just Level of Disorder?
Level of Detail – LOD for short – is a hot topic. As Building Information Modeling (BIM) becomes more prevalent...
Key considerations for Owners before embarking on a Building Information Management (BIM) project
Want to learn more about Building Information Management (BIM) for owners and facility managers? You’ve come to the right place....
Databases vs Spreadsheets: What to consider for asset data and document collection
Managing asset data in Excel can only take you so far. So, what does your team actually need to stay...
Fraser Health Authority, driving BIM data through to facilities
Forethought and investment in a BIM process transforms how, when and who collects asset information for a leading health authority....
Digitally Delivering Owners Requirements
Geraldine Rayner, Director of Summit BIM will present 'Digitally Delivering Owners Requirements' with Aaron Akehurst, Manager, Construction Services of PCL...
Summit BIM to work in collaboration with the BC Government
Globally, countries are integrating BIM-based processes into the AECO industry. In many countries, the adoption of BIM is driven by...
What does Facilities Management need from a Digital Twin?
What is a digital twin? Another industry catch phase with no definition! It sounds great and conjures up an image...
