Drop the HPRA human medicines XML list and QuickFlat turns it into clean, BI-ready tables — with a data-quality report, star-schema export and change tracking between two published versions. Everything runs in your browser; no file is ever uploaded.
Drag & drop an XML file
or ·
Explode = one row per value (joins the other multi-value fields).
Used when multiple values share a cell.
Columns — choose, rename & reorder
Preview
Data quality & validation
Load a file in the Convert tab to see its quality report.
Compare two published versions
Drop an older and a newer HPRA list to see products added, removed and changed (matched on DrugIDPK).
Baseline (older)
drag & drop or
Updated (newer)
drag & drop or
Loading the output
Power BI
- CSV / XLSX: Home → Get data → pick the file → Load.
- Star schema (ZIP): load each CSV, then relate them on
DrugIDPK— slice by every field with no row blow-up. - Mark
AuthorisedDateISOas a Date column for time intelligence.
Amazon QuickSight
- CSV or NDJSON upload best — both are flat and rectangular.
- New dataset → Upload a file (or S3) → confirm field types.
- Use Explode by Active Substance for substance-level analysis.