A specialized utility for converting legacy and modern DGN infrastructure CAD files into queryable Excel databases.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install dgn-to-excel
2. Manual Installation
Copy the skill folder to one of these locations
~/.openclaw/skills/ <project>/skills/ Priority: Workspace > Local > Bundled
3. Prompt Installation
Copy this prompt to OpenClaw to install it automatically.
Help me install dgn-to-excel using Clawhub. If Clawhub is not installed, install it first (npm i -g clawhub).
Prefer to download?
Get the raw skill files in a ZIP archive.
What is DGN to Excel Data Extractor?
This skill provides a robust bridge between specialized infrastructure design files and common data analysis tools. It allows developers and engineers to extract granular element data, level definitions, and geometric properties from MicroStation DGN formats (v7 and v8) directly into structured .xlsx files.
By leveraging this Openclaw Skills capability, teams can automate the extraction of CAD metadata without needing a full MicroStation license for every data consumer. The skill is particularly valuable in civil engineering contexts such as transportation, bridge design, and utility network management where structured data is required for reporting and BIM coordination.
DGN to Excel Data Extractor Use Cases
- Automated extraction of infrastructure elements for civil engineering reporting and project management.
- Auditing CAD level standards and element counts across large-scale transportation projects.
- Converting DGN geometry coordinates into CSV or Excel formats for seamless GIS integration.
- Comparing DGN file revisions to track changes in level usage and design complexity.
How DGN to Excel Data Extractor Works
- The user provides a target DGN file (v7, v8, or v8i) to the DgnExporter utility via CLI or Python.
- The skill parses the internal CAD file structure, identifying specific element types such as lines, shapes, text, and cells.
- Metadata including level numbers, color indexes, line weights, and styles are mapped to a relational schema.
- Geometry bounds (X, Y, Z ranges) and text content are extracted for every individual element within the file.
- A multi-sheet Excel workbook is generated, organizing data into Elements, Levels, and Cells for easy filtering.
DGN to Excel Data Extractor Setup
To utilize this skill, ensure the DgnExporter executable is available in your environment.
Basic CLI usage:
DgnExporter.exe <path_to_input_dgn>
For Python-based automation, initialize the exporter as follows:
from dgn_exporter import DGNExporter
# Initialize with the path to the executable
exporter = DGNExporter("C:/DDC/DgnExporter.exe")
# Convert a specific file
xlsx_path = exporter.convert("C:/Projects/Highway.dgn")
DGN to Excel Data Extractor Data Schema & Taxonomy
The skill organizes extracted CAD data into a structured Excel database with the following schema:
| Sheet | Content Description |
|---|---|
| Elements | Comprehensive list of all DGN elements including IDs, Types, and Properties. |
| Levels | Metadata regarding level definitions and element counts per level. |
| Cells | A library of cell references (blocks) found within the design file. |
Core Element Attributes:
ElementId: Unique integer identifier for the CAD element.ElementType: Integer code representing geometry (e.g., 3 for Lines, 17 for Text).RangeLowX/Y/Z&RangeHighX/Y/Z: Floating-point coordinates defining the bounding box.TextContent: Extracted string data for annotation elements.
DGN to Excel Data Extractor Advanced Features
- Batch processing capabilities for converting entire directories of infrastructure files using Openclaw Skills scripts.
- Advanced DGNAnalyzer class for calculating linear element totals and complex structure counts.
- Revision comparison tools to identify exactly which levels were added or removed between project milestones.
- Automated coordinate extraction optimized for GIS spatial analysis and mapping workflows.
SKILL.md
Loading
Related Openclaw Skills
df-merger
A Python-based utility for merging disparate construction data sources into unified pandas DataFrames with intelligent schema reconciliation and fuzzy matching.
Data Type Classifier
An intelligent classification engine that categorizes construction data into structured, semi-structured, or unstructured types while recommending optimal storage and processing tools.
Data Source Audit for Construction
A comprehensive auditing tool to map, analyze, and optimize data flows and systems within construction organizations.
Data Silo Detection
A specialized diagnostic tool that identifies, maps, and prioritizes the remediation of disconnected data repositories in construction organizations.
Drawing Analyzer for Construction
A powerful utility to extract dimensions, annotations, symbols, and metadata from PDF and DWG construction drawings for automated takeoffs and quality control.
DWG to Excel Data Converter
A professional utility for extracting structured CAD data, including layers, blocks, and geometry, from DWG files into Excel spreadsheets without requiring AutoCAD.
METADATA
Featured*
