Antibiogram report layout
Antibiogram template that fills itself from your lab export
Most teams start from an Excel antibiogram template copied from another hospital. The layout is the easy part. Filling it correctly every year is where the hours go.
Try the builder on the sample data, or drop in your own CSV. It is parsed in your browser and never uploaded.
Short answer
An antibiogram template is a grid with organisms in rows and antimicrobials in columns, where each cell holds the percent of isolates susceptible and each row shows the number of isolates tested. A good template also states the period, the duplicate rule and the breakpoint version. Antimicrobe produces that report from a lab CSV, so the template is filled by the same rules every time.
What a standard antibiogram template contains
The layout most hospitals use follows CLSI M39. Gram negative and gram positive organisms sit in separate tables because the drugs tested differ. Each row is a species, each column a drug, and each cell is the percent susceptible. A column for the number of isolates sits next to the organism name, so a reader can see how much data stands behind each percentage.
- Organism rows with the number of first isolates per patient
- Drug columns grouped by class, with blank cells where a drug is not tested or not appropriate
- Percent susceptible in each cell, never percent resistant mixed in
- A note on species with fewer than 30 isolates
- The period covered, the duplicate rule and the breakpoint version in the footer
Example antibiogram report built from a lab export
The example below shows what goes in and what the finished report shows. The input is the susceptibility line list your laboratory system already exports. The output is the printable table the committee reviews, plus a CSV of the same numbers if you want them in your own document.
| Lab export field | Antibiogram report output |
|---|---|
| Patient ID and collection date | First isolate per patient per period, as CLSI M39 describes |
| Organism | One row per species with its isolate count |
| Drug and S, I, R interpretation | Percent susceptible per drug and organism |
| Location and specimen source | Separate tables by unit or source when you need them |
Why an Excel antibiogram template breaks
A spreadsheet template holds the layout but not the rules. Every year someone removes duplicate isolates by hand, decides how to treat intermediate results and retypes percentages into the grid. Small differences in those steps change the numbers from one year to the next, and nobody can tell whether resistance moved or the method did. The trade-offs are covered in more detail in antibiogram software vs spreadsheet.
Who uses this report
The buyer is a laboratory supervisor, stewardship pharmacist or infection preventionist who publishes the annual antibiogram and wants it right the first time. The Lab plan produces the cumulative antibiogram with CSV and print exports for one facility. For the method behind the numbers see CLSI M39 antibiogram software, and to try the layout on sample data open the antibiogram generator.
Related reading: hospital antibiogram software, CLSI M39 antibiogram software, antibiogram generator, antibiogram software vs spreadsheet. The four steps from susceptibility testing data to an antibiogram cover the method end to end.
Questions
On this page's topic
What should an antibiogram template include?
Organisms in rows, drugs in columns, percent susceptible in each cell, the number of isolates per organism, and a footer with the period, the duplicate rule and the breakpoint version used.
Is there an antibiogram Excel template I can use?
You can build one, but the work is in filling it. Antimicrobe produces the report from your lab CSV and also exports the numbers as CSV, so you can paste them into an existing document if your committee prefers its own format.
How many isolates does a row need?
CLSI M39 advises reporting a percentage only for species with at least 30 isolates in the period. Smaller rows are flagged and shown with their raw count.
Does it need an interface to our laboratory system?
No. Your lab exports a susceptibility line list as CSV and you upload it and map the columns once.
More on antimicrobial resistance reporting
- hospital antibiogram The annual antibiogram is the most reused document a microbiology laboratory produces, and u...
- antimicrobial resistance surveillance software Resistance surveillance in a US hospital usually means one person, one annual spreadsheet an...
- CLSI M39 antibiogram software Most antibiograms that fail an M39 review fail on the same four things: repeat isolates coun...
- BD EpiCenter antibiogram EpiCenter already holds every Phoenix result your lab produced this year. The work starts af...
- VITEK 2 antibiogram Your VITEK 2 already produced every MIC and interpretation the antibiogram needs. The hard p...
- MicroScan antibiogram Your WalkAway already produced every MIC and interpretation the antibiogram needs. The year-...
Start with your own export
See your own resistance picture, cut the way you actually work
Build the antibiogram on the synthetic sample dataset, or drop in your own CSV and watch it parse without leaving your browser. When you want an account, one email address is the whole sign-up.
Your file is parsed in your browser and never uploaded. No card required.