Compare lab results over time in one table
Reports from different labs, years and units become one table: markers down the side, dates across. Each value is shown against the range printed on its own report, never against a newer one.
Read lab reports, reconcile markers, view trends
Upload reports
One PDF or photo at a time
No report to hand? Load a sample. Samples are made-up data and use none of your allowance.
Free: 1 file per day, up to 10 pages, no account.
Files over 10 pages are converted up to page 10.
A page code is used only for a file over 10 pages or a second file in a day.
The file is processed in memory and deleted after conversion. How files are handled.
Reconcile markers
Names, units and ranges, matched
After a report is read, this step shows how each printed name and unit was matched. Nothing is changed silently: every conversion shows its factor.
View trends
Merged in this browser
Reports are grouped by initials and birth year so two people are never merged into one series.
Your merged series is stored in this browser only. It is not uploaded, and clearing site data removes it. Download a CSV to keep a copy.
Reports in this browser (0)
No markers yet.
Convert a report, or load the two samples above, then pick a marker from the list. Each marker shows its values over dates, each against the range printed on its own report.
What comparing lab results over time involves
Three things get in the way when you line up years of blood work. The same marker is spelled differently from lab to lab. The same marker is reported in different units, mg/dL on one report and mmol/L on the next. And each lab prints its own range, so a result that sat inside one report's range can fall outside the range printed on another.
BioPanel handles each of these in the open. Names are matched to one marker name, with the printed name kept beside it. Units are converted only where the factor is exact, and the factor is shown. Each value keeps the range printed on its own report, drawn as a band on that date, and a past result is never re-judged against a later range.
The merged table is built in your browser from the reports you add. It organises results and does not interpret them. It is not medical advice, and a line going up or down says nothing about whether that is good or bad.
Building a series from your reports
Add reports in any order. They are sorted by collection date.
Add the first report
Upload a PDF or photo, or load the two samples to see how it looks. The rows are read, matched and kept in your browser.
Add each older or newer report
Upload them one at a time. A report that is already in the series is recognised and not added twice. Reports are grouped by the initials and birth year on them, so two people are never merged.
Check the unit for each marker
BioPanel shows each marker in the unit of its latest report. Where a conversion is exact you can switch the unit with Show in. Where it is not, the values stay as printed and are marked as mixed.
Read the values over dates
Pick a marker. The line shows its values by date, the bands show each report's own printed range, and the table under it lists every value, the printed range and both flags.
Download the merged table
Get a wide CSV with markers down the side and dates across, or a long CSV with one row per marker and date. Both open in Excel, Numbers and Google Sheets.
Doing it by hand, with a generic converter, or with BioPanel
What it takes to put three or more reports side by side.
| What is compared | Spreadsheet by hand | Generic PDF-to-Excel | BioPanel |
|---|---|---|---|
| Lining up marker names | You rename each row so the spellings match. | Every report keeps its own spelling, so rows do not line up. | Recognised markers share one name. Others keep their printed name. |
| Units that changed | You look up factors and convert each cell. | Numbers from different units sit in the same row. | Converted only where exact, with the factor shown. Other mixes are marked. |
| A different range on each report | One range gets typed in and applied to every date. | Ranges stay as loose text in separate files. | Each value keeps the range printed on its own report, drawn as a band on its date. |
| The same report twice | Easy to paste in again. | Easy to upload again. | Recognised and not added a second time. |
| Reading the trend | You build a chart. | No chart. | A line per marker with printed-range bands, and a table with every value. |
| More than one person | Separate sheets, kept by you. | Separate files, kept by you. | Grouped by initials and birth year, with a Person selector. |
| Where the history lives | In your sheet. | In each downloaded file. | In your browser only. It is not uploaded. |
| Judging the trend | Your call. | None. | None. BioPanel does not say whether a change matters. |
Questions people ask
How do I compare blood test results from different labs?
Add each report. BioPanel reads the markers, matches the names, reconciles units where the conversion is exact and puts every value in one marker-by-date table. Each value stays attached to the range printed on its own report, so the comparison does not borrow one lab's range for another's result.
Why does each date have its own range?
Labs print their own ranges, and the same lab can change a range between years. A value is only compared with the range printed on the report it came from. If you applied today's range to an old result, the old result could be flagged for a reason that was not true on the day.
Does BioPanel tell me whether a trend is good or bad?
No. It shows the values, the units, the printed ranges and where each value sits against its own range. It does not forecast, score or interpret. A clinician who knows your history is the person to ask what a change means. This is not medical advice.
What does mixed units mean?
The marker appears in a unit that has no exact conversion to the unit of the series, for example HbA1c in percent on one report and mmol/mol on another. Those values are kept as printed, shown with their unit, and left off the line so that two different scales are never drawn as one.
Where is my history stored?
Only in your browser's local storage on this device. It is not uploaded to a server. Clearing site data removes it, and a different browser or device starts empty, so download the merged CSV if you want a copy. If storage is blocked or full, the page says so.
What if two reports are from the same day?
Only one value per marker and date is kept, the first one added, and the page tells you how many values were set aside. Reports from different days sit side by side as separate columns.
Can I keep a family's results together?
Reports are grouped by the initials and birth year printed on them, and a Person selector appears when there is more than one group. Reports with no readable patient details go into an unlabelled group. The initials and birth year stay in your own browser.
What is the difference between the wide and the long CSV?
The wide CSV has one row per marker and one column per date, which suits reading and charting in a spreadsheet. The long CSV has one row per marker and date with the printed value, unit, range and both flags, which suits pivot tables and databases.
How many reports can I keep?
A browser gives each site a few megabytes of storage and one report takes a few kilobytes, so most people never reach it. If storage fills up, the newest report is not saved and the page says so; download a CSV and remove older reports to make room.
Can I import an older spreadsheet into BioPanel?
No. BioPanel reads lab reports, not spreadsheets. The exports are for your own use in Excel or Sheets, where you can combine them with anything you have already typed by hand.