This is a classic one! You’ve probably come across some version of this tutorial if you made any search about Dynamo. Let me show you how you can do it in Grasshopper🦗. In this video, I created a pretty basic script. This script reads sheet data (sheet number, sheet name, etc…) from Excel then creates new sheets in Revit using this data. After the sheets have been created, the script updates specific sheet parameters using the Excel data.

This is a pretty standard workflow. A lot of the times we prefer working with Excel data just because how easy it is to generate rows of data. Lets jump into how we can leverage the power of Excel within Grasshopper.

📌
Revit and Grasshopper files used in the tutorial can be downloaded from the button below👇.