Excel to BIM Update

Excel to BIM Update

Business Case

Problem Statement

After extracting BIM data to Excel and enriching it (cost codes, classifications, custom data):

• Changes need to flow back to the BIM model
• Manual re-entry is error-prone
• Updates must match by element ID

Solution

Push Excel data back to BIM models, updating element parameters and properties from spreadsheet changes.

Business Value

• Bi-directional workflow - BIM → Excel → BIM
• Bulk updates - Change thousands of parameters
• Data enrichment - Add classifications, codes, costs
• Consistency - Spreadsheet as single source of truth

Technical Implementation

Workflow

BIM Model (Revit/IFC) → Excel Export → Data Enrichment → Excel Update → BIM Model

Python Implementation

import pandas as pd
from pathlib import Path
from typing import Dict, Any, List, Optional, Tuple
from dataclasses import dataclass, field
from enum import Enum
import json


class UpdateType(Enum):
    """Type of BIM parameter update."""
    TEXT = "text"