Convert GTFS to XLSX

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

Stops and routes in one Excel sheet.Each stop is a point and each route is a line, one row apiece.

  1. What you get

    An Excel workbook with one sheet, named after the file and cut to 31 characters. Each row is one feature: a stop or a route. The first column, WKT, holds its shape as text. Every attribute follows as its own column.

    Numbers, dates and true and false values are typed cells, so Excel treats them as numbers, dates and booleans. Coordinates are written in WGS 84 longitude and latitude.

  2. Stops and routes

    Stops become points and keep all their columns. Each route becomes a line with its columns. The line is drawn along the shape its trips follow. For trips without a shape, it runs through their stops in order.

    When several layers are joined, a layer column names where each feature came from.

  3. What changes

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

    A feature without a geometry keeps its row, and its WKT cell is empty. 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 the conversion gives a warning.

    A map of more than 1,048,575 features fails with resource_limit. For more on the format, see every XLSX conversion.

GTFS and XLSX.What each format is.

The formats

From · GTFS

GTFS Feed

A transit agency's stops, routes, trips and timetables as the zip of GTFS text files that Google Maps and trip planners read.

Extensions
.gtfs.zip
MIME type
application/x-gtfs+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 GTFS to XLSX conversion through the API, for your app or your agent.

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

Questions.What people ask about GTFS to XLSX.

01OF 04

Each stop is one row with a point in the WKT column. Each route is one row with a line in the WKT column.

WGS 84 longitude and latitude.

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

A shape longer than 32,767 characters leaves its WKT cell empty. The row stays, and you get a warning.

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