Station and stop names spreadsheet

Part of the process to enable Google Pay for Transit is to submit a spreadsheet that supplies station and stop names for your feed. This spreadsheet must be formatted in a particular way to ensure that we can process it correctly. The columns in your spreadsheet must appear as follows, in order:

Information in the spreadsheet you submit to us is used by Google Pay to display the correct long-form name for your stations and stops. Use our Station and Stop names template to get started. Each value is described in further detail below, along with an example.

Once you've filled out the spreadsheet, submit it through the Open Loop Transit Google form.

Location name and details

This value must be populated with data from the 9F4E tag. It's a good idea to enter this as a human-readable value. Whatever value you use, it must uniquely identify a location. The value can include IDs for stations, stops, and routes.

TfL Abbey Road

Full display name

This is the value to be displayed in the Google Pay app.

Abbey Road Tram Station

gps_lat

This geographic latitude is used in conjunction with gps_long to establish the location of your stations, stops, and routes.

0.0032115

gps_long

This geographic latitude is used in conjunction with gps_lat to establish the location of your stations, stops, and routes.

51.5309468

Place ID

This is the Place ID of the indicated location in Google Maps. You can use the Maps Place ID Finder to get this value.

ChIJFapKOPSn2EcRHP3RbxxWlTI

Example

Here's an example of a CSV file that has been completed correctly:

Location name/details Full display name for Google Pay app gps_lat gps_long Place ID
TfL Abbey Road Abbey Road Tram Station 0.0032115 51.5309468 ChIJFapKOPSn2EcRHP3RbxxWlTI