Documentation/Free Templates

Free Templates

Free Excel templates that work standalone or with Excelendar. Use them as simple spreadsheets, or connect to Excelendar for automatic syncing with your Outlook calendar.

Watch Video Tutorial

Meetings Tracker Template

Track time spent in meetings with automatic duration calculations and weekly or monthly summaries. Use it standalone for manual time entry, or with Excelendar to import your Outlook meetings and see exactly where your time goes.

Features:

Pre-configured Excelendar columns

Auto-calculated Duration column (in hours)

Ready to link to your Outlook calendar

Download: MeetingsTracker_template.xlsx

How to Use

1. Download the template and open it in Excel Online or Excel Desktop

2. To use with Excelendar: install the add-in, open the taskpane, sign in, then click Link Calendar to connect the sheet to an Outlook calendar. Once linked, use Import and Export to sync events

3. To use standalone: manually enter events in the Calendar sheet

Configuring the Summary Sheet

The Summary sheet calculates totals based on your calendar data. Configure it by editing these cells:

Row 1 - Customize the titles however you like

B2 & C2 - Set the Start and End dates for the range to include in calculations

B4 & B5 - Set minimum and maximum event duration (hours) to filter results. All-day events are excluded by default; these filters let you exclude timed events that span a full day or longer

B8 - Set your hourly rate to calculate total cost from duration

The summary updates automatically as events are added or modified.

Excelendar Web App

Importing your first Calendar