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.
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.
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.
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
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
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.
$ cv convert report.gtfs.zip report.xlsx$ cv convert report.gtfs.zip report.xlsxQuestions.What people ask about GTFS to XLSX.
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.