PrevIQ Docs
Open app

Export formats

Excel, CSV, JSON, and Markdown — exactly what each download contains and when to use it.

PrevIQ exports come in two flavors: reports (one lab's curated summary) and bulk exports (any filtered slice of the raw rollups). Both are available from the app and the API.

Report formats

From the Reports page or the /reports/client/{vendor_id} endpoint:

Format File Contents
JSON .json The full structured summary — same data the inline preview uses.
Excel .xlsx A formatted workbook, ready to share with clients.
CSV .zip One CSV per syndrome, plus a methodology note text file.
Markdown .md A plain-text summary for pasting into docs, tickets, or email.

Note

The CSV report is delivered as a ZIP because a client summary spans multiple syndromes — each gets its own CSV, and the methodology footnote ships as a sidecar file.

Bulk export formats

From the Explore page's export action or the /export/{format} endpoints. These return every row matching your current filters (syndrome, vendor, organism, min tested, grouping level):

Format File Best for
CSV .csv Spreadsheets, quick analysis.
Excel .xlsx Sharing; frozen header row for easy scrolling.
JSON .json Feeding another system; includes a meta block echoing your filters.

Bulk export columns

Every bulk CSV/Excel row contains:

Columns

Vendor, Syndrome, Panel, Organism,
Tested, Detected, Prevalence Rate,
Sample Size Tier, Clinically Reportable,
CI 95% Lower, CI 95% Upper,
Date Range Start, Date Range End

Tip

Rates and CI bounds are written as percentages (e.g. 15.2000%). The Clinically Reportable column is Yes / No (mirrors the Tier A/B vs. C distinction).

Which should I use?

Sharing with a client

Excel report — it's formatted and self-contained.

Loading into a BI tool or spreadsheet

Bulk CSV or bulk Excel from Explore, filtered to the slice you want.

Integrating with another system

JSON — or skip files entirely and call the API directly.

Dropping a summary into a doc or email

Markdown report.

Filtering before you export

A bulk export always reflects the current filters. To export "everything UTI-related for one lab," set Syndrome = UTI and Vendor = your lab, then export. Setting Min tested also lets you exclude small samples from the file.