x
WE'RE HERE TO HELP | COVID-19 RESOURCE CENTER

As COVID-19 continues to impact everyone, Microsol Resources is committed to helping our customers and communities. Need up-skilling and training? Need help to keep your team working together and collaborating?   LEARN MORE >

Menu

From Revit to Excel and Back

By Microsol Resources | BIM

Excel and similar spreadsheet programs have always been the mainstay of data entry and analysis operations. Even with access to more sophisticated applications, most architects and engineers, still prefer to modify parameters of projects and components with a fluid interface such as a spreadsheet so that they can take the data elsewhere and do interesting things with it.

The Revit Project being a database, always lent itself to extension using Excel. Dynamo made it even more accessible. This recipe is a small demonstration of all the pieces needed to not only extract Revit component parameters to Excel but also push back updated data back to Revit after performing operations within Excel.

Surprisingly, the biggest challenge turned out to be not the actual connection to Excel, but the smaller nuances of how the parameter data gets modified during the process of transferring between the two applications. If you would like to skip the explanations, you can download the dataset here.

completeDefinition

Check out the complete recipe at the work-in-progress GitBook (which, by the way, is an awesome platform)

INDUSTRIES:

About the Author

Microsol Resources delivers integrated solutions that help customers design, simulate and analyze their ideas, increase operational efficiencies and maximize their return on investment in their technology solutions.

BACK TO TECH RESOURCES