RideSheet

RideSheet

RideSheet is a tool for operating and reporting on small demand-response transportation services. It supports rural, small urban, and urban specialized services that are ready to move away from paper, whiteboards, and ad-hoc spreadsheets and move to systematic and accessible tracking tools.

Features:

  • Built on Google Cloud Infrastructure. Because RideSheet is in the cloud, you benefit from features like automatic backups and version tracking, easy collaboration across your organization, and data security that meets HIPAA regulations.
  • Spreadsheet-Based. Anyone with experience in Excel, Google Sheets, or other spreadsheet applications will find it easy to learn RideSheet. Plus, it’s flexible and easy to customize.
  • Manages Tracking, Manifests, and Reports. RideSheet handles tracking customers, trips, runs and more, and makes it easy to generate manifests and reports. It is customizable to handle thorny problems such as splitting trips between multiple funding sources.


Technical details on RideSheet and information on the recent Version 1 release are available on Github.



RideSheet Introductory Video

RideSheet User Testimonials



How Lake County Made the Switch to RideSheet



The director and staff of Oregon's Lake County Senior Center weigh in on how RideSheet impacted their organization.


Teamwork: Clay County's Secret to Success with New Technology


How Clay County, Kansas switched from paper and pencil for their demand-responsive transportation program to RideSheet.



RideSheet University Training Resources

Learn more about RideSheet and if it is right for your organization.

Tutorial Videos Description
Introducing RideSheet RideSheet is a simple, spreadsheet-based tool for operating and reporting on small demand-response transportation services. We held a webinar on January 21, 2025 to introduce RideSheet.
What You Need to Succeed with RideSheet Getting started with RideSheet is about more than installing software. It's about setting your team up for success. In this video, we walk through the key technical and organizational factors that help small transit agencies implement RideSheet successfully. You'll learn what you really need to have in place before rollout, how to prepare your staff, and what successful organizations do differently when adopting new tools.
How to Get RideSheet: Installation Options and Support This video explains the different ways to get RideSheet, including installing it yourself or working with a contractor. It covers what skills and resources are helpful for managing your own installation, what to expect over time, and when it may make sense to get outside support.
Google Workspace for RideSheet: What You Need to Know If you're considering RideSheet for your organization, you'll need a Google Workspace plan. We walk through the basics of getting Google Workspace, including how commercial and government agencies can sign up, and how eligible nonprofits may qualify to receive Google Workspace at no cost through the Google for Nonprofits program.
Getting Started With RideSheet: Installation Guide This video walks through how to create and install your own working copy of RideSheet. You’ll learn how to make a copy of the RideSheet template, authorize the installation, and set up the required folders in Google Drive. This setup will give you a test version of RideSheet that you can use to follow along with the rest of the tutorial series.
RideSheet University: System Overview Learn the layout of RideSheet in just a few minutes. This quick overview walks through the main parts of the system and shows where everything is, so new users can get oriented before diving into the rest of the RideSheet University tutorials.
RideSheet University: Setting up Vehicles, Drivers, and Services In this short tutorial, learn how to set up the three core data tables that power the system: Vehicles, Drivers, and Services. These records are used throughout RideSheet for scheduling trips, assigning drivers and vehicles, and tracking services for reporting.
RideSheet University: Working with Addresses Learn how addresses work in RideSheet and how to enter them correctly. This video explains how addresses are validated, how to add extra details like notes or specific locations with plus codes, and how to save frequently used addresses to make data entry faster.
RideSheet University: Managing Customers Learn how to create and manage customer records in RideSheet. This video shows how to add new riders, enter basic contact and address information, and set default values that automatically fill in when creating trips. Setting up customer information correctly helps speed up trip entry and ensures consistent scheduling and reporting.
RideSheet University: Creating and Assigning Trips Learn how to create trips in RideSheet and take advantage of tools that make trip scheduling faster and more accurate. This video shows how default customer information is used automatically, how travel times and distances are estimated, and how to add stops or return trips to build a complete itinerary. These features help reduce data entry time and ensure trips are properly assigned to drivers and vehicles.
RideSheet University: Understanding Runs Learn what runs are and how they connect trips to drivers and vehicles. This video explains how runs define when resources are scheduled to operate, and how RideSheet checks for scheduling conflicts. Setting up runs ahead of time helps ensure trips are properly assigned and operations stay organized throughout the day.
RideSheet University: Reviewing and Archiving Trip Data Learn how to review completed trips and runs and move operational data into the reporting workflow. This video shows how to update trip results, record actual run details such as times and odometer readings, and archive verified data so it is ready for reporting.
RideSheet University: Creating and Customizing Driver Manifests Learn how to create driver manifests for scheduled runs and customize the manifest layout to meet your organization's needs. This video shows how to generate manifests for a specific day, understand the information included for drivers, and modify the template to add fields or change formatting. Driver manifests provide clear instructions for drivers and create a simple way to capture run details that can be entered back into RideSheet after service is completed.
RideSheet University: Turning Your Data into Reports Learn how to use your archived trip and run data to create reports. This video demonstrates several ways to work with RideSheet data, including copying data into Google Sheets, exporting it to Microsoft Excel, and building dashboards using reporting tools like Google Data Studio. RideSheet stores data in a clear, open format, making it easy to analyze, summarize, and generate the reports your organization needs.
RideSheet University: Recovering from Mistakes Learn how to prevent and recover from data entry mistakes. This video demonstrates built-in safeguards such as data validation, automatic header protection, edit history, and version history in Google Sheets. These tools help ensure your data stays accurate and allow you to quickly restore information if something is entered incorrectly or accidentally deleted.