Convert FGB to XLSX

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

Map features as rows in a spreadsheet.One row for each feature, with its shape as text and every attribute in a column.

  1. What you get

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

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

  2. Coordinates

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

  3. Special cases

    A feature without a geometry keeps its row, and its WKT cell is empty. If a column in the source is already named WKT, it is renamed WKT_1 so the shape column keeps its name.

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

FGB and XLSX.What each format is.

The formats

From · FGB

FlatGeobuf

FlatGeobuf, a compact binary format for map features that streams over the web.

Extensions
.fgb
MIME type
application/flatgeobuf
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 FGB to XLSX conversion through the API, for your app or your agent.

terminal
$ cv convert report.fgb report.xlsx
$ cv convert report.fgb report.xlsx

Questions.What people ask about FGB to XLSX.

01OF 04

The first column is named WKT. It holds each feature's shape as WKT text.

Either the feature has no geometry, or its shape is longer than the 32,767 characters a cell holds. In the second case the conversion gives a warning.

They become JSON text in the cell.

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

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