rvt-to-excel — Claude Code skill for RVT to Excel exports
rvt-to-excel is a Claude Code skill that exports Revit model data, element properties, and quantities to Excel for reports and analytics workflows.
MIT 135 installs ★ 434 updated 2026-10-19
npx skills add datadrivenconstruction/DDC_Skills_for_AI_Agents_in_Construction --skill rvt-to-excel -a claude-codeWhat rvt-to-excel does
The skill guides RvtExporter.exe exports from RVT/RFA files. Choose basic, standard, complete, or custom mode, then add options for bounding-box coordinates, room associations, schedules, or PDF sheet exports. The Excel workbook organizes data into sheets for elements, categories, levels, materials, and parameters. It can also process multiple RVT files in a batch.
A Python integration reads the exported elements into a DataFrame and groups counts, area, and volume by category. The workbook is saved beside the source file with an .xlsx extension. The stated requirements are Windows, python3, and RvtExporter; conversion depends on RvtExporter.exe being available. The skill also describes a workflow for using quantities in a cost-estimation pipeline.
What it helps with
- export Revit element properties to Excel
- process a folder of RVT files in batch
- summarize element counts, area, and volume by category
- prepare structured BIM data for reports and analytics
Example prompts for the agent
- Export
Building.rvtto Excel incompletemode and include bounding-box coordinates. - Convert every RVT file in this folder with
standardmode and create an Excel workbook for each. - Create a category summary with element counts, total area, and volume from the exported workbook.
How to install rvt-to-excel
1Skills CLI (Vercel)
npx skills add datadrivenconstruction/DDC_Skills_for_AI_Agents_in_Construction --skill rvt-to-excel -a claude-code2Manually: put the files in place
~/.claude/skills/rvt-to-excel/SKILL.mdCopy the whole skill folder; for one project use .claude/skills/rvt-to-excel/
1Skills CLI (Vercel)
npx skills add datadrivenconstruction/DDC_Skills_for_AI_Agents_in_Construction --skill rvt-to-excel -a codex2Manually: put the files in place
.agents/skills/rvt-to-excel/SKILL.mdFor all projects use ~/.agents/skills/
1Skills CLI (Vercel)
npx skills add datadrivenconstruction/DDC_Skills_for_AI_Agents_in_Construction --skill rvt-to-excel -a cursor2Manually: put the files in place
.cursor/skills/rvt-to-excel/SKILL.mdCursor also reads .agents/skills/ and .claude/skills/
1GitHub CLI
gh skill install datadrivenconstruction/DDC_Skills_for_AI_Agents_in_Construction 1_DDC_Toolkit/CAD-Converters/rvt-to-excel2Manually: put the files in place
.github/skills/rvt-to-excel/SKILL.md1Skills CLI (Vercel)
npx skills add datadrivenconstruction/DDC_Skills_for_AI_Agents_in_Construction --skill rvt-to-excel -a gemini-cli2Platform CLI
gemini skills install https://github.com/datadrivenconstruction/DDC_Skills_for_AI_Agents_in_Construction --path 1_DDC_Toolkit/CAD-Converters/rvt-to-excelManually: put the files in place
.devin/skills/rvt-to-excel/SKILL.mdThe legacy .windsurf/skills/ path still works
Skills CLI (Vercel)
npx skills add datadrivenconstruction/DDC_Skills_for_AI_Agents_in_Construction --skill rvt-to-excel -a opencodeClaude.ai
Zip the folder and upload it in Settings → Capabilities → Skills
Step by step, with commands for each platform: How to install skills in Claude Code: five ways
Questions about rvt-to-excel
How do I install rvt-to-excel in Claude Code?
Run npx skills add datadrivenconstruction/DDC_Skills_for_AI_Agents_in_Construction --skill rvt-to-excel -a claude-code. The skill file is at ~/.claude/skills/rvt-to-excel/SKILL.md.
What does rvt-to-excel do?
It guides exports of Revit model data into Excel, including element properties and quantities. The resulting data can be grouped for summaries and reporting.
What do I need to export RVT files?
The listed requirements are Windows, python3, and RvtExporter.exe. Export modes include basic, standard, complete, and custom.
Source text
SKILL.md · MIT
---
name: "rvt-to-excel"
description: "Convert RVT/RFA files to Excel databases. Extract BIM element data, properties, and quantities."
homepage: "https://datadrivenconstruction.io"
metadata: {"openclaw":{"emoji":"🏠","os":["win32"],"homepage":"https://datadrivenconstruction.io","requires":{"bins":["python3","RvtExporter"]}}}
---
# RVT to Excel Conversion
## Business Case
### Problem Statement
BIM data inside RVT files needs to be extracted for:
- Processing multiple projects in batch
- Integrating BIM data with analytics pipelines
- Sharing structured data with stakeholders
- Generating reports and quantity takeoffs
### Solution
Convert RVT files to structured Excel databases for analysis and reporting.
### Business Value
- **Batch processing** - Convert multiple projects
- **Data accessibility** - Excel format for universal access
- **Pipeline integration** - Feed data to BI tools, ML models
- **Structured output** - Organized element data and properties
## Technical Implementation
### CLI Syntax
```bash
RvtExporter.exe <input_path> [export_mode] [options]
```
### Export Modes
| Mode | Categories | Description |
|------|-----------|-------------|
| `basic` | 309 | Essential structural elements |
| `standard` | 724 | Standard BIM categories |
| `complete` | 1209 | All Revit categories |
| `custom` | User-defined | Specific categories only |
### Options
| Option | Description |
|--------|-------------|
| `bbox` | Include bounding box coordinates |
| `rooms` | Include room associations |
| `schedules` | Export all schedules to sheets |
| `sheets` | Export sheets to PDF |
### Examples
```bash
# Basic export
RvtExporter.exe "C:\Projects\Building.rvt" basic
# Complete with bounding boxes
RvtExporter.exe "C:\Projects\Building.rvt" complete bbox
# Full export with all options
RvtExporter.exe "C:\Projects\Building.rvt" complete bbox rooms schedules sheets
# Batch processing
for /R "C:\Projects" %f in (*.rvt) do RvtExporter.exe "%f" standard bbox
```
### Python Integration
```python
import subprocess
import pandas as pd
from pathlib import Path
from typing import List, Optional
class RevitExporter:
def __init__(self, exporter_path: str = "RvtExporter.exe"):
self.exporter = Path(exporter_path)
if not self.exporter.exists():
raise FileNotFoundError(f"RvtExporter not found: {exporter_path}")
def convert(self, rvt_file: str, mode: str = "complete",
options: List[str] = None) -> Path:
"""Convert Revit file to Excel."""
rvt_path = Path(rvt_file)
if not rvt_path.exists():
raise FileNotFoundError(f"Revit file not found: {rvt_file}")
cmd = [str(self.exporter), str(rvt_path), mode]
if options:
cmd.extend(options)
result = subprocess.run(cmd, capture_output=True, text=True)
if result.returncode != 0:
raise RuntimeError(f"Export failed: {result.stderr}")
# Output file is same name with .xlsx extension
output_file = rvt_path.with_suffix('.xlsx')
return output_file
def batch_convert(self, folder: str, mode: str = "standard",
pattern: str = "*.rvt") -> List[Path]:
"""Convert all Revit files in folder."""
folder_path = Path(folder)
converted = []
for rvt_file in folder_path.glob(pattern):
try:
output = self.convert(str(rvt_file), mode)
converted.append(output)
print(f"Converted: {rvt_file.name}")
except Exception as e:
print(f"Failed: {rvt_file.name} - {e}")
return converted
def read_elements(self, xlsx_file: str) -> pd.DataFrame:
"""Read converted Excel as DataFrame."""
return pd.read_excel(xlsx_file, sheet_name="Elements")
def get_quantities(self, xlsx_file: str,
group_by: str = "Category") -> pd.DataFrame:
"""Get quantity summary grouped by category."""
df = self.read_elements(xlsx_file)
# Group and count
summary = df.groupby(group_by).agg({
'ElementId': 'count',
'Area': 'sum',
'Volume': 'sum'
}).reset_index()
summary.columns = [group_by, 'Count', 'Total_Area', 'Total_Volume']
return summary
```
## Output Structure
### Excel Sheets
| Sheet | Content |
|-------|---------|
| Elements | All BIM elements with properties |
| Categories | Element categories summary |
| Levels | Building levels |
| Materials | Material definitions |
| Parameters | Shared parameters |
### Element Columns
| Column | Type | Description |
|--------|------|-------------|
| ElementId | int | Unique Revit ID |
| Category | string | Element category |
| Family | string | Family name |
| Type | string | Type name |
| Level | string | Associated level |
| Area | float | Surface area (m²) |
| Volume | float | Volume (m³) |
| BBox_MinX/Y/Z | float | Bounding box min |
| BBox_MaxX/Y/Z | float | Bounding box max |
## Usage Example
```python
# Initialize exporter
exporter = RevitExporter("C:/Tools/RvtExporter.exe")
# Convert single file
xlsx = exporter.convert("C:/Projects/Office.rvt", "complete", ["bbox", "rooms"])
# Read and analyze
df = exporter.read_elements(str(xlsx))
print(f"Total elements: {len(df)}")
# Quantity summary
quantities = exporter.get_quantities(str(xlsx))
print(quantities)
# Export to CSV for further processing
df.to_csv("elements.csv", index=False)
```
## Integration with DDC Pipeline
```python
# Full pipeline: Revit → Excel → Cost Estimate
from semantic_search import CWICRSemanticSearch
# 1. Convert Revit
exporter = RevitExporter()
xlsx = exporter.convert("project.rvt", "complete", ["bbox"])
# 2. Extract quantities
df = exporter.read_elements(str(xlsx))
quantities = df.groupby('Category')['Volume'].sum().to_dict()
# 3. Search CWICR for pricing
search = CWICRSemanticSearch()
costs = {}
for category, volume in quantities.items():
results = search.search_work_items(category, limit=5)
if not results.empty:
avg_price = results['unit_price'].mean()
costs[category] = volume * avg_price
print(f"Total estimate: ${sum(costs.values()):,.2f}")
```
## Best Practices
1. **Use appropriate mode** - `basic` for quick analysis, `complete` for full data
2. **Include bbox** - Required for spatial analysis and visualization
3. **Batch carefully** - Large files may take time; process overnight
4. **Validate output** - Check element counts against Revit schedules
## Resources
- **GitHub**: [cad2data Pipeline](https://github.com/datadrivenconstruction/cad2data-Revit-IFC-DWG-DGN-pipeline-with-conversion-validation-qto)
- **Download**: See repository releases for RvtExporter.exe
© datadrivenconstruction · MIT · datadrivenconstruction/DDC_Skills_for_AI_Agents_in_Construction