Convert FILEGDB to XLSX

Turn FILEGDB files 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 FILEGDB files on the dialor turn it to pick what to do

A spreadsheet with one row per feature.Each feature becomes a row, with its shape as WKT and its attributes as columns.

  1. What you get

    A workbook with one sheet, named after the file and cut to 31 characters. The first column is named WKT and holds the shape of each feature as WKT. Every attribute follows as its own column.

    Numbers, dates and true and false values are written as typed cells. Times with a time zone are written in UTC. Lists and nested values become JSON text.

  2. Coordinates

    Coordinates are written in WGS 84 longitude and latitude, converted from the source's system, such as Korea's EPSG:5186. If the data names no system, the coordinates keep their values as they are.

  3. Special cases

    A feature without a geometry keeps its row, with an empty WKT cell. If the file already has a column named WKT, it is renamed WKT_1.

    A shape longer than the 32,767 characters a cell holds leaves its cell empty, and a warning is given. A map of more than 1,048,575 features fails with resource_limit.

    When the geodatabase has several layers, they are joined into one sheet. A layer column names where each feature came from.

FILEGDB and XLSX.What each format is.

The formats

From · FILEGDB

Esri File Geodatabase

An ArcGIS file geodatabase, the .gdb folder of feature classes, zipped to send as one file.

Extensions
.gdb.zip
MIME type
application/x-filegdb+zip
Kind
Text and data
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 FILEGDB to XLSX conversion through the API, for your app or your agent.

terminal
$ cv convert report.gdb.zip report.xlsx
$ cv convert report.gdb.zip report.xlsx

Questions.What people ask about FILEGDB to XLSX.

01OF 04

No. Several layers are joined into one sheet, and a layer column names the layer each feature came from.

WGS 84 longitude and latitude. Coordinates are converted from the source's system. If the data names no system, they are kept as they are.

They keep their row. The WKT cell is empty.

The map has more than 1,048,575 features. That is more than one sheet can hold, so the conversion stops.

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