Spreadsheet exports move Analyze data into Excel or Google Sheets for your own pivots, filtering, and calculations. They're more flexible than PDFs but less readable for a quick handover.
In the Analyze section, spreadsheet exports come out as XLS files, and they're available 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 tab doesn't export to a spreadsheet — it exports a PDF. Spreadsheet export appears when your plan includes exporting.
Exporting
- Open the Audit Log or MAR Reporting tab.
- Set your date range (and, on the Audit Log, your category filters 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 — not a fixed ISO format. If you're combining exports across profiles in different time zones, keep that in mind: 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 to find patterns the standard charts don't show.
- 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 or special formatting; 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? — Not currently — 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.