← 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. The format was getting in the way.
A large treatment spreadsheet had become difficult to navigate and harder to translate into a clear user experience. The project needed more than a prettier table. It needed a new information structure and an interface built around search.
- 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.
TREATMENT DATABASEFind the right information
SearchSearch treatments, categories and details ⌕
All categoriesEvidence levelPopulation
Treatment recordCategory · Summary · Evidence→
Focused resultCategory · Summary · Evidence→
Information detailCategory · Summary · Evidence→
Screenshot placeholder · Replace with approved application capture
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.
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.
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.
TREATMENT DATABASEFind the right information
SearchSearch treatments, categories and details ⌕
All categoriesEvidence levelPopulation
Treatment recordCategory · Summary · Evidence→
Focused resultCategory · Summary · Evidence→
Information detailCategory · Summary · Evidence→
Screenshot placeholder · Replace with approved application capture
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.