Convert GTFS to CSV

Turn GTFS files into CSV. A CSV with one row for each feature: its shape as WKT in a first column named WKT, then every attribute as a column.

Converted in an isolated sandbox on our serversDeleted after 24 hours

Drop GTFS files on the dialor turn it to pick what to do

A transit feed as one table of shapes.Every stop and route becomes a row, with its outline as WKT in the first column.

  1. What you get

    One CSV file with one row for each feature. The first column is named WKT and holds the feature's shape. Every attribute follows as its own column.

    Stops become points and keep all their columns. Each route becomes a line with its columns. Coordinates are written in WGS 84 longitude and latitude.

  2. How routes are drawn

    A route follows the shapes its trips use. For trips without a shape, the line runs through their stops in order.

    Because stops and routes are different layers, they are joined into one table. A layer column names where each row came from.

  3. What changes

    Features without a geometry keep their row, with an empty WKT. If a column is already named WKT, it is renamed WKT_1 so the shape column stays first.

    Lists and nested values become JSON text, so they fit in a single cell.

    To combine the result with other tables, see merge CSV. For other options, see every CSV conversion.

GTFS and CSV.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 · CSV

CSV

Rows of comma-separated values. The plainest way to move a table between programs.

Extensions
.csv
MIME type
text/csv
Kind
Text and data

In your code.The same GTFS to CSV conversion through the API, for your app or your agent.

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

Questions.What people ask about GTFS to CSV.

01OF 04

It holds the shape of each feature as WKT. Stops are points and routes are lines, in WGS 84 longitude and latitude.

One file. The layers are joined, and the layer column shows whether a row came from stops or routes.

They stay in the file with an empty WKT.

It is renamed WKT_1, and the new shape column is named WKT.

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