There are a myriad of ways to link spreadsheet data into Revit, including numerous addins to import and export data to Excel. There is also the Google Sheets connection. Recently, the BIM Troublemaker posted about using Dynamo because, as he puts it, “this was the tool that could give me an on the fly, bi-directional excel link…”
I enjoyed reading the post, because it explains Dynamo use starting from a basic level, and yet shows a practical example of something that can be built on and adapted to suit your needs.
Excel out dyn
The working example uses Dynamo commands to extract data from Revit family instances into Excel, and then push data from Excel back into Revit. Nice job!
Daniel Monsén has created one of those addins where you just have to say “this makes sense”. The key feature of Bimframe Connect? It allows users to import and export data from Revit to a Google Spreadsheet.
The overall concept is that you can export data to a Google Spreadsheet, collaborate using a web client or mobile device, then import the data and update the Revit model. Collaborators obviously don’t need Revit – just access to the Google spreadsheet.
Personally, I love the idea. The more transparent the Revit building database is, the easier it is to add intelligence to the model, share the model, and detect design problems.
The above video includes the following info: Email: firstname.lastname@example.org to get trial key.
If you are having problems with the ‘Copy Spreadsheet’ utility, it is likely because you are running 64 bit Revit or you have recently updated Revit. If you haven’t heard of this tool, it is a simple program made in Autohotkey, and it automates the ‘copying’ of data from a spreadsheet into a Revit schedule. The Revit schedule will need to be a key schedule, and you will need to add the columns and rows before starting the utility.