To begin I am working in Revit 2024 and using Dynamo v.2.18.1. I have a schedule in Revit that is already scheduling families that have been placed in a model. The schedule is organized by “fixture” & “face”. I have added additional fields to the schedule that correspond to an excel file that conta…

Look into Dynamo dictionaries. If no one beats me to it i can post an example tomorrow.

The thing is to connect the right information to the right object. You’ll have to think of a way to do that, because they all look sort of the same in a list. I use the objects Id or UniqueId to make sense of what i’m doing before it get’s chaotic. If you can find another unique combination of th…

[image] tthalerBX8Y6: read the Revit schedule and create a list of the families that are within that schedule [image] To quote @Nick_Boyts [image] Importing Excel Data into a Revit Schedule via Dynamo Keep in mind a Revit schedule is just a view of project elements and their properties.…

If I am understanding it correctly what you have shown above will populate which ever schedule column I choose with the data from the excel file? Ultimately what Id like is for Dynamo to grab the data from the excel file based on a combination of the “fixture” & “face” that is being scheduled in Re…

The easiest thing to do is combine your two values into one (i.e. Fixture + Face = FixtureFace) so that you can create a dictionary of all 400 unique combinations as single item keys. Then you just get the two values from each element, combine them into the singular combination, and use your diction…

@Nick_Boyts beat me to it. That is exactly what i wanted to suggest.

I am very new to Dynamo so I’m going to need a little more explanation than that. Would I have to combine the two values together in just the excel file or in Revit as well?

You would only combine them for the dictionary. You would still have individual values in Excel and Revit, but would combine them to have a singular key for each dictionary item. I suggest you look into dictionaries to get a better understanding of how they work and what they do. That should hopeful…

With this example and my previous post you should be able to figure it out. [image] [image] tthalerBX8Y6: Would I have to combine the two values together in just the excel file or in Revit as well? In Dynamo, but the values have to exist in the Excel file as well. Start setting it up and …

Advanced users understand this This makes no sense to beginners DS is blahblah to them

Excel data integration with Revit schedules

bvs1982 August 28, 2024, 7:34am 4

To quote @Nick_Boyts

So you don’t need a Schedule to populate data from Excel.

Topic		Replies	Views
Import sheets from excel with dynamo Revit	9	2438	December 15, 2017
Revit Excel Interoperability Best Workflow Revit	2	958	December 19, 2018
Create Revit Schedule from Excel Data Revit revit , excel , dynamo	0	479	February 17, 2021
Revit Schedule to Excel Bidirectional link Revit	13	11041	August 10, 2019
Excel import to revit Revit dynamo	2	2828	August 2, 2017

Excel data integration with Revit schedules

Related topics