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