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.

Share on Facebook

Tweet

Follow us