Linking Revit with Excel

[chris.harrison]

My technical question is as follows:

                "If you had a typical drawing of a bridge in Revit and had an excel spreadsheet linked to that drawing with dimensions of pier breadth in an excel cell, could you change the dimension in excel and have it automatically update the Revit drawing?"

Any help would be appreciated,

Kind Regards,

Chris

[Chris.Aquino]

Using the DB Link extension, you should be able to make changes to the database, reload the database, and that information should update the project file.

The following section of the help has more information about the DB LInk Extension:

Autodesk Revit DB Link

[jford]

I have a schedule in Revit that I have been exporting to excel and using pivot tables to manipulate that information.  When I make a change in Revit, I would like to be able to update the excel file without having to export a new file and having to perform all of the same formatting, filtering, pivot table options, etc.  Can I do this with DB?  I tried to create a database and it was not clear at all.  I am running on a x64 bit machine.

josh

[alex.kaplan · Accepted solution]

I noticed this old thread still gets a lot of attention. If you're here looking for updated information about a Revit to Excel round-trip workflow, please see the following:

DBLink Help guide for 2019

https://knowledge.autodesk.com/support/revit-products/learn-explore/caas/CloudHelp/cloudhelp/2019/EN...

Viveka's shortlist of add-ins

https://forums.autodesk.com/t5/revit-architecture-forum/best-revit-schedule-to-excel-add-in/m-p/7123...

If you want to roll up your sleeves and put together a custom solution, Dynamo makes it easy.
This video from ArchSmarter shows how to use out-of-the-box Revit + Dynamo for a Excel import/export.
Be sure to use the Revit Unique ID for reliable results.

[luisPDAN6]

To add to this thread here goes a link to a spreadsheet like editor for Revit available in the Autodesk App Store. It has many of the Excel productivity features like paste to multiple cells, find and replace, direct sorting and filtering of columns.

Database Editor for Revit

https://apps.autodesk.com/RVT/en/Detail/Index?id=5058771955362580361&appLang=en&os=Win64