How to Flatten FHIR JSON Into a Table You Can Actually Analyse
Turn nested FHIR JSON into flat rows: leaf paths, collapsing array indices, one row per resource vs one value per cell, and picking the right columns.
Read more →Blog
Page 3 of 6 — guides, tutorials and tips from our free, privacy-first online tools.
How to Convert a FHIR Bundle to CSV Without Losing Data
Turn a FHIR Bundle into a clean CSV: why flattening is hard, join vs expand for repeats, picking columns, and opening the file in Excel safely.
Read more →
837 vs 835: How Healthcare Claims and Remittance Files Work Together
A practical guide to the X12 837 claim and 835 remittance (ERA): what each contains, how they reconcile, and how to read the segments that matter.
Read more →
The Seven Characters of an ICD-10-PCS Code, Explained
What each of the seven ICD-10-PCS characters means, why a code only exists when they come from one table row, and how to spot the errors that get claims denied.
Read more →
Excision vs Resection in ICD-10-PCS: How to Tell Them Apart
One word separates Excision from Resection: portion or all. Here is how the PCS body part key decides it, why it moves the DRG, and the cases that trip coders up.
Read more →
Conventional vs SI Units in the Clinical Lab: A Complete Guide
Why labs report results in mg/dL or mmol/L, how conventional and SI units differ, a group-by-group tour, and the pitfalls of reading cross-border lab results.
Read more →
The 18 HIPAA Safe Harbor Identifiers Explained
A complete guide to the 18 HIPAA Safe Harbor identifiers: what each category covers, why unstructured text is hard, and how to detect and redact PHI privately.
Read more →
mg/dL to mmol/L: Glucose, Cholesterol and Creatinine Conversion
Exact mg/dL to mmol/L conversion factors and worked examples for glucose (0.0555), cholesterol (0.02586), triglycerides (0.01129) and creatinine (88.42).
Read more →
What Is FHIR? A Healthcare IT Guide
A practical intro to FHIR for healthcare IT: what resources are, how R4 works, how it compares to HL7 v2, and how to validate resources before sending.
Read more →
Understanding ICD-10 Codes: Structure and Billing
A practical guide to ICD-10-CM diagnosis codes: how they are structured, what makes a code billable, how to read Excludes notes, and how to look codes up fast.
Read more →
HL7 ACK Codes Explained: AA, AE, and AR (MSA-1)
What HL7 ACK codes AA, AE, and AR mean in MSA-1, how they differ from CA/CE/CR, and how a receiver decides which acknowledgment to send. With examples.
Read more →
How to Convert DICOM to JPEG or PNG Safely
A practical guide to converting DICOM images to JPEG or PNG: window/level, lossy vs lossless, multi-frame export, and keeping protected health information safe.
Read more →