Spreadsheet templates for calendar import

Fill in one row per event, then convert it to .ics and import into Google Calendar, Outlook, or Apple Calendar. The converter also reads sheets that don't follow this layout — these just save you the mapping step.

CSV

Calendar events template

Plain headers, one event per row. Opens in Excel, Numbers, Google Sheets, or any text editor.

Download
Excel

Calendar events template

Same layout as an .xlsx workbook, with real date and time cells.

Download
CSV

Outlook calendar CSV layout

Outlook's own export/import header set (Subject, Start Date, Start Time, End Date, End Time, All Day Event, Description, Location).

Download

Columns

Subject
Event title. Required.
Start Date
Any format: 2026-09-01, 9/1/2026, 01.09.2026, Sep 1 2026. Required.
Start Time
9:00, 09:00, 9:00 AM, 14h30. Leave blank for an all-day event.
End Date
Optional. Defaults to the start date.
End Time
Optional. Defaults to start time + 60 minutes (adjustable).
All Day Event
TRUE / FALSE. Optional — a row with no time is all-day anyway.
Location
Optional. Room, address, venue, or a video-call link.
Description
Optional. Notes shown inside the event.
URL
Optional. A link attached to the event.

Recurring events, attendees, and reminders aren't supported — add those in your calendar app after importing. Times are written to the .ics in the timezone you pick in the converter, so an event at 9:00 in your sheet lands at 9:00 on every device.