Revit + Dynamo + Excel: Through a ‘Key Schedule’ directly import any Excel table into Revit using Dynamo:
Have you ever had to enter a photo (.png, .jpg format, etc.), from an Excel table because you couldn’t create it as a “Schedule” within Revit?
This is usually quite annoying, slow and often the picture loses quality looking very bad on the sheets and final plans, not to mention that if you have to update the table “n” times, you have to take the picture again and reinsert it in the sheet for each change made.
Through a small trick using a Key Schedule, we will import any table directly from Excel.
We will show you step-by-step the whole process in Revit and the routine in Dynamo that imports all this data directly instantly:
Step 1: We have the next table of the calculation of drinking water used by the Sanitary Engineer, in it, the hydraulic calculations are made and placed in the next table that is shown in the image inside the red box.
Step 2: Once we know which table to import into Revit, we have to perform the following step inside: Create a “Key Schedule” with the same name and number of columns (or parameters) that are in Excel as shown below. It is important to verify that our “Key Schedule” and the name of the Excel “Sheet” are the same since Dynamo searches for the information through this parameter.
First, we create a new “Key Schedule” like any Element Category. We choose an “Analytical Links” as it is an element that is rarely used but can be created with any Category.
Step 3: Once the table is created, we will create the parameters or columns:
According to our configuration in Dynamo, the parameters created for the “Key Schedule” must be “Text” type. So you can enter any type of format whether numbers, letters or symbols.
Step 4: Once all the parameters have been created, we proceed to execute the routine. It is not necessary to enter the same name of columns that we have in Excel. It is only of interest the same number (12 columns in this example), and the name of the parameter can be modified later as needed.
Step 5: Meanwhile, now we know which table to import into Revit, we use the following routine. You only need to execute it and the next window will appear where you define what inputs to give it: “FileExcel”, “Schedule/Sheet”, “ColumnExcelLetra”, “FilaExcelInicial”, “FilaExcelFinal”.
After we entering the necessary data, we execute and wait…
Automatically the same Excel data will have been entered as a “Schedule” in Revit, which allows you to manipulate the sheets and get something of higher quality and editable if you have to update the table several times.
To see the explanation step-by-step, watch the video here:
Developer: 👨💻 Luis Alonso Otero Seminario
Email: 📩 firstname.lastname@example.org
Consulting: 📍 www.dynoscript.xyz