Convert DGN to XLSX

Turn DGN documents into XLSX. A workbook with one sheet named after the file, cut to 31 characters, and one row for each feature: its shape as WKT in a first column named WKT, then every attribute as a column, with numbers, dates and true and false as typed cells.

Converted in an isolated sandbox on our serversDeleted after 24 hours

Drop DGN files on the dialor turn it to pick what to do

A spreadsheet with one row per feature.Each shape is written as WKT, and each attribute gets its own column.

  1. What you get

    A workbook with one sheet, named after the file and cut to 31 characters. Each feature in the DGN becomes one row.

    The first column is named WKT and holds the feature's shape as WKT text. Every attribute follows as its own column, with numbers, dates and true and false values written as typed cells.

  2. What changes

    Features without a geometry keep their row, and the WKT cell is empty. If the file already has an attribute named WKT, that column is renamed WKT_1.

    Lists and nested values become JSON text. Times with a time zone are written in UTC.

  3. Limits

    A cell holds at most 32,767 characters. If a shape is longer than that, its WKT cell is left empty and a warning is given.

    A map of more than 1,048,575 features fails with resource_limit. To work with several workbooks as one, try merge XLSX.

DGN and XLSX.What each format is.

The formats

From · DGN

MicroStation Design

MicroStation V7 design files, the CAD drawings of road, rail and utility engineering.

Extensions
.dgn
MIME type
image/vnd.dgn
Kind
Documents
To · XLSX

Excel Workbook

Excel's workbook format since 2007. Sheets, formulas, formats and charts in zipped XML.

Extensions
.xlsx
MIME type
application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Kind
Documents

In your code.The same DGN to XLSX conversion through the API, for your app or your agent.

terminal
$ cv convert report.dgn report.xlsx
$ cv convert report.dgn report.xlsx

Questions.What people ask about DGN to XLSX.

01OF 04

It takes the name of the file, cut to 31 characters. The workbook holds only this one sheet.

It is in the first column, named WKT, as WKT text. Features without a geometry have an empty cell there.

Its row is kept. The WKT cell is empty and its attributes are still written.

It stops with resource_limit when the map has more than 1,048,575 features.

More conversions.Other ways in and out of DGN and XLSX.