Map Extract
Free tool

Convert an ICS calendar file to CSV

Open an .ics file exported from Google Calendar, Outlook or Apple Calendar, or paste its text, and get a CSV with one row per event. UTC times can be shown in UK time, you can drop events before a chosen date, and repeating events are marked with their rule.

Runs in your browser. Nothing you enter is uploaded.

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.

Input
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
Result
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

  1. 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.

  2. 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.

  3. Filter by date if needed

    Set Only events from to drop anything that started earlier, which is useful for long-lived calendars.

  4. 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.

  5. 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

Top