Excel export for Ops managers

By the Mail → Excel team · Updated 2026-10-20

SLAs are measured from the first message, not from when someone noticed it. The export gives you the real first-message timestamp. This page lists the exact columns, an example row and the command that produces it.

Columns to keep

Column	Why it matters
`request`	Short description of the incoming request.
`owner`	The person responsible — assignments often happen in Cc.
`sla`	Target response window; measured from the first inbound message.
`status`	Fixed vocabulary: open / in progress / done / blocked.
`channel`	Where the request came from (email, form, phone).

Example row

One real-shaped row from this role’s export:

request	owner	sla	status	channel
Access request #482	D. Ivanov	4h	open	email

Export it in one command

python mail_to_excel.py \
  --host imap.example.com --user you@example.com \
  --days 31 --fields request,owner,sla,status,channel \
  --out ops-manager.xlsx

The --fields option is what turns a raw dump into a report your role can use.

Provider notes

Shared mailbox exports need a user with full access; test with one folder before running the whole mailbox.

Two pitfalls that ruin the file

SLA looks fine but customers complain — Measure from the earliest message in the thread, not the latest reply.
Owners are missing for half the rows — Export the To/Cc fields too — assignment often happens in Cc.

Next step

Step-by-step: export ops manager email to Excel · all roles · ready script ($3)

FAQ

Can this feed a dashboard?

Export CSV on a schedule and point your BI tool at the file or a synced sheet.

How do I avoid duplicates across runs?

Filter by date range and use the message id column as the unique key.

Is there a ready script for this?

Yes — the Python script exports any IMAP mailbox with the fields listed above; it costs $3 and runs locally.

Related guides

Export ops manager email to ExcelStep-by-step with the same columns and command.
All roles20 professions, one export method.