Skip to content

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.

Read the short answer

Try the builder on the sample data, or drop in your own CSV. It is parsed in your browser and never uploaded.

Antibiogram Builder
Synthetic sample dataset
Parsed in this browser, never uploaded.

under 40 40 to 59 60 to 74 75 to 89 90 and over n<30, below the reporting threshold n/t, not tested on this panel

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.

Computed from your own isolates, never from a national average.

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.

From line list to antibiogram report.
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

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.