I’m in the process of setting up schedules from excel to be imported into Revit. One thing I can’t work out is how to match the correct piece of equipment in the schedule to the correct piece in Revit. At the moment in the schedule, I have the following [image] The AHU-10-01 data is imported into …

Here’s how I’ve read in the schedules from excel [image]

This is my attempt at a solution at the moment, however it’s not working as I’m not really combining two lists like before, as two of the inputs are from Revit, not Excel [image]

Hi @voss836 Can you try choosing actual object Category (for example, Mechanical Equipment) instead of Tags in the Categories? In my opinion, the Tag itself would not have the parameters… The object category would have the parameters and Tag Family is set up to “read” & display the value of the pa…

@Chandrasekar_Rajaman what I realised I need to do is to have the schedule with all the equipment names, and then manually name each piece of equipment so it matches the schedule names, and then it will be able to automatically import the data. But I can’t find a way to tag equipment with text, it a…

Hi @voss836 Can you upload the following? Revit file (2016) Family file (rfa) of the equipment being used (if not loaded already within the file) Excel sheet with parameters or a table showing Revit parameter name & the corresponding value to be filled from Excel…

Hi @Chandrasekar_Rajaman I’m running Revit 2017 so unfortunately you won’t be able to open it with 2016.

Hello, quick answer: you will probably need to link your datas using GUID, see this for instance: [image] Excel to rooms by ID Revit The elements IDs can change but the GUIDs are stable. There is a node called Revit ID in the Hot Gear package that will give you these GUIDs…

I’ve had a bit of a look and don’t really understand how the GUID’s will work. From what I understand is that they are unique to the object itself regardless of who’s using the file. But let’s say I have 5 AHU’s in a Revit model, and get the GUID’s for each. How will each data column in excel, corre…

@voss836 My 2 cents! Guess it will be a 2-step process: (Similar to the link with room ID posted by @Yna_Db ) First step would be extracting the AHU ID and the Unique Key (GUID) to Excel Use that as a starting point to populate the excel info based on the AHU ID Agree that most of the work is don…

@Chandrasekar_Rajaman the problem with doing that is I am given the excel sheet from a 3rd party, so my aim is just to upload into Revit, not the other way around. I can easily create a parameter in excel that holds the name of the equipment (user inputted), and then from there I basically want to…

Excel schedules to Revit

Revit

voss836 February 2, 2017, 2:30am 2

Here’s how I’ve read in the schedules from excel

Import electrical panel schedules to Revit using Dynamo

Topic		Replies	Views
Writing excel data into Revit Revit	2	1288	February 6, 2017
Excel data integration with Revit schedules	16	378	September 5, 2024
Schedules to Excel and Excel to Revit using Dynamo Revit revit , excel , dynamo	13	16932	December 4, 2021
Import data from Excel to Revit Revit excel , dynamo	2	343	January 9, 2024
Link excel revit - large schedule Revit excel	7	2351	December 19, 2018

Excel schedules to Revit

Related topics