Export Data to an Existing Excel Template

Ever wondered how to export data from Revit or any source for that matter to an existing Excel file where you already have some formatting done? It can be a bit winding task to first export your data to an intermediary blank Excel sheet and then copy/paste or link the cells or range to your original Excel template file.

This workflow here does not require any custom node or high-level coding — just a couple of out-of-the-box nodes to get your job done in a few seconds.

A sample Excel workbook with some formatting and formula applied

This Dynamo graph could be used in any Dynamo for Revit version. List.Combine acts as a function.

Output Excel sheet with the data filled in respective places

This is how you can save precious time to export data to any existing Excel file without making any modifications to the formatting. You can re-run the Dynamo script after changing input data in order to make any further changes.