Announcements
Welcome to the Revit Ideas Board! Before posting, please read the helpful tips here. Thank you for your Ideas!
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Link Excel Spreadsheet

Link Excel Spreadsheet

Why is it still not possible to Import or Link an Excel Spreadsheet into Revit? It would be a nice addition for future versions.

3 Comments
ipselute
Advisor

@dbrownG4VN3: Trust me, you don't wanna go that way. Importing Excel in Revit is kinda useless, as you could only import cell data (raw data), no formulas,  and only in some specific manner that Revit would understand. It is possible to create Revit schedules, export it to Excel, and create a bi-directional link between exported schedules and Revit data. Something like a Graitec extension or a CoBie extension. That would work.

Linking Excel as an OLE object in Revit doesn't seem very useful. The more Excel tables you link as OLE in Revit, the slower the Revit file will become. I do it all the time in Autocad, inserting dozen tables as OLE slows down Autocad file considerably and increases dwg size dramatically.

 

P.S. If you really need some text-based table (no formulas) in Revit, you can create a Revit schedule with some text parameters as instance parameters. Those parameteres would be like the columns in Excel. Then, you can give any text values to each instance for each row as you like.

 

victor_vijeuKD42L
Enthusiast

Everybody wants to insert or link Excel files directly into Revit. Because each company has some sorts of excel balance sheets set up in their own custom ways for various reasons: cost estimations, time projections, area totals and area balances. Many architects and engineers need "bear-metal" time & costs projections, they don't invest design time and resources into design phases or design options. Complex solutions needs to be checked or validated by simplified excel formulas.

Linking Autocad tables is not the best solution, as Autocad doesn't support advanced math functions as Excel does. E.g roundup , xlookup, etc

Tags (1)
Simon_Weel
Advisor

What we actually want is Excel-like functionality in Revit....

Can't find what you're looking for? Ask the community or share your knowledge.

Submit Idea  

Autodesk Design & Make Report


Autodesk Design & Make Report