Excel Data Map with existing families


How to Link the Excel Data with Existing Revit Families.

I have an excel data with Foundation Name and Size and coordinates. Now how to mapping xls “Foundation type name” with revit “Family type name” to generate the Foundation in revit.


Image for your reference @Alban_de_Chasteigner ,@Marcel_Rijsmus

1 Like

i don’t understand what you are trying to do, can you explain further and show us the excel sheet.
it looks like you are mixing up type properties and instance properties, and you say you have coordinates in your excel file , yet you provide us with a picture that shows static values from a code block.


This is the excel data

Column Name X Coordinates Y Coordinates Z Coordinates Rotation Foundation Name
C1 -6796.93214 15605.30061 1500 10 1800 x 1200 x 450mm
C2 -1796.93214 15605.30061 1500 20 2400 x 1800 x 450mm
C3 3203.06786 15605.30061 1500 30 1800 x 1200 x 450mm
C4 13203.06786 15605.30061 1500 40 2400 x 1800 x 450mm
C5 8203.06786 15605.30061 1500 50 1800 x 1200 x 450mm

This is the Node.


i can see you made a lot of progress, this picture is completely different from the first.
and that all in a day!
why not work on it one more day .
the list.map node gives you the names of the families, try to match those with a list of actual family types

Hi @Marcel_Rijsmus

Is dynamo have any node, which can map the Excel and actual family types? or custom node is the last hope.