I have previously described how you can Link Excel spreadsheet data into Revit (through AutoCAD).
But what if you want to semi-automate the process of editing Lookup Tables using Excel? The blog http://www.revitmep.es/ shows you how:
We explain how to create a lookup table for the families…
The biggest impediment there is import and export these files, we use a macro in Excel to streamline these tasks.
And here is a direct link to the macro-enabled Excel file:
Editor Lookup Tables.xlsm
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:
- Link Excel into AutoCAD DWG
- Link DWG into Revit
When you want to update the Excel spreadsheet in Revit, you have to:
- Save Excel spreadsheet
- Open AutoCAD DWG and update Data Link
- Save DWG file
- 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:
RevitCity.com | Importing Excel into Revit
- Save Excel File
- In AutoCAD – Insert – Data Link – new Excel Data link
- TABLE command
- From a data link – select Data Link, Ok
- Use 0,0 as insertion
- Save DWG file
- New Drafting View in Revit, link the DWG in Origin to Origin
- Its a two step update process whenever you change Excel. Save, in AutoCAD / update link, Save DWG, in Revit – reload. Done.
Check out the following link:
WhiteFeet public downloads
Among other things, you will find documentation that covers the following tools:
Revit Element Tools
Revit Family Tools
Revit Parameter Tools
Revit Database Link
Revit Sheet Manager
The License Agreement can be found at:
Here are some summaries of the individual tools (taken from the documentation):
Links to an Excel file or (less commonly) an Access database. Based on this
data, it creates or updates sheets in Revit as a bulk editing process. The tool
can also be used to export data, renumber sheets, and place views on sheets.
A relatively complex and highly developed program that can be the basis of a wide range of workflows. It can connect to either an Access or a SQL Server database and synchronize data in both directions.
This collection of smaller tools has been grouped together for convenience, but they serve different kinds of purposes. These include:
Placing unplaced areas and rooms.
Creating views, adding tags, and exporting images.
These tools support working with families and working with Excel:
Exporting detailed information about families to Excel.
Importing parameter values from Excel to control families in support of a computational design