Excel To Bim

What This Skill Does

The Excel To BIM skill provides a robust bridge between tabular data management and BIM-authoring environments like Revit or IFC-based platforms. It enables a bi-directional data flow where users can export complex model data to Excel, perform bulk enrichment, data cleaning, or cost-code assignments, and seamlessly propagate those changes back into the BIM environment. By mapping spreadsheet columns to specific model parameters, the agent ensures that data integrity is maintained using unique identifiers such as ElementId or GUIDs.

Installation

To integrate this skill into your OpenClaw environment, use the command-line interface to pull the package from the central repository:

clawhub install openclaw/skills/skills/datadrivenconstruction/excel-to-bim

Ensure that you have the necessary write permissions for your BIM model files and that your environment supports the Python pandas dependency used for spreadsheet processing.

Use Cases

• Cost Estimation Updates: Sync cost codes and procurement data from an external estimation spreadsheet directly into BIM assets.
• Asset Management: Populate facility management attributes (e.g., install date, warranty period, serial numbers) for thousands of components simultaneously after field inspections.
• Model Compliance: Update classification codes (e.g., Uniclass, OmniClass) across entire model libraries to meet project BIM execution plan requirements.
• Bulk Parameter Auditing: Automatically resolve inconsistencies found in scheduling tasks by pushing verified Excel records back to the authoring software.

Example Prompts

1. "Open 'Project_A_Assets.xlsx', map the 'Warranty Date' column to the 'BIM_Warranty' parameter, and update all elements based on their GUID."
2. "Update the BIM model using 'Export_Floor1.xlsx'. Use 'UniqueId' for identification and update all 'FireRating' parameters to the values in the 'Updated_Fire_Rating' column."
3. "Compare the current BIM parameters for the HVAC schedule with 'HVAC_Export.xlsx' and identify any discrepancies before performing a bulk update."

Tips & Limitations

• Data Consistency: Always ensure your Excel sheet headers match your mapping configuration exactly to prevent data injection errors.
• Identification: Rely heavily on globally unique identifiers (GUIDs) rather than internal element IDs, as the latter can shift during model re-synchronization.
• Safety Checks: Perform a dry-run or backup your BIM model before executing large-scale bulk updates. The skill is designed for efficiency, but mass-overwriting parameters can lead to data loss if the mapping is configured incorrectly.
• Constraint Awareness: Be mindful that some BIM parameters are read-only or system-constrained; ensure the target parameters are writable within your specific software version.