Link Revit Data to Excel

Link Revit Data to Excel

While Revit offers a variety of tools to manage your projects, it might still leave you craving some of the functionality that an Excel spreadsheet offers. For example, you could use Excel to copy values to multiple cells or add in more advanced formulas. This would allow you to work with multiple pieces of data at once, rather than double-handling your data. It could also reduce the occurrence of manual errors and save you a significant amount of time.

Unfortunately, there isn’t an automatic Revit-Excel sync built into either program, but don’t worry, we have some options for you. In this article, we will share different ways that you can link Revit data to Excel.

Export Revit Data to Excel

For straightforward data, such as room schedules and drawing lists, you could create a Revit schedule and export it to Excel. However, keep in mind that any changes that you make in Excel will not automatically sync with Revit. You would have to manually update Revit with those changes or pursue other avenues of automation using an add-in or Dynamo.

Link Revit to Excel Using an Add-In

There are a few add-in options that would allow you to pull data from Revit into Excel and then easily push the revised data back to Revit. Some popular options include Ideate BIMLink and GRAITEC PowerPack. These plugins could save you a significant amount of time because you can quickly sync between Revit and Excel, rather than manually importing/exporting data.

Keep in mind that these add-ins do cost money, but they also come with additional features such as macro templates, removing duplicate type marks, creating placeholder sheets, controlling and managing manage global parameters, and so on.

Writing Code to Connect Revit and Excel

If you’d rather not invest money in an add-in tool to link Revit and Excel, you could write some code for it. This takes more expertise (and time), but it’s certainly an option. You could write a parameter exporter to connect Revit and Excel (here is a parameter exporter macro tutorial to help you get started).

Link Revit and Excel Using a Dynamo Script

Another free option for connecting Revit and Excel is by using a Dynamo Script. Dynamo is an open-source Revit Add-in that you can download for free. Those of you already familiar with programs such as Grasshopper would easily adapt to the Dynamo add-in. You can use Dynamo to graphically structure a workflow to allow you to edit a Revit model from Excel. Here is a tutorial to walk you through this setup.

Conclusion

So there you have it! It’s absolutely possible to reap the benefits of Excel when working with your Revit projects. The option best for you is the one that aligns with your time and budget as well as the complexity of your project.

Linking Revit to Excel is one of the many ways you can get the most out of Revit. If you’re interested in further maximizing your BIM investment, UNIFI can help you with your BIM content and data management strategy. Visit our solutions page to learn more or contact us for a free demo today

Revit 2020.2

Revit 2020.2: Our Favorite Features

Last month, Autodesk rolled out just a few updates to Revit 2020.2 which improve an already robust BIM application.

Included in the Revit 2020.2 release are new Dynamo nodes for structural modelingupdates to the fly mode, and even updates to the display of linked BIM360 models. Although these features are helpful in automation and improve the user experience, we are particularly excited about a few updates that improve the way users manage BIM data.

Updates to Schedule Views in Revit 2020.2

Schedules are arguably one of the most import features in Revit; they allow users to review, modify, and even print the data within a model in a tabular view. Autodesk has left this critical feature of Revit with much to be desired in terms of user interface for several versions (which equates to over a decade).

Well, we have good news! The Revit 2020.2 update includes a few updates that should make managing data in schedule views a little less painful.

Freeze the Header Row

Schedules with dozens or even hundreds of rows are not uncommon in large projects. Since the interface to schedules have not been updated in several versions now, these large schedules have always been difficult to navigate.

One of the issues when working with large schedule views is that been that the header row disappears off the screen while scrolling, making it difficult to know which columns are which. This has been remedied in Revit 2020.2 with the ability to freeze header rows of schedules in a similar way to what most users are accustomed to from working in Excel.

Revit 2020.2Highlight Rows

In regards to data management, another user interface enhancement in Revit 2020.2 is the highlighting of active rows in Revit. This might be a trivial feature to some, but it is definitely a major UI improvement when working with large schedules with several columns.

Similar to the issue with several rows in a large schedule, several columns have also been challenging because schedule views have always only highlighted a single cell at a time. In Revit 2020.2, the entire row is now highlighted in a schedule view, making it easier to review the data of an entire row.

Revit 2020.2Improvements to Electrical Panel Schedules

Electrical panel schedules are a special type of schedule in Revit. They do not follow the typical format of schedules by allowing users to add fields and filters, but rather are specifically generated for electrical panels. This has additional challenges when managing data from a panel schedule view. Autodesk has made a significant improvement towards making panel schedules easier to work with in Revit 2020.2.

Each circuit on a panel schedule includes a field for the circuit description, which has typically been a manually typed field which has always been challenging to manage at scale. In Revit 2020.2, users can now display combined parameters in place of a circuit description. This means more leverage of BIM data and less manual data entry, which of course means less risk for errors or mismatched information.

In addition, users can now review and edit these parameter values directly in the properties pane while in the panel schedule view.

Revit 2020.2Conclusion

Although these are just a few of the minor updates included in Revit 2020.2, they will undoubtedly make it easier to review and manage the data within Revit models while in schedule views. Happy Reviteering!

VIATechnik and UNIFI Team Up to Help AEC Industry Leverage UNIFI APIs for Custom Software Development

Las Vegas, NV,  December 2019 – UNIFI Labs has grown exponentially across all aspects of our business this year. This involves significant enhancements to our product offerings, including the release of our Project Analytics and Content Management APIs, which enable users to customize UNIFI to derive the data and functionality needed to optimize their unique BIM workflows and internal design technology stacks. In an effort to empower UNIFI customers to get the most out of our API offerings, we’re proud to announce we’ve joined forces with VIATechnik, the global leader in VDC consulting and experts in custom development software, to  help UNIFI customers leverage our APIs for their unique BIM workflow needs.  

The potential customizations available through UNIFI’s APIs are innumerous and offer significant ROI in terms of time and money to customers who leverage them in collaboration with a qualified partner, like VIATechnik. A few noteworthy use cases include programmatically managing data within Revit families, adding, removing, and modifying shared parameters and their value in batch, ensuring Revit families are up to date with company standards, reviewing historical BIM data, generating a changelog for Revit, and much more.  The VIATechnik team is fully committed to understanding the needs and desires of UNIFI customers and enabling them to utilize our API offerings accordingly. 

Danielle Dy Buncio, CEO of VIATechnik explains the power of the UNIFI partnership. “There is a proliferation of construction technology in the AECO space today, but it will be integration of these ideas that will create a positive disruptive force in the industry.” She continued, “We believe that UNIFI’s BIM content management platform along with VIATechnik’s BIM data insights and analytics capabilities will unlock the value that the BIM data provides and benefit a much broader set of stakeholders than the traditional BIM user group. We are excited to align ourselves with other leaders in the space, together working to create a better built environment.” 

Dwayne Miller, CEO and Co-Founder at UNIFI Labs echoes Danielle’s excitement, “We are really excited to announce the VIATechnik UNIFI partnership.  Both UNIFI and VIATechnik strive to ensure we journey with our customers and help them get the most out of their technology investment.  As a cloud-based software company, our goal at UNIFI is to ensure we deliver value to as many customers as possible. Due to our user base’s diversity and the unique nature of their respective technology stacks and project workflows, we’ve experienced that the need for customization is increasingly at the forefront of our conversations with customers. The release of our API earlier this year was a critical step forward in supporting customization and providing more flexible access to the power of our platform.” Dwayne added,  “Our partnership with VIATechnik represents the next step forward in providing our customers with the expertise they require to enable customization in the context of the unique ways each company leverages technology and integrates UNIFI to increase velocity and advance their business. VIATechnik’s incredible experience and deep domain expertise will help our customers realize the full benefit of our APIs and the power of the UNIFI platform.” 

Interested in utilizing the VIATechnik help you take advantage of UNIFI’s API offerings to enhance your BIM technology investment? Contact us today at sales@unifilabs.com or 702-834-5525. 

About VIATechnik 

VIATechnik is a global leader in virtual design and construction (VDC) consulting, implementation and education. Since our founding in 2012, VIATechnik has worked on over 2000 projects globally, covering over 180 million square feet. We have extensive experience on commercial, infrastructure, industrial, healthcare, educational, airport, data center, and residential projects. Our mission is to transform the analog world of design, construction, and operations of buildings and infrastructure into a digital platform, enabling efficient design, industrialized construction, and a digital real estate service model. Through this transformation, we believe we can solve the world’s housing and infrastructure challenges, deliver spaces that nurture life, commerce, and relationships. For additional information please call 773-340-1690, email tyler.gancarz@viatechnik.com or visit us at viatechnik.com. 

About UNIFI Labs 

UNIFI Labs is the global leader in cloud-based BIM content and data management. Our essential data platform delivers a Better BIM experience by helping users navigate the DARK BIM. Hundreds of brands trust UNIFI for their BIM content/data management needs, including  Interior Architects, KaterraStantec, HOK, Legrand, and Pella. For a free demo of UNIFI contact us at sales@unifilabs.com or visit us at www.unifilabs.com