Course Description

Sometimes you need direct access to your Revit data. Schedules are super useful but they don't always work the way you need them to. Maybe you need to copy a value to multiple cells. Or you need to increment a range of values. Or you want to use more advanced formulas. Let's face it, sometimes you wish Revit schedules worked more like Excel.

Fortunately, it’s easy to link your Revit data to Excel. It’s even possible to edit your Revit model directly from Excel. Sounds pretty cool, right? This mini-course will show you how to use Dynamo to create a direct link to Excel. You'll learn how to export parameter data to Excel and import the updated data back into your Revit model. You'll even learn how you can modify your model directly from Excel.

Course Objectives

  • Understand how Revit structures data inside your model
  • Learn how to export parameter data to Excel with Dynamo
  • Learn how to import modified data from Excel back into Revit using Dynamo
  • Learn how to use key values to update specific family instances in your Revit model

Senior Instructor and Founder of ArchSmarter

Michael Kilkelly

Hi there! I'm Michael Kilkelly. I founded ArchSmarter 2014 as a way to help other architects become more productive and get the best results out of their design software. I’m a native New Englander. I live and work in Middletown, CT. Prior to starting ArchSmarter, I was an Associate at Gehry Partners in Los Angeles. I also worked for a number of design firms in the Boston area. I received my B.Arch from Norwich University and an SMArchS from MIT

Course curriculum

  • 1

    Managing Building Data with Excel

    • 1.0 - Introduction

    • 1.1 - Getting Started with Dynamo

    • 1.2 - Export Room Data to Excel

    • 1.3 - Import Room Data from Excel

    • 1.4 - Export Door Data to Excel

    • 1.5 - Import Specific Door Data from Excel

    • 1.6 - Change Type Parameters from Excel

    • 1.7 - Calculate and Visualize Data

    • 1.8 - Conclusion and Questions

    • Sample Files