Convert GDB to XLSX
Turn GDB 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 GDB files on the dialor turn it to pick what to do
Every waypoint, route and track in one sheet.One row per feature, with its shape as WKT and each attribute in its own column.
What you get
A workbook with one sheet, named after the file and cut to 31 characters. Each feature is one row. The first column, named WKT, holds the shape as text, and every attribute follows as its own column.
Numbers, dates and true and false values are typed cells. Lists and nested values become JSON text, and times with a time zone are written in UTC. Columns that no feature fills are left out.
How features are laid out
Waypoints become points, routes become lines and tracks become multilines with a part for each segment. Every route and track point also becomes a point of its own, with its time in UTC and the values the device logged with it, such as satellites, heart rate as hr and cadence as cad.
A layer column names where each row comes from: waypoints, routes, tracks, route_points or track_points. The track_fid and route_fid columns tie each point to its track or route.
Coordinates are written in WGS 84 longitude and latitude. Heights stay in the shapes as Z and in the ele column of points.
Edge cases
A feature without a geometry keeps its row with an empty WKT. A column already named WKT 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 stops with
resource_limit.
GDB and XLSX.What each format is.
The formats
Garmin MapSource Database
Waypoints, routes and tracks saved by Garmin MapSource and BaseCamp in their GDB database.
- Extensions
- .gdb
- MIME type
- application
/x -garmin -gdb - Kind
- Text and data
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 GDB to XLSX conversion through the API, for your app or your agent.
$ cv convert report.gdb report.xlsx$ cv convert report.gdb report.xlsxQuestions.What people ask about GDB to XLSX.
Not always. A feature without a geometry keeps its row, and its WKT cell is empty.
WGS 84 longitude and latitude. Heights stay in the shapes as Z and in the ele column of points.
Use the layer column. It holds waypoints, routes, tracks, route_points or track_points for each row.
When the map holds more than 1,048,575 features. Fewer than that fit in the workbook.