Turn your Outlook calendar into a timesheet

If your calendar already records where your time went — client meetings, project blocks, clinic hours — the timesheet is one export away. OutlookXL writes every event with its duration in hours and totals them by category, week and calendar.

Export your calendar Free to try. No account needed.

Calendar events exported with duration in hours, ready to total by category or week
Calendar events exported with duration in hours, ready to total by category or week

How to build a timesheet from Outlook

  1. In Outlook, give events a category per client or project (Outlook's colored categories). Existing events can be re-categorized in bulk from the list view.
  2. Open the app, sign in with Microsoft, and tick the calendar(s) to include.
  3. Pick the date range — *this month*, *last month*, or a custom range for a billing period.
  4. Tick Exclude all-day and "free" events from hour totals so vacations and tentative blocks do not count.
  5. Click Export .xlsx.

What the workbook contains

The free plan exports the first 100 rows of the Calendar sheet; Pro removes the cap and adds the summary sheets.

Who uses it this way

Accuracy notes

Durations come from the event's start and end, so a 30-minute meeting that ran long still counts 0.5 h unless you adjust the event. Recurring meetings are expanded into their actual occurrences. Overlapping events are both counted — tick *Exclude free events* and mark the one you did not attend as Free, or decline it.

Your calendar, mail and contact data are read in your browser straight from Microsoft and are never uploaded to our servers.

Frequently asked questions

Can I export more than one month?

Yes. Choose "Custom" and enter any From/To dates — a quarter, a year, or a project's whole span.

Do categories have to be set in Outlook?

Yes, the category column comes from Outlook's categories. Events without one are totalled under "(No category)".

Can I export a CSV instead?

Yes. Export .csv writes the Calendar sheet as a plain file; the summary sheets need the .xlsx workbook.

Is my calendar sent to your servers?

Your calendar, mail and contact data are read in your browser straight from Microsoft and are never uploaded to our servers.