Book a Demo

Product

SheetRails is a toolkit that lets you use Excel templates as an interface for your database.

This keeps data collection, analysis and reporting quick, simple, and in the hands of on the ground teams, and adds non-disruptive controls and storage solutions that ensure data is accurate, complete, centralised and secure.

A pragmatic and cost-effective way to build a robust data collection and management system

1. Design

Excel is the original no-code platform – a powerful, flexible and universally understood design tool.

Front-end design in Excel

Implementing teams set up templates for data collection and reporting in one or more master sheets – keeping control with the people who know the process best.

Back-end control in SheetRails

System Admins use the SheetRails Excel Add-in to add necessary controls and structure data flows. SheetRails provides an intuitive configuration process, and a practical framework for communication between implementing and systems teams.

Simple & Flexible

Making ongoing design changes is now as easy as editing the master template and re-publishing.

Try it for free

2. Data Collection

SheetRails generates web-app forms directly from the design sheet for foolproof data collection with a familiar look and feel.

An intuitive and powerful forms engine

Template sheets are configurable to the cell level for each view– lock in format & control exactly which cells can be viewed and edited. Easily create unique user-specific views from the same template.

Minimal Change Management

Each web app view looks and behaves exactly as the underlying sheet would, a seamless and familiar experience that reduces friction and onboarding requirements.

Easy, Secure Access

Each view is shared with one or more end-users via a web portal, or can be embedded in another application, including Microsoft PowerApps.

3. Data Storage

SheetRails organizes collected data in a secure database.

Centralised, Secure data storage

SheetRails guides the flow of data between sheet templates, webapps and a database to ensure data remains accessible, accurate, complete, centralized & secure.

Flexible database structure

Clients can make use of a standalone solution with a SheetRails hosted Microsoft Azure database or can choose to host the database on their own Azure infrastructure.

4. Reporting

SheetRails generates database linked web-app dashboards and reports from the design sheet

Dashboard design in Excel

Reporting is best left in the hands of those that need to use the information on a daily basis. Excel’s visualisation tools are powerful and your team already knows how to use them.

Database linked

Dashboards are designed in Excel, but data is drawn from the database, ensuring one source of truth and reports that are always accurate and up to date.

Secure & Focussed

Web-app views ensure viewers never access underlying data. User specific views can be created from the same reporting template to ensure end-users only see what they need to, without creating multiple dashboards.

Get started with SheetRails today!

Get in touch with our team today to discuss how SheetRails could work for you.

Book a Demo