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