Skip to content

Export your Google Calendar to Excel — with the hours already summed.

Drop your Google Calendar .ics and get a CSV — hours already summed by category, ready for Excel.

.ics files only

Free, no sign-in, nothing uploaded. Your calendar file is read in your browser and never sent to a server.

calendar-export.icsAug 18 – 22
  • Client work

    18.5h

  • Internal

    9h

  • Admin

    5h

32.5 hours across 14 events
Two events overlap — flagged for review, never merged

Watch Calendar Timesheet turn a calendar export into billable hours, in 61 seconds.

A real calendar export, turned into a timesheet in the actual product — no account, and nothing to upload to watch it happen.

The Calendar Timesheet film's title card, “16.25 hours. 13 billable.”, beside the totals strip, the overlapping-events warning and the category summary.1:01

One minute one second, narrated, with music playing from the first frame.

Nothing has been sent to YouTube yet: the image and this text came from us, and pressing play is what connects your browser to YouTube.

  1. 0:03One overlap, thirty minutes
  2. 0:06Declined. Still there.
  3. 0:09Marked “free.” Billable anyway.
  4. 0:12No rule claims it
  5. 0:15Your calendar, already a timesheet.
  6. 0:18Total hours. Billable hours.
  7. 0:21Overlapping events detected
  8. 0:24Overlaps
  9. 0:28Not counted
  10. 0:38Category summary. Uncategorized.
  11. 0:45Export CSV. Export Excel.

youtu.be/Gx0Coxne5bQ · published September 24, 2026

What a week looks like once it is a timesheet

Three ordinary weeks, and what Calendar Timesheet makes of each.

  1. A freelancer's billing week

    You drop one week of Google Calendar events: client calls, focus blocks, a design review.

    Nine rows carrying date, start and end time, duration, title and calendar — and a total for the week.

    A block you had marked free still counted. Free rarely means idle; it usually means focus time.

  2. One month, three clients

    You drop a month whose event titles start with a client name.

    Hours grouped by category, with a billable total per client, ready for three separate invoices.

    Admin time landed in Uncategorized rather than being split silently across the three.

  3. A travel day and a clock change

    You drop a week holding an all-day travel entry and the night the clocks moved.

    The all-day entry stays out of the hourly total unless you opt in and set hours per day; every other event keeps its own time zone.

    The short night is counted as the hours it actually had, so a clock change neither adds nor removes an hour.

What a Google Calendar timesheet gives you

The calendar you drop

calendar-export.ics

Aug 18 – 22

What gets counted

  • Client work

    18.5h

  • Internal

    9h

  • Admin

    5h

What you export

calendar-export.csv

Date,Category,Title,Hours,Billable

2026-08-18,Client,Client workshop,2.5,Yes

Start from the week you already scheduled

Your meetings, calls and focus blocks are already a record of the working week. Calendar Timesheet reads them instead of asking you to remember them.

Edit every entry before it counts

Group events into categories and mark time billable or non-billable. Nothing is exported until you have reviewed it.

Export a clean CSV

Download a per-event breakdown and category totals for the date range you choose, ready for invoicing or reporting.

How Calendar Timesheet turns a calendar export into a timesheet

Export your calendar

In Google Calendar, go to Settings → Import & export → Export to download a .zip; unzip it to get the .ics file. Outlook and Apple Calendar export an .ics directly.

Drop it in and review

Calendar Timesheet calculates each event's duration in your browser, groups the hours into categories you define, warns you about overlapping events, and keeps all-day events out of hourly totals by default.

Export the range you need

Pick a date range, check the totals per category, and download an Excel file or a CSV for invoicing, reporting or payroll.

Who tracks hours from a calendar

Anyone who has to report where their hours went, and whose calendar already knows the answer.

  • Freelancers

    Turn scheduled client work into an invoice-ready summary without running a timer all day.

  • Consultants and agencies

    Split one week across several clients and projects, then export a single CSV per billing period.

  • Billed-by-the-hour professionals

    Accountants, lawyers and advisors can reconstruct billable hours from the meetings and calls already on the calendar.

  • Small teams and internal reporting

    Answer “where did the week go?” with the calendar you already keep, instead of introducing a new tracking habit.

Your hours, without opening a new tab

Calendar Timesheet also runs as a Chrome side panel: drop the same exported calendar file in, and it counts the hours for the week or month you pick, right next to whatever page you already have open.

  • A panel, not a page

    Pin it once and it stays docked beside the tab you're on — there is nothing to navigate to.

  • Reads only what you drop

    It asks for two permissions, storage and side panel, and connects to nothing — no Google, Outlook or Apple account, no server. The file is parsed on your device, exactly like the page.

It shows one running total rather than a category breakdown — the panel has no rule editor yet — and only four fixed ranges: this week, last week, this month, last month. For categories, billable totals and a custom range, use Calendar Timesheet on the web.

Add to Chrome — free

For Chrome and other Chromium-based browsers.

What this tool cannot do

The honest list, so you know what you are getting before you try it.

  • You export the file yourself

    There is no live connection, so a new timesheet means a fresh export. That is the trade for needing no account and granting no access — and a timesheet is usually a monthly job anyway.

  • No live timer, no monitoring

    Calendar Timesheet does not run in the background and does not watch your screen. It reads events that already exist.

  • All-day events stay out of hourly totals

    They are excluded by default, because an all-day block is rarely eight billable hours.

  • Overlaps are flagged, not resolved

    Double-booked time is shown with a warning. Calendar Timesheet never silently deletes one side of an overlap.

  • No PDF export yet

    PDF export, rounding rules and hourly rates are planned, not shipped.

Privacy

Nothing to connect. Nothing to upload.

Calendar Timesheet has no account, no sign-in and no connection to your calendar provider. The file you drop is parsed by code running in your own browser, and the page itself is served with a policy that lets it contact no server but our own and Cloudflare's two analytics hostnames. The policy also admits the demo video's YouTube player frame, from youtube-nocookie.com, though nothing is loaded from YouTube until you press play; from then on the player is YouTube's own document, which our policy does not govern and which we neither control nor count. None of your calendar file is in any of it.

  • Your calendar file, read in your browser

    How it works
  • A Calendar Timesheet account or password

    Not needed
  • A connection to Google, Outlook or Apple

    Not needed
  • Your calendar file sent to our servers

    Never

There is nothing to revoke and no access to withdraw, because none was ever granted.

Read our privacy approach

Questions about turning Google Calendar into a timesheet

What people ask before they drop a calendar file.

How do I track hours in Google Calendar?
Google Calendar has no built-in hour tracking, but the events you already keep are the record. Export the calendar as an .ics file and drop it on this page: every event becomes a timesheet row with its duration worked out for you. Filter to a date range, mark what is billable, and export it to Excel or CSV. There is no timer to start and stop, and nothing to fill in after the fact.
What is a Google Calendar timesheet?
It is a record of working hours built from the events already in your calendar instead of from a timer or a blank spreadsheet. You export the calendar as a file; Calendar Timesheet then calculates the duration of each event for the range you choose, groups them into categories you define, and gives you totals you can export.
How long does it take to produce a timesheet?
Usually a couple of minutes. Export your calendar, drop the file on the page, review the entries, and export to Excel or CSV. There is nothing to install, no account to create and no timer to remember to start.
Does it work with Outlook or Apple Calendar?
Yes. Calendar Timesheet reads the .ics format, which Google Calendar, Outlook, Apple Calendar and most other calendar software export. A Google export contains all your calendars in one file; you can filter what counts as working time inside Calendar Timesheet.
Can I change an entry without changing my calendar?
Yes, and it is impossible for Calendar Timesheet to do otherwise. It reads a copy of your calendar that you exported — it has no connection to the original, so moving an event to another category or marking it non-billable can only ever affect the timesheet in front of you.
How are all-day events handled?
All-day events are excluded from hourly totals by default, because an all-day block is rarely eight hours of billable work. You can choose to include them.
What happens when two events overlap?
Calendar Timesheet shows the raw total and warns you about the overlap. It never silently deduplicates double-booked time, because only you know which of the two actually happened.
Does it handle time zones and daylight saving?
Yes. Each event keeps its own time zone, and durations are calculated across daylight-saving changes, midnight and month boundaries, so travel or a clock change does not distort the week.
What does the export contain?
One row per event, carrying the date, start and end time, duration in hours and minutes, event title, calendar, category, billable flag, and the flags for all-day, overlapping, tentative and clipped-to-range entries, plus the ISO timestamps and time zone. Category totals for the range come with it. It downloads as an Excel workbook (.xlsx), with totals and events on separate sheets, or as a CSV.
Does the export open in Google Sheets?
Yes. Open the Excel file (.xlsx) in Google Sheets with File → Import, or upload it to Google Drive and open it with Sheets. Hours are stored as numbers, so Sheets totals them correctly whatever your language settings. The CSV opens there too, but where decimals are written with a comma, a value like 2.5 hours can be read as a date; use the .xlsx or the minutes column.
What does Calendar Timesheet do with my calendar data?
Your calendar file never leaves your browser. The file you drop is parsed on your own machine; it is not uploaded, not stored, and not visible to us at any point. Your categorisation rules, your preferences and any change you make to a single event stay in your browser too. There is no account and no database holding your calendar. This page counts an anonymous page view and sends one anonymous event when it finishes checking a file you drop on it; Calendar Timesheet itself sends one when a timesheet is built. None of them carries an identifier or any part of your file. Pressing play on the demo video hands your browser to YouTube's player, which then loads whatever it loads from Google's own hosts; between them those requests tell Google your IP address, your browser and which video you opened, and we neither control nor count them. No part of your file is in any of them.

Turn your calendar into a clean timesheet.

Drop the calendar file you already export. Nothing to install, no account, no upload.

Open Calendar Timesheet

Free, no sign-in, nothing uploaded. Your calendar file is read in your browser and never sent to a server.