Revit is a leading software program for building information modeling (BIM) used by architects, engineers, and construction professionals. It has the ability to create schedules that show the data contained in the model such as materials, quantities, and properties. However, sometimes it is necessary to export the Revit schedule to Excel for further analysis, formatting, or sharing purposes. In this article, we will discuss how to export Revit schedule to Excel in a few simple steps.
Step 1: Open the schedule in Revit
The first step is to open the Revit schedule that you want to export to Excel. Go to the View tab and click on the Schedules dropdown menu. Select the schedule you want to export from the list.
Step 2: Customize the schedule
Before exporting the schedule, you may want to customize it to display only the data you need. You can do this by adding or removing fields, sorting or filtering data, and changing the appearance of the schedule. To do this, click on the Modify Schedule/Quantities button on the ribbon.
This will open the Schedule Properties dialog box where you can make changes to the schedule. Click on the Fields tab to add or remove fields. To sort or filter the data, click on the Sorting/Grouping or Filter tab. To change the appearance, click on the Formatting tab.
Step 3: Export the schedule to Excel
Once you have customized the schedule, you are ready to export it to Excel. Go to the File tab and click on the Export dropdown menu. Select the Schedule/Table option.
This will open the Export Schedule dialog box. Choose the location where you want to save the Excel file and give it a name. Select the file format as Microsoft Excel (*xls) and choose the options you want such as whether to include headers or footers, whether to merge cells, and so on. Click OK to export the schedule to Excel.
Step 4: Open the Excel file
Finally, open the Excel file to view the exported Revit schedule. You can further customize or format the data as desired.
Conclusion
Exporting Revit schedule to Excel is a straightforward process that can be done in a few simple steps. By customizing the schedule and exporting it to Excel, you can analyze, format, and share the data in a more flexible and convenient way. This can save you time and effort in managing and presenting the information contained in the Revit model.