A sales calendar export
Three events: a two-day trade fair entered as all-day, a follow-up call stored in UTC, and a weekly pipeline review that repeats on Mondays.
With Show UTC times in UK time ticked, the July meeting at 08:30 UTC becomes 09:30 because British Summer Time applies, while the November call stays at 14:30 because the UK is on GMT then. The all-day fair shows its last day, 16 March, as the end date. The weekly review appears once with its rule in recurrence_rule; the individual Mondays are not listed.
BEGIN:VCALENDAR BEGIN:VEVENT SUMMARY:Trade fair stand\, Bath Pavilion DTSTART;VALUE=DATE:20270315 DTEND;VALUE=DATE:20270317 LOCATION:Bath END:VEVENT BEGIN:VEVENT SUMMARY:Call Jo at Kiln & Co DTSTART:20261118T143000Z DTEND:20261118T150000Z DESCRIPTION:Follow up on the wholesale order. END:VEVENT BEGIN:VEVENT SUMMARY:Weekly pipeline review DTSTART:20260706T083000Z DTEND:20260706T090000Z RRULE:FREQ=WEEKLY;BYDAY=MO END:VEVENT END:VCALENDAR
summary,start_date,start_time,end_date,end_time,all_day,timezone,location,description,...,recurrence_rule Weekly pipeline review,2026-07-06,09:30,2026-07-06,10:00,no,Europe/London,,,...,FREQ=WEEKLY;BYDAY=MO Call Jo at Kiln & Co,2026-11-18,14:30,2026-11-18,15:00,no,Europe/London,,Follow up on the wholesale order.,..., "Trade fair stand, Bath Pavilion",2027-03-15,,2027-03-16,,yes,,Bath,,...,
Exporting events
Get the .ics file
Export the calendar from your app (Google Calendar settings, Outlook's save calendar option, or Apple Calendar's export). Then press Choose an .ics file, or paste the text.
Choose the time display
Leave Show UTC times in UK time (GMT or BST) ticked to see times as the clock showed them in the UK. Untick it to keep the times in UTC.
Filter by date if needed
Set Only events from to drop anything that started earlier, which is useful for long-lived calendars.
Check the summary
The counts show total events, all-day events and repeating events. A table previews summary, start, end, all day, location and whether the event repeats.
Download the CSV
The file has thirteen columns: summary, start_date, start_time, end_date, end_time, all_day, timezone, location, description, organiser, status, recurrence_rule and uid. Events are sorted by start.
Why turn a calendar into a spreadsheet
A calendar is a record of what actually happened: discovery calls, site visits, demos, follow-ups. Exporting it lets you count meetings per month, see how long deals took from first call to order, total the hours spent with one client for an invoice, or hand a list of upcoming visits to a colleague without sharing your whole calendar.
Repeating events need care. A weekly meeting is stored once with a rule, so a count of rows is a count of series, not of occurrences. If you need every Monday listed, expand the series in your calendar app or count them from the rule.
Calendar terms in the CSV
- All-day event
- An event with a date but no time. ICS stores the day after it ends; the converter shows the last day itself.
- UTC
- Coordinated Universal Time. Many calendars store times in UTC and show them in your local time zone.
- BST and GMT
- British Summer Time (UTC plus one hour) applies from late March to late October; Greenwich Mean Time the rest of the year.
- RRULE
- The repeat rule of a recurring event, such as FREQ=WEEKLY;BYDAY=MO for every Monday.
Questions people ask
How do I export my calendar to Excel?
Export the calendar from your calendar app as an .ics file, open it here, and download the CSV. Open the CSV in Excel, or convert it to .xlsx. Each event becomes one row with its start and end dates and times, location, description and status in separate columns.
Why are my times an hour out?
Times stored in UTC differ from UK clock time by an hour during British Summer Time. Tick Show UTC times in UK time and the converter applies GMT or BST for each event's own date. Events stored with a named time zone of their own are shown in that zone and labelled in the timezone column.
Are repeating events expanded into separate rows?
No. Each repeating event appears once, with its repeat rule in the recurrence_rule column and Repeats marked in the preview. That keeps the CSV the same size as the calendar. If you need each occurrence as its own row, expand the series in your calendar app before exporting.
Can I convert a shared or subscribed calendar?
Yes, if you can get its .ics file. Many shared calendars offer a link ending in .ics; open that link in your browser to download the file, then choose it here. The converter reads the file you give it and does not fetch calendar links itself.
Where your data goes
The calendar file is read with your browser's file reader and converted on this page. Event titles, notes and attendees are not sent to Map Extract or any other service.
Checked against the tool on