Here is an interesting idea from Daniel Monsén: in the video below, he describes using bimframe connect (which I previously posted about a couple of times, including here) to translate data for a Revit project.
In simple steps:
- Export a given schedule (such as rooms) using bimframe connect addin to Google Sheets
- Use the googletranslate formula to translate the data from the source to a given target language
- Copy the translated over the top of the original source data
- Import the translated data back into Revit using bimframe connect
The one comment I would make in addition to the video embedded below – if you want to quickly apply a formula to an entire column worth of data in Google Sheets, you should definitely use ARRAYFORMULA. If you put an array formula in the top row of a given column, it will apply itself to every cell in that column. For example:
=ArrayFormula( GoogleTranslate( B2:B ; “en” ; “nl” ) )
From: Daniel Monsén
Subject: Translate a Revit project into another language.
I hope everything i fine.
I just want to see if you seen our trick to translate a revit file to another language, using bimframe connect.
Maybe something for your blog?
Med vänliga hälsningar / Best regards
Sr BIM advisor
We use Google Drive a lot now, particularly Google Sheets. The power of a shared spreadsheet cannot be underestimated in the AEC world.
Now, imagine if you could directly export data from Revit to a Google Sheet, edit it, and then import the changes directly back to Revit. Imagine if you could share that spreadsheet to other team members who may not know anything about Revit, but who can modify and update schedules with ease? Yep, this just happened with Bimframe Connect… screenshots below.
Export from Revit to Google Drive
View and Edit on Google Sheets
Click import to bring the changes back
Changes are highlighted to show you what will be updated
Viewing the updated model in a Revit schedule
Download v1.0.0 at:
BIMFRAME community is here:
shop is here:
Google Plus site:
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.
Download the version 0.8 beta trial add in here:
There is a series of tutorials on Youtube here: