Excel to Revit Compare Elements by Parameter


I wasn’t sure how to name the title, but here goes my question:

i’m basically trying to get all the true answers shown in the image to push into the air flow rate parameter based on the list below, these are taken from excel.
However I need the references to match the ones in the project so it pushes the correct air flow into the correct air terminal… I feel like I am very close with the end of the script below, but just can’t seem to tie it up,

Find Air Terminal Ref Part 2.dyn (15.8 KB)


Just realised the entire selection of the right equipment based on matching with the excel references to the Revit references isn’t working either, got myself lost. Feel free to delete this post.


I think the problem is that the matched list doesn’t give you the right order to apply SetParameterByName function.
However, if you consider using python script node, Core code is drafted below:

# data from excel
# use dynamo nodes or hard code it
air_dict = {
    'SG/01/04' : 0.370,
    'SG/01/05' : 0.635,

# find all air terminal instances
elements = doc.filterElement(...)

# iterate over all elements
for ele in elements:

    # get the air flow rate parameter of current element
    flow_rate = ele.get_Parameter(...)

    # compare the value from excel
    if flow_rate in air_dict:

    # find a match, set the parameter of current element


Is it something like this you are looking for?
I cleaned you graph, added a comparison script and insert a unit converter, which I am sure would be you next question :slight_smile:

Find Air Terminal Ref Part 2.dyn (14.9 KB)

#revit data
elements = IN[0]
rvtId = IN[1]

#excel data
xlsId = IN[2]
xlsFlow = IN[3]

t1, t2, t3 = [], [], []
for xid, flow in zip(xlsId, xlsFlow) :
	for rid, elem in zip(rvtId, elements) :
		if xid == rid :

OUT = t1, t2, t3

Lists matching
Set Family Instance Type by an Excelsheet (Problem wit Sort List by Key)
Changing room names in Excel - strange results
Excel to Revit using Conduit Run ID as a Key
Excel to Revit using Conduit Run ID as a Key


This post and many other posts I recently have replied made me realize that there is a need for a node that can filter two lists by keys… I have made this node as generic as possible so it may be used as widely as possible. In this case is it Revit and Excel data that is filtered by key. The node “List.FilterListByKey” is now a node in the “DanEDU Dynamo” package.