Spreadsheet exports move Analyze data into Excel or Google Sheets for your own pivots, filtering, and calculations.
In Analyze, spreadsheet exports are XLS files, from two tabs:
| Export | What it contains | Where |
|---|---|---|
| Audit Log XLS | Every tracked entry and its comments, plus a summary and weather | Audit Log tab — Export → choose months → Export XLS |
| MAR XLS | Medication administrations for the selected months | MAR Reporting tab — Export → choose months → Export XLS |
| MAR count XLS | Count history for one counted medication | MAR Reporting — COUNT REPORT → Export → choose months → Export XLS |
The Dashboard does not export to a spreadsheet — it exports a PDF of the graph you have open.
Organization-wide Excel exports (Overview, Team Summary, and similar) are in Exports from Admin Reports.
Exporting an Audit Log XLS
- Open Analyze → Audit Log.
- Optionally set category chips and search (they apply to the export).
- Click Export, choose a year if needed, select one or more calendar months (up to 12), then Export XLS.
One month downloads as a single workbook; multiple months arrive as a ZIP. The Export dialog shows progress while months are processed, and you’ll get a notification when ready.
The dialog lists years from when the profile was created through the current year. You can export at most 12 months at a time — switch years to reach older history.
The on-screen date range is for browsing the log only; the export uses the months you select.
Exporting a MAR XLS
- Open Analyze → MAR Reporting.
- Click Export, choose a year if needed, select one or more calendar months (up to 12), then Export XLS.
One month downloads as a single workbook; multiple months arrive as a ZIP. You’ll get a notification when ready.
Exporting a MAR count XLS
- Open Analyze → MAR Reporting.
- Open COUNT REPORT for the counted medication.
- Click Export, choose a year if needed, select one or more calendar months (up to 12), then Export XLS.
One month downloads as a single workbook; multiple months arrive as a ZIP. You’ll get a notification when ready. The on-screen date range is for browsing the count table only; the export uses the months you select.
What’s in the Audit Log XLS
The workbook has a few sheets:
- Overview — a per-category summary: Section, Category, Item, Frequency, and Duration (minutes)
- All Data + Comments — one row per entry, with Date, Section, Category, Item, Duration, Author, the Note text, when the note was created, and — for edited comments — Edited By and Edited At
- Weather — daily pressure, temperature, humidity, precipitation, and moon phase for the range
What’s in the MAR count XLS
One sheet of count history for that medication: Date, Time, Admin, On Hand, Received, Given, Disposed, Remaining, Source, Typed name, and Variance.
Dates and times
Dates and times use your profile’s date and time format, shown in the profile’s time zone. If you combine exports across profiles in different time zones, a “9pm” in one profile is a different absolute moment from “9pm” in another.
Common uses
- Custom analysis — pull the audit log into a spreadsheet and pivot by category, time of day, or day of week
- Sharing data — hand a colleague a spreadsheet they can sort and filter themselves
Privacy reminder
Exports often contain identifying data (names, dates, descriptions). Treat them like any other sensitive document — encrypted storage, secure email, careful with cloud sync.
Limitations
- No images or videos. Spreadsheets are text only.
- No formatting applied. Excel won’t apply profile colors; it’s plain data.
Common questions
- Is there a JSON or API export? — Not for end users; the Analyze exports are PDF and XLS.
- Can I schedule recurring exports? — No. Each export is on-demand (pick the months you need).
- Can a Guest export? — Yes, for the views they can see.
- My export is empty. — Check filters and which months you selected — an over-narrow filter can return zero rows.