# Working with Revit in Excel as in Dynamo. Asking for feedback **URL:** \ **Category:** Revit\ **Tags:** revit, excel, python, ifc, export\ **Created:** [May 9, 2023, 5:28pm UTC](https://forum.dynamobim.com/t/working-with-revit-in-excel-as-in-dynamo-asking-for-feedback/89399 "2023-05-09T17:28:34Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![boikoartem](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/boikoartem/32/95806_2.png) [@boikoartem](https://forum.dynamobim.com/u/boikoartem)\ **Post date:** [May 9, 2023, 5:28pm UTC](https://forum.dynamobim.com/t/working-with-revit-in-excel-as-in-dynamo-asking-for-feedback/89399/1 "2023-05-09T17:28:34Z")
Hi all, we’ve just released a new version of our free Excel plug-in for working with Revit and IFC projects. 🙇‍♂️‍ We’d really appreciate it if you could take the time to test out the application and provide any feedback, suggestions, or ideas for improvement. We’ve added some useful features we believe can improve your experience: - Display of project geometry (similar to Dynamo) and element groups directly in Excel - A tool to check data completeness in Revit and IFC projects - A QTO tool for creating volume tables based on selected criteria Video: HOW TO WORK WITH REVIT AND IFC IN EXCEL [https://youtu.be/VNl4m\_XMAeM](https://youtu.be/VNl4m_XMAeM) Your input would be invaluable in helping us enhance the plug-in to better serve the community. Feel free to share your thoughts here on the forum or reach out to us directly. Thank you in advance for your time and input! ![Screenshot 2023-05-09 193001](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/0/7/076fe6b9099b74aa6939f6b0fbf4f81575114f48.png) ---
**Author:** ![Draxl\_Andreas](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/draxl_andreas/32/145744_2.png) [@Draxl\_Andreas](https://forum.dynamobim.com/u/Draxl_Andreas)\ **Post date:** [May 9, 2023, 8:26pm UTC](https://forum.dynamobim.com/t/working-with-revit-in-excel-as-in-dynamo-asking-for-feedback/89399/2 "2023-05-09T20:26:50Z")
@boikoartem , Nice work, is it already there to _install_?, particulary with the viewer… I would like to have the button “Revit to Power BI” 😉 … I think working with the _RevitFile_ in Excel has more performance! Revit is still doing his work on single core! I start more and more open IFCs in Blender… Is there also a connection translating files into OpenSourceProducts… ? or vice versa? An Idea would be also using Dynamo in Excel! or Dynamo running on Blender (or something similar)… I see a correlation between _AutdeskSolutions_ and the _OpenSourceProgress_, I like it! KR Andreas ---
**Author:** ![chuongmep](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/chuongmep/32/197537_2.png) [@chuongmep](https://forum.dynamobim.com/u/chuongmep)\ **Post date:** [May 10, 2023, 12:51am UTC](https://forum.dynamobim.com/t/working-with-revit-in-excel-as-in-dynamo-asking-for-feedback/89399/3 "2023-05-10T00:51:56Z")
Awesome @boikoartem ---
**Author:** ![boikoartem](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/boikoartem/32/95806_2.png) [@boikoartem](https://forum.dynamobim.com/u/boikoartem)\ **Post date:** [May 10, 2023, 5:08am UTC](https://forum.dynamobim.com/t/working-with-revit-in-excel-as-in-dynamo-asking-for-feedback/89399/4 "2023-05-10T05:08:54Z")
Hi Andreas, many thanks, yes you can download and install the app at the link: [https://opendatabim.io/index.php/product/excel-tool-odb-working-in-excel-with-revit-and-ifc/](https://opendatabim.io/index.php/product/excel-tool-odb-working-in-excel-with-revit-and-ifc/) Very cool idea about adding the PowerBI button - I’ll try putting it in and let you know the results. Also interesting topic with back loading of changed elements through Dynamo back into the model - need to think about how that might look, too. 🙇‍♂️ Thanks a lot for the interesting ideas! If you have time, try downloading and installing the plugin - I’d be happy if you find any bugs or have any more new ideas. BR, Artem ---
**Author:** ![boikoartem](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/boikoartem/32/95806_2.png) [@boikoartem](https://forum.dynamobim.com/u/boikoartem)\ **Post date:** [May 10, 2023, 5:12am UTC](https://forum.dynamobim.com/t/working-with-revit-in-excel-as-in-dynamo-asking-for-feedback/89399/5 "2023-05-10T05:12:01Z")
[chuongmep](https://forum.dynamobim.com/u/chuongmep) thanks. If you have time, please try to install - I will be glad to receive your comments, remarks or ideas ---
**Author:** ![boikoartem](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/boikoartem/32/95806_2.png) [@boikoartem](https://forum.dynamobim.com/u/boikoartem)\ **Post date:** [May 10, 2023, 2:47pm UTC](https://forum.dynamobim.com/t/working-with-revit-in-excel-as-in-dynamo-asking-for-feedback/89399/6 "2023-05-10T14:47:37Z")
This tool extends and complements the functionality which is difficult when working directly in Dynamo. Our solution uses the same geometry mechanism as Dynamo, and our further goal is to link this table through Dynamo back to the project. With all the data in tabular form, we can easily change and add any information to the project - and then import it back through Dynamo. We will work through the idea, if anyone has any thoughts on this please write ---
**Author:** ![Draxl\_Andreas](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/draxl_andreas/32/145744_2.png) [@Draxl\_Andreas](https://forum.dynamobim.com/u/Draxl_Andreas)\ **Post date:** [May 11, 2023, 8:10am UTC](https://forum.dynamobim.com/t/working-with-revit-in-excel-as-in-dynamo-asking-for-feedback/89399/7 "2023-05-11T08:10:00Z")
@boikoartem , i checked it out but the issue is, it is limited to 100 MB … Revitfiles… only our empty template has already 80MB … can you calibrate this ? Revitfiles limited to 1 GB it looks nice particulary create % regarding qualities and the integrated viewer… … for IFCs it can work when you use IfcZip Format… KR Andreas ---
**Author:** ![sovitek](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/sovitek/32/116237_2.png) [@sovitek](https://forum.dynamobim.com/u/sovitek)\ **Post date:** [May 11, 2023, 8:59am UTC](https://forum.dynamobim.com/t/working-with-revit-in-excel-as-in-dynamo-asking-for-feedback/89399/8 "2023-05-11T08:59:10Z")
Hi Andreas…havent tried yet…but does it have limit for ifc as well ?? ---
**Author:** ![boikoartem](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/boikoartem/32/95806_2.png) [@boikoartem](https://forum.dynamobim.com/u/boikoartem)\ **Post date:** [May 11, 2023, 10:21am UTC](https://forum.dynamobim.com/t/working-with-revit-in-excel-as-in-dynamo-asking-for-feedback/89399/9 "2023-05-11T10:21:58Z")
Hi Andreas! Thank you for your feedback, it is very valuable to us. We are now collecting analytics on the parameters that are important for experts to make a purchase decision. We are now thinking about increasing the Excel files we process to 200-300 Mb. and we want to make the Excel Plugin with Revit and IFC product as affordable as possible. At the same time, medium and large companies should pay for Lite or Full versions, which will give our team the ability to fund development and give more tools to users in all versions. What do you think: 1. What versions of Revit and IFC should be in the Community version? 2. What size limit should the Community version have? so that ordinary users would have enough to work with small projects and on the other hand medium and large companies, which will face restrictions and will have to pay for further development ---
**Author:** ![Draxl\_Andreas](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/draxl_andreas/32/145744_2.png) [@Draxl\_Andreas](https://forum.dynamobim.com/u/Draxl_Andreas)\ **Post date:** [May 11, 2023, 10:27am UTC](https://forum.dynamobim.com/t/working-with-revit-in-excel-as-in-dynamo-asking-for-feedback/89399/10 "2023-05-11T10:27:22Z")
@boikoartem , that brings me to the idea up and downgrade versions of IFC and RVT via Excel…? I think thats to complex… but you would have a good business… At Least Revit 2022 and IFC4 i would say … KR Andreas ---
**Author:** ![boikoartem](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/boikoartem/32/95806_2.png) [@boikoartem](https://forum.dynamobim.com/u/boikoartem)\ **Post date:** [May 11, 2023, 10:40am UTC](https://forum.dynamobim.com/t/working-with-revit-in-excel-as-in-dynamo-asking-for-feedback/89399/11 "2023-05-11T10:40:30Z")
Andreas, thank you very much, and in terms of size? ---
**Author:** ![Draxl\_Andreas](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/draxl_andreas/32/145744_2.png) [@Draxl\_Andreas](https://forum.dynamobim.com/u/Draxl_Andreas)\ **Post date:** [May 11, 2023, 10:42am UTC](https://forum.dynamobim.com/t/working-with-revit-in-excel-as-in-dynamo-asking-for-feedback/89399/12 "2023-05-11T10:42:45Z")
@boikoartem , i can just talk from my perspetive, my IFCs have around in my current project between 100 MB - 150 MB. Revit… is around 1.3 GB after cleaning 700 MB… with such a file(s) i would make my test in excel. KR Andreas ---
**Author:** ![boikoartem](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/boikoartem/32/95806_2.png) [@boikoartem](https://forum.dynamobim.com/u/boikoartem)\ **Post date:** [November 29, 2023, 8:12pm UTC](https://forum.dynamobim.com/t/working-with-revit-in-excel-as-in-dynamo-asking-for-feedback/89399/13 "2023-11-29T20:12:56Z")
Hi Andreas, sorry there was a “necessary technical” pause. Transferred the development of the converter to the new [DataDrivenConstruction.io](http://DataDrivenConstruction.io) platform. The free version for Revit 2015-2022 and IFC2x3 can be downloaded without registration from the website [DataDrivenConstruction.io](http://datadrivenconstruction.io/) or through this post. Now there are no restrictions on the number of files and sizes 🙋‍♂️ Post: > [@FREE Converter Revit 2015-2022 with terminal and stream conversion](https://forum.dynamobim.com/t/free-converter-revit-2015-2022-with-terminal-and-stream-conversion/95943): > > Hello, community raising_hand_man I’d like to share a free data converter from Revit allows to get structured tabular data from one or at once hundreds of projects (file is in the attachment below the post). Without internet, API connections, without Forge and plugins. Free data converter from Revit formats 2015-2022 versions: inbox_tray [FREE Revit®2015-Revit®2022 to XLSX/DAE converter - DataDrivenConstruction: The Future of Building is Data-Powered](https://datadrivenconstruction.io/index.php/product/free-revit-2015-2021-converter-to-xlsx-dae/) VIDEO How to get started: [[Rev…](https://www.youtube.com/watch?v=fHkXDMLzWzQ) ---
**Author:** ![ruben.romero](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/ruben.romero/32/115842_2.png) [@ruben.romero](https://forum.dynamobim.com/u/ruben.romero)\ **Post date:** [November 29, 2023, 10:52pm UTC](https://forum.dynamobim.com/t/working-with-revit-in-excel-as-in-dynamo-asking-for-feedback/89399/14 "2023-11-29T22:52:36Z")
What data can be extraxted from Revit with the program? Is about instance/type parameters of certain category element instances? ---
**Author:** ![boikoartem](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/boikoartem/32/95806_2.png) [@boikoartem](https://forum.dynamobim.com/u/boikoartem)\ **Post date:** [November 30, 2023, 5:40am UTC](https://forum.dynamobim.com/t/working-with-revit-in-excel-as-in-dynamo-asking-for-feedback/89399/15 "2023-11-30T05:40:30Z")
Hi Ruben, thanks, we get everything from all the elements. At some points, we get even more than we can extract with the tools inside Revit. This is a full data dump from Revit: element information is stored in two-dimensional dataframe (the most popular format for working in data analytics, data engineering and big data), and the geometry of all elements is stored in open triangular DAE-XML format (one of the most popular formats for working with geometry). Without internet, API connections, without Forge and plugins. This is a fully legitimate data tool, similar to those used by companies like Graphisoft and Siemens, and is now accessible to everyday users. To download the converter, no need to register on the site, just download and unzip, and get data for one project or for several thousands of projects in Revit or IFC formats offline and without opening Revit. Please post any questions you may have! ---
**Author:** ![boikoartem](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/boikoartem/32/95806_2.png) [@boikoartem](https://forum.dynamobim.com/u/boikoartem)\ **Post date:** [March 17, 2024, 5:46pm UTC](https://forum.dynamobim.com/t/working-with-revit-in-excel-as-in-dynamo-asking-for-feedback/89399/16 "2024-03-17T17:46:01Z")
Hi Andreas, new plugin to work with Revit, AutoCAD and IFC in Excel now without file size limitations. Converting data from closed, proprietary formats to more publicly available formats or splitting mixed CAD (BIM) formats into geometric and meta-information data simplifies the process of working with them, making them more accessible for analysis, manipulation and integration with other systems 🌌 This enables professionals to shift from processing CAD (BIM) models in a mixed format, which involves using specialized software, to a data-centric approach. The latter primarily emphasizes the use of open data and open tools. 📥 Direct link to download the free plugin for Excel: [https://datadrivenconstruction.io/?sdm\_process\_download=1&download\_id=2414](https://datadrivenconstruction.io/?sdm_process_download=1&download_id=2414) 🔗 More about the app and the plugin feature [DDC Excel plugin for working with Revit, IFC and DWG - DataDrivenConstruction.io | Revolutionizing Construction with Data](https://datadrivenconstruction.io/index.php/ddc-excel-plugin-for-working-with-revit-ifc-and-dwg/) 💻 Video - Unleash the power of your CAD (BIM) data: [https://www.youtube.com/watch?v=leDt4I8uuJI](https://www.youtube.com/watch?v=leDt4I8uuJI) ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/f/5/f5ae3fd773c14b44fbefd010fd3c3bd5724cba51.png) ---
**Author:** ![GavinNicholls](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/gavinnicholls/32/190442_2.png) [@GavinNicholls](https://forum.dynamobim.com/u/GavinNicholls)\ **Post date:** [March 18, 2024, 7:52am UTC](https://forum.dynamobim.com/t/working-with-revit-in-excel-as-in-dynamo-asking-for-feedback/89399/17 "2024-03-18T07:52:11Z")
Whilst I’m not 100% on dumping BIM into Excel, just wanted to say this has come along way and you’ve made some fantastic examples on use cases that validate the merit of this. Great work. I will try to set some time aside to try it out. ---
**Author:** ![boikoartem](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/boikoartem/32/95806_2.png) [@boikoartem](https://forum.dynamobim.com/u/boikoartem)\ **Post date:** [March 18, 2024, 8:16am UTC](https://forum.dynamobim.com/t/working-with-revit-in-excel-as-in-dynamo-asking-for-feedback/89399/18 "2024-03-18T08:16:38Z")
@GavinNicholls, thank you 🙇‍♂️ I’m not a big fan of Excel myself. Initially my goal was to bring data from BIM formats into 2x DataFrame (the most popular data format in big data, analytics and machine learning [pandas download stats](https://www.pepy.tech/projects/pandas)). But since the DataFrame topic is complicated for builders - I’m showing how to work with CAD (BIM) formats in Excel. Inside Revit sits SQLlite, which can be accessed either through several layers of APIs from Autodesk or through reverse engineering tools, as in my case. Since almost all SQL-like databases exchange information via CSV (untidy XLSX) format, which is relatively difficult for the average construction industry professional to process - so I chose Excel, which has become such a quasi-PoC for working with CAD (BIM) in a two-dimensional DataFrame space. I tackled the complex topic of DataFrames and generally data in construction in my book “DataDrivenConstruction” (now only in paper form at first) and will soon be available for free electronically: [Books & News - DataDrivenConstruction.io | Revolutionizing Construction with Data](https://datadrivenconstruction.io/index.php/books/) Many thanks @GavinNicholls Gavin - please post any criticism, any comments or questions on the subject of plugins or converters. Will be extremely grateful to you for any feedback 🙌 ---
**Author:** ![boikoartem](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/boikoartem/32/95806_2.png) [@boikoartem](https://forum.dynamobim.com/u/boikoartem)\ **Post date:** [August 4, 2024, 3:52pm UTC](https://forum.dynamobim.com/t/working-with-revit-in-excel-as-in-dynamo-asking-for-feedback/89399/19 "2024-08-04T15:52:13Z")
Hi everyone who is following the tools for getting data from Revit! In the latest open source application it is now possible to retrieve data from a Revit project, check, change values and load changed values and new parameters and values directly through the plugin or through Dynamo back into Revit: [GitHub - datadrivenconstruction/ImportExcelToRevit: Add-in allows to import parameter values from Excel database, created with DataDrivenConstruction Excel Add-in or converters](https://github.com/datadrivenconstruction/ImportExcelToRevit). That is, we can now control almost all project parametrics and element meta information validation outside of the Revit program. Full step-by-step guide: [https://youtu.be/lMTcacVK-k4?si=bNtkGi2cM5Ns-ol9](https://youtu.be/lMTcacVK-k4?si=bNtkGi2cM5Ns-ol9). I will be glad to hear any comments and thoughts on this topic, as well as new ideas on how to use data from Dynamo or c API to enrich the project with modified or new data. ---
**Author:** ![boikoartem](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/boikoartem/32/95806_2.png) [@boikoartem](https://forum.dynamobim.com/u/boikoartem)\ **Post date:** [July 22, 2026, 9:38am UTC](https://forum.dynamobim.com/t/working-with-revit-in-excel-as-in-dynamo-asking-for-feedback/89399/20 "2026-07-22T09:38:40Z")
Hi everyone, A quick update to this thread. What started as a set of tools for working with Revit data outside Revit - initially through Excel, converters and Dynamo - has now evolved into a new open-source platform called **OpenConstructionERP**. The platform brings together many of these workflows in one place: working with RVT, IFC, DWG, DGN, DXF and other formats, extracting structured element and property data, filtering and validating model information, quantity takeoff, linking BIM elements to BOQ and cost data, and exporting information to Excel, CSV, JSON or external systems through an API. The goal is not to replace Revit or Dynamo, but to create an open data layer around them and connect BIM data with estimating, scheduling, procurement and project management workflows. The project is open source, and I would be very interested in feedback from the Revit and Dynamo community - particularly which Revit workflows and integrations you would like to see added next. Platform: [https://openconstructionerp.com/](https://openconstructionerp.com/) GitHub: [GitHub - datadrivenconstruction/OpenConstructionERP: Open-source construction ERP - BOQ, PDF/CAD/BIM takeoff, AI cost matching. 42 regional catalogues, 21 languages, 71 modules. AGPL-3.0. v3.0 - pip install openconstructionerp · GitHub](https://github.com/datadrivenconstruction/OpenConstructionERP) ![V10 OpenConstructionERP](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/2/6/269785bdc6ec24ed094eb73660388aea6b39b31a.jpeg)