I have attached an Excel Spreadsheet that I am trying to research whether or not it is reasonable to try and write a series of graphs that can attempt to re-create this spreadsheet’s data just by using Revit and Dynamo? Obviously, using shared parameters and schedules in Revit can get me mostly the…

Dave, I have been meaning to try this for a while now. After a really quick and easy sample it works. Based on the amount of formulas your file has this will be a very tedious task but if you are going to be using it a lot it might be worth it. Excel will convert strings into formulas when dynamo w…

Maybe, with a fair bit of work You’d could be better off with a reporting tool that knows about grouping, subtotals and totals rather than trying to do it in Dynamo/Excel This example uses the Revit ODBC export and Access to generate the reports. To update the report is a 2 step process: Run th…

hmm…maybe, but I forgot to mention I have to provide an Excel spreadsheet as one of the deliverables and that’s just one more process to add to the list of software to hook into, aside form the fact that I know nothing of ACCESS.

Konrad, Thanks for the link … Unfortunately that thread is really not helping with the process and logic here.

please be clearer about what you want Import Excel spreadsheet into Revit? Create Excel spreadsheet from data in Revit?

Steve, Your option 1 is the route I am going to run to ground. While option 2 is steamlined, but the Excel file data will not be constant for this exercise (640 buildings of data)! Thank you everyone for your input and ideas! I will update and show progress as I work through this!

Dave, In that case I want to share this node from clockworks. “Character.FromNumber” This will convert numbers to letter. Might be helpful for figuring out the column depending on how you are gathering the information. You may already know about it but figured I would let you know.

Ahhh…now that is a node I have not explored yet! I can see where that will be handy here!

Is this Excel spreadsheet possible to produce in Revit and Dynamo alone?

FAQ

Konrad_K_Sobon December 1, 2016, 2:06am 4

read this perhaps: Excel to Revit Key Schedule Help

Topic		Replies	Views
Is their a way to import excel spreadsheet Data in Revit Sheet? Revit revit , excel , dynamo	6	1854	February 14, 2018
Revit Excel Interoperability Best Workflow Revit	2	946	December 19, 2018
Dynamo → Excel Revit excel	2	136	November 3, 2023
Room Data Sheet creation in Revit based on Excel Spreadsheet Help! Revit revit , excel , dynamo	1	79	June 24, 2025
Link Excel to Revit Revit	1	908	December 20, 2016

Is this Excel spreadsheet possible to produce in Revit and Dynamo alone?

Related topics