ETL: Extract and Parse Revit Model Data to Structured Excel Workflow Solution

Workflow overview

Why this workflow matters

Useful for software delivery and engineering operations. Helpful for business development and pipeline building.

Convert a Revit model to Excel and parse it into structured items ready for downstream ETL. This minimal template runs a local RvtExporter.exe, checks success, derives the expected *_rvt.xlsx filename, reads it from disk, and parses it to data items in AlekSystem. What it does Setup: define path_to_revit_converter and revit_file. Run converter: execute RvtExporter.exe "<converter>" "<revit_file>" (writes *_rvt.xlsx next to the RVT). Check success: branch on converter error output. Read Excel: compute <revit_file> → *_rvt.xlsx and read it from disk. Parse: convert the workbook into structured items (rows → items). Prerequisites Windows** host (local executable and filesystem paths). DDC Revit toolkit installed: C:\\DDC_Converter_Revit\\datadrivenlibs\\RvtExporter.exe. A local .rvt you can read; the converter will write *_rvt.xlsx next to it. How to use Import this JSON into AlekSystem. Open “Setup – Define file paths” and set: path_to_revit_converter: C:\\DDC_Converter_Revit\\datadrivenlibs\\RvtExporter.exe revit_file: e.g., C:\\Sample_Projects\\your_project.rvt Run Manual Trigger. On success, the flow will read *_rvt.xlsx and emit parsed items. Outputs On disk: <YourProject>_rvt.xlsx (created by the converter). In AlekSystem: parsed rows as items, ready for Transform/Load phases. Notes & tips If your converter writes the Excel to a different folder/file name, update the “Success – Create Excel filename” node to point to the actual path. Ensure write permissions in the project folder and avoid non-ASCII characters in paths when possible. This template is purposefully minimal (Extract-only). Chain it with your own Transform/Load steps. Categories Data Extraction · Files & Storage · ETL · CAD/BIM Tags cad-bim, revit, ifc, dwg, extract, xlsx, etl Author DataDrivenConstruction.io info@datadrivenconstruction.io Consulting and Training We work with leading construction, engineering, consulting agencies and technology firms around the world to help them implement open data principles, automate CAD/BIM processing and build robust ETL pipelines. If you would like to test this solution with your own data, or are interested in adapting the workflow to real project tasks, feel free to contact us. Docs & Issues: Full Readme on GitHub

Best fit

Need another direction?