Skip to content
SPEIA
SPEIA

Infomed · 2026

Monthly Excel reports reformatted automatically, and a dashboard to read them

Automated restructuring of monthly Excel files into a reference template, paired with a reporting dashboard.

Sector
Healthcare · reporting & data
Scope
Dashboard & data processing
Status
Internal tool
Visit the live site
Internal tool — not public

Internal tool — not public

Measured results

2

file families automated

1

single reference template enforced

The problem

Every month, reports arrived in slightly different shapes and had to be manually reworked into the reference format before they could be used. Repetitive, slow, and prone to copy errors — exactly the kind of task a program does better than a person.

Stack

Next.jsTypeScriptExcel / OpenXMLNode

Services involved

What we did

  • Analysis of the gaps between incoming files and the reference template, then automation of the conversion.
  • A Next.js dashboard to read consolidated data without reopening a spreadsheet.
  • Development environment pinned and documented so the project restarts cleanly on any machine.

A project, a question, or just a doubt about your current site?

The first conversation costs nothing and mainly serves to find out whether we're the right people.

Bespoke development

Modern, robust technology

Security & privacy

Your data is protected

Support

From analysis through to help

Scalable

Your solution grows with you