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 |
| MAR XLS | Medication administrations in the range | MAR Reporting tab |
The Dashboard does not export to a spreadsheet — it exports a PDF of the open graph. Spreadsheet export appears when your plan includes exporting.
Organization-wide Excel exports (Overview, Team Summary, and similar) are in Exports from Admin Reports.
Exporting
- Open Analyze → Audit Log or MAR Reporting.
- Set your date range (and, on the Audit Log, your category chips and search).
- Click Export XLS.
The file reflects your current filters, so set them first.
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
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.
- Can a Guest export? — Yes for views they can see, when the plan includes exporting.
- My export is empty. — Check your filters and date range — an over-narrow filter can return zero rows.