How to Add Model Properties Using Excel Spreadsheets in Revit
1. Start by creating a new project and loading the required models into it. Place each instance individually and label them with sequential numbers. To keep things organized, draw a reference plane and position the models on it; this will help avoid confusion.
2. Next, create a new schedule (detail table). Add the necessary fields you want to include and set the sorting and grouping options to list each instance separately.
3. Use the Olive Mountain Quick Model plugin and select the GLS Civil Engineering option to export the schedule to Excel.
The exported schedule will look like the example shown below. Since some model information has already been added, you can export it directly without re-entering those details.
4. Open the exported Excel file, go to the Review tab, remove worksheet protection, and enter the password provided.
5. Fill in the additional information required in the schedule, then save and close the file. Import the updated table back into Revit through the schedule interface. After the import is successful, close the schedule.
6. Finally, save the model as a library family, selecting the appropriate family to save.
7. This method is especially useful when dealing with large workloads. It allows you to efficiently add attributes to the model. You can see a comparison of the model before and after adding properties in the image below.
【 Related Skills 】
How to Generate Schedules and Detailed Lists in Revit
Must log in before commenting!
Sign Up