This workflow automates the extraction, processing, and visualization of wall quantity data from Revit BIM files for construction analysis. Designed for interior BIM teams and project managers, it streamlines the transformation of complex Revit data into a comprehensive, visually appealing HTML report. The process begins with manually triggering the workflow, setting file paths for the Revit converter and Revit file. It then executes a command to convert the Revit model into an Excel spreadsheet. Once the conversion succeeds, the workflow reads and parses the Excel data, filtering for wall elements (‘OST_Walls’). Wall data is cleaned and grouped by ‘Type Name’ with volume sums calculated. The grouped data is further analyzed to generate summary statistics, including total wall types, total walls, total volume, and average volume per wall. Using this data, a professional HTML report is dynamically generated with CSS styling and visual elements such as progress bars and cards, making complex data easily understandable. The HTML report is saved as a file, completing the automation. This workflow is useful for BIM teams needing quick, automated insights for project reporting, cost estimation, or design review purposes.