← Back to work

Treatment Database · Case Study

Turning a Complex Treatment Spreadsheet Into a Searchable Web Application

A nonprofit treatment information platform, redesigned around how people find and use the data.

The challenge

The information was valuable. It needed a platform built around how people use it.

The client had outgrown both a 100+ page website approach and a complex Excel-based treatment database. Spicy Dragon created an accessible, mobile-first web app that lets users search conditions, select symptoms, find treatments and specialists, and print or save results as PDFs.

Organization
The Neuroplasticity Alliance
Project Type
Custom web application
Focus
Treatment information discovery
Interface
Search, filters and detail views
Data Structure
Structured treatment records
Delivery Approach
Design-led rapid development

Existing process → focused application

From rows and columns to meaningful paths.

Before • Spreadsheet
Complex treatment spreadsheet containing dense intervention descriptions and conditions
After • Application
NPA treatment database interface showing symptom selection and searchable treatment results
01

Existing process

A data structure built for storage, not discovery.

The spreadsheet contained dense treatment records and many attributes. Finding relevant information meant scanning, filtering and interpreting a structure that was not designed as a public-facing experience.

02

The solution

Search and filters that reflect the questions people ask.

The application reorganizes the content into scannable results, purposeful filters and consistent detail views. Each element supports finding, comparing and understanding treatment information.

03

The application

A focused interface with room for the information to breathe.

Clear hierarchy, restrained controls and structured detail panels turn complex business information into a usable application rather than a spreadsheet placed on the web.

04

The result

A clearer path through complex information.

The finished direction replaces spreadsheet navigation with a purpose-built experience. Final approved screenshots and factual outcome details can be added here without changing the page structure.

A better process starts here

Have a spreadsheet that should be an application?

Tell us about the ugly spreadsheet, manual process, tracker, form or workflow you want to improve.