export-to-excel

Export Revit Model Data to Excel / CSV

Export model data to a spreadsheet for:

"$ARGUMENTS"

Before writing code

Ask (one question if ambiguous):

1. Which category? Rooms, Doors, Windows, Walls, Families, Sheets, or a custom one?
2. Which parameters? List them, or default to the most useful set for that category.
3. Output path? Default to C:\Exports\revit_export.csv — user can change it.

Read-only — no model modifications. Safe to run on any model.

Script: Universal parameter export to CSV

import clr
clr.AddReference('RevitServices')
from RevitServices.Persistence import DocumentManager
clr.AddReference('RevitAPI')
from Autodesk.Revit.DB import *

import csv, os, System

doc = DocumentManager.Instance.CurrentDBDocument

# ── Configuration ────────────────────────────────────────────────────────────
CATEGORY    = BuiltInCategory.OST_Rooms   # change to target category
OUTPUT_PATH = r"C:\Exports\revit_export.csv"

# Parameters to export — exact names, case-sensitive
# Leave empty [] to export ALL available parameters (creates wide table)
PARAMS = [
    "Name",
    "Number",
    "Level",
    "Area",
    "Department",
    "Occupancy",
    "Comments",
]
# ─────────────────────────────────────────────────────────────────────────────

def get_param_value(el, param_name):
    """Safely read any parameter as a display string."""
    param = el.LookupParameter(param_name)
    if not param:
        return ""
    storage = param.StorageType
    if storage == StorageType.String:
        return param.AsString() or ""
    elif storage == StorageType.Double:
        # Return in display units (mm² for area, mm for length)
        try:
            return str(round(param.AsDouble() * 0.0929, 3))  # ft² → m²
        except Exception:
            return str(param.AsDouble())
    elif storage == StorageType.Integer:
        return str(param.AsInteger())
    elif storage == StorageType.ElementId:
        eid = param.AsElementId()
        ref_el = doc.GetElement(eid)
        return ref_el.Name if ref_el else str(eid.IntegerValue)
    return ""

try:
    elements = list(FilteredElementCollector(doc)
                    .OfCategory(CATEGORY)
                    .WhereElementIsNotElementType()
                    .ToElements())

    if not elements:
        OUT = "No elements found in the specified category."
    else:
        # Determine headers
        if PARAMS:
            headers = ["ElementId"] + PARAMS
        else:
            # Auto-discover all parameters from first element
            headers = ["ElementId"]
            for p in elements[0].Parameters:
                if p.Definition:
                    headers.append(p.Definition.Name)

        # Ensure output directory exists
        os.makedirs(os.path.dirname(OUTPUT_PATH), exist_ok=True)

        # Write CSV
        with open(OUTPUT_PATH, 'w', newline='') as f:
            writer = csv.writer(f)
            writer.writerow(headers)

            for el in elements:
                row = [str(el.Id.IntegerValue)]
                for param_name in headers[1:]:   # skip ElementId
                    row.append(get_param_value(el, param_name))
                writer.writerow(row)

        OUT = {
            "Exported": len(elements),
            "Fields": headers,
            "File": OUTPUT_PATH
        }

except Exception as e:
    import traceback
    OUT = "ERROR: " + str(e) + "\n" + traceback.format_exc()