If you have created an excel spreadsheet, you don't have a direct link straight into Revit out of the box. So using the Revit to Excel tool (Link XLS) you will now be able to link an excel spreadsheet into your model, which is an in demand feature for a lot of Autodesk Revit users, and a major productivity improvement.
It's a quick an easy process by selecting the excel spreadsheet and this will tool will create a dxf file.
Which can be linked by using the Link CAD option.
This then gets placed into your view.
With Key Parameter, you can define and complement shared parameters for Revit categories, based on a unidirectional link with an Excel spreadsheet with a certain structure (one "Key Parameter" and any number of dependent parameters).
Based on the value of the Key Parameter, values of dependent parameters from the Excel spreadsheet are added to the Revit project.
Using the Excel spreadsheet, it is possible to manage the elements parameter values in a Revit project from a single place.
By adding the key parameter and key value, Revit will read the excel spreadsheet and populate the parameters to the family as an instances or type parameter. You can also set the key value to all elements of selected categories.
Interested in watching the tutorial for 'Excel Link'? Then follow the link to go to our Graitec Advance PowerPack for Autodesk Revit 2016 blog post.
The Revit to Excel link has been greatly improved in the latest version of the tool giving even more options. To find out more join one of our Graitec PowerPack for Revit 2017 webinars or click on the image below to register your interest or get a license.
If you have any enquiries, please send us a message: