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 |