Convert OSM to XLSX

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

OpenStreetMap features as spreadsheet rows.One sheet, one row per feature, with the shape as text in the first column.

  1. What you get

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

    Numbers, dates and true and false values are typed cells, not text. Coordinates are in WGS 84 longitude and latitude.

  2. How features map to rows

    Tagged nodes become points. Ways become lines, or polygons when they are closed and tagged as areas. Route and multipolygon relations become multilines and multipolygons.

    Common tags such as name, highway and building become columns. The other tags are kept as JSON in other_tags. If the file yields several layers, they are joined into one sheet, and a layer column names where each feature came from.

  3. What changes or is left out

    Untagged nodes, other relations, versions and authors are dropped.

    A feature without a geometry keeps its row with an empty WKT. A column already named WKT is renamed WKT_1. Lists and nested values become JSON text. Times with a time zone are written in UTC.

    A cell holds at most 32,767 characters. If a shape is longer, its cell is left empty and a warning is given. A map of more than 1,048,575 features stops with resource_limit.

OSM and XLSX.What each format is.

The formats

From · OSM

OpenStreetMap Data

OpenStreetMap nodes, ways and relations with their tags, as .osm XML or the smaller .osm.pbf.

Extensions
.osm .osm.pbf
MIME type
application/vnd.openstreetmap.data+xml
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 OSM to XLSX conversion through the API, for your app or your agent.

terminal
$ cv convert report.osm report.xlsx
$ cv convert report.osm report.xlsx

Questions.What people ask about OSM to XLSX.

01OF 04

Yes. Both the .osm XML and the smaller .osm.pbf are OpenStreetMap data, and the conversion reads them into the same kind of workbook.

Common tags such as name, highway and building have their own columns. The rest are kept as JSON text in other_tags.

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

The map has more than 1,048,575 features, which is more rows than the sheet can take. The conversion stops with resource_limit.

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