Import Excel Into Revit

Irich
Enthusiast
Enthusiast

Import Excel Into Revit

Irich
Enthusiast
Enthusiast

I am reasonably certain that you cannot directly import an Excel Spreadsheet into a Revit drawing so what could I do as a work around?

 

We used a spreadsheet similar to the screen shot below to show elevations of embeds. There is not a lot of intelligence built into it (maybe some simple formulas) but I not sure how to create this table or something similar inside of Revit.

 

Capture.JPG

 

 Beyond that, if I can find a way to make the table more intelligent and pull information from the model- floor elevations, form elevations, etc. then I would be golden!

 

Thanks for the help!

 

 

Reply
Accepted solutions (4)
132,279 Views
42 Replies
Replies (42)

jwinkler8A6WX
Enthusiast
Enthusiast

My 2 cents here....

 

The main purpose of Revit is to consolidate buildling information in a single central location so it can be displayed in various ways while changing.  This is the advantage of using Revit.  This is also the main idea of BIM.   Using multiple softwares to manually duplicate the same information defeats that purpose.

 

With this in mind I made a personal decision to invest time learning the Revit schedule interface and morphing my workflow.  I've found Revit schedules to be capable of most of the things that architects and engineers do in excel, with the exception of fancy graphics.  Revit's schedule graphic capabilites are being improved and there are workarounds.  But overall, I am willing to let go of fancy graphics in return for a more efficient, accurate and automated workflow.  If you are going to enter data, enter it into Revit - ONCE.

 

 

luisPDAN6
Advocate
Advocate

My two cents :

0 Likes

hoda.ganji
Contributor
Contributor

How about using Dynamo? "Revit, Dynamo and Excel interactions 2": https://www.youtube.com/watch?v=snmxnCwEhgQ&list=PLnQTukI1DJvz1tWmFTbx0UqdDPnAEVDoZ&index=2

This video shows how we can import and replace the data from an Excel file with the data in Revit file.

0 Likes