RTV Tools

Thursday, October 13, 2011

Link Excel spreadsheet data into Revit

There is a way to link Excel data into Revit, and retain the ability to 'update' that data when it changes.  Essentially, it involves using AutoCAD as a middle-man to get the job done.  In simple terms:
  1. Link Excel into AutoCAD DWG
  2. Link DWG into Revit
When you want to update the Excel spreadsheet in Revit, you have to:
  1. Save Excel spreadsheet
  2. Open AutoCAD DWG and update Data Link
  3. Save DWG file
  4. Reload DWG link in Revit
This all works surprisingly well.  Check out the video below as a demonstration:



Here is a little diagram of the concept:



Process via
RevitCity.com | Importing Excel into Revit



In words:
  1. Save Excel File
  2. In AutoCAD - Insert - Data Link - new Excel Data link
  3. TABLE command
  4. From a data link - select Data Link, Ok
  5. Use 0,0 as insertion
  6. Save DWG file
  7. New Drafting View in Revit, link the DWG in Origin to Origin
  8. Its a two step update process whenever you change Excel.  Save, in AutoCAD / update link, Save DWG, in Revit - reload. Done.

4 comments:

  1. This is a great workaround. I used it to link together some large beam schedules so I could modify the look of them with AutoCAD. Note that you can also export schedules from Revit to AutoCAD (ie in the case of the smart beam schedules) by using the export as .txt from the main menu. Then open the text file with Excel and save as an Excel file. From there pick up the procedure outlined above.

    ReplyDelete
  2. What about preserving the border format as shown in the dwg?

    ReplyDelete
  3. Interestingly, there is a commercial (paid) set of tools that essentially use this concept:
    DotSoft Revit Add-on Utilities

    ReplyDelete
  4. One issue is that if this imported table is appearing next to native Revit Schedules, the text size between AutoCAD and Revit is altered during the import. If you work with people that are concerned about text size integrity on the sheets, its a bit of a headache.
    Anyone find a workaround for this?

    ReplyDelete