How to Transfer Dynamic Data from AutoCAD to Revit (the BIM Way)?

There is a big problem with data coordination between very different platforms such as AutoCAD and Revit. This question arises too often not to search for a good solution for it.

I’ve searched for a method to transfer some dynamic data from AutoCAD to MS Excel and Data Extraction method worked like a charm. At the time our team worked hard on a new tool called Excel2Revit which is a great helper in data coordination between Excel and Revit. You should see where I am getting here.

I’ve made a dynamic data link in AutoCAD by using some blocks and a table which updates if there are some blocks inserted (it can also work with xrefs) or these are changed. This information is transferred to Excel sheet. So the first part of connection is made.

 

Looking at the other side we have Revit with not too much of dynamic data control in Excel so here we have an issue. Well… We had an issue, because AGA CAD has developed a tool that provides bi-directional coordination and linking of MS Excel files. So the thought is that we have a solution, if we have AutoCAD file which can update an Excel file and we have Excel2Revit add-on which constantly checks for changes and offers an update in Revit if a change in *.xls file is made.

HTTDDFAR_AutoCADXLSRVT

Setup is very easy.

  • Make a link of a table in AutoCAD and update it.HTTDDFAR_Excel2Revit_Create Table
  • Using Excel2Revit create a table in Revit with the Excel file that you use in AutoCAD and it will be successfully linked.

Now as you go to Excel2Revit Manage Table it will check if there are any changes made in Excel files. It will ask to Update if there is something changed. Excel2Revit will work with multiple Excel sheets, so you can make as many links as you want in one project and it will check for changes in all of them, so that makes a good data coordination workflow.

The simple solution solves a lot of problems. That’s what BIM is all about. Try it by yourself and find another interesting ways to control your data.

Subscribe
Never miss important updates

Related blog posts

All posts

Be.Smart software released for Revit 2025

Productivity solutions from ARKANCE Be.

Read more

Enhanced Agacad product technical documentation: See what's new

Great news for our clients and trial users: we have remade all the technical documentation of our s...

Read more

ARKANCE IP software range streamlined for power and efficiency 

Agacad, an ARKANCE company, has refreshed its portfolio of products for process improvement in digi...

Read more
Copyright © 2013-2024 AGA CAD, UAB. All rights reserved | Privacy policy