iCloud Calendar ICS to CSV Converter

From calendar file to spreadsheet

A spreadsheet is the easiest way to count hours, list a season of fixtures, print a schedule or move events into a system that only accepts CSV. Calendar apps export .ics files, not spreadsheets, and simply renaming the file does not work. This converter reads the iCalendar format properly, including time zones, all-day events and repeat rules, and writes a clean CSV.

How to get an .ics file from iCloud Calendar

1. On a Mac, open the Calendar app, select the calendar in the sidebar and choose File, then Export, then Export.
2. For a calendar shared publicly from iCloud, open its public link in a desktop browser and save the .ics file.

The converter only reads the file you choose. It does not sign in to iCloud or access your account.

Choose exactly what goes into the CSV

• Columns: subject, start date, start time, end date, end time, all day, time zone, location, description, organizer, attendees, recurrence rule, UID, status and categories. Switch each one on or off and move it up or down.
• Presets: the Google Calendar preset uses the column names and US date format that Google Calendar imports; the Outlook preset matches the columns Outlook uses for calendar CSV files.
• Date format: ISO dates with 24-hour times, or US dates with 12-hour times.
• A live preview shows the first rows with your settings.
• Rows are sorted by start time, and a header row can be switched off for systems that do not expect one.

Time zones

Times can be exported as written in the file, with a column naming the zone, converted to UTC, or converted to any time zone you pick. Conversion uses your browser's time-zone database and handles daylight-saving changes. Floating times, which mean the same clock time everywhere, and zones that cannot be identified are exported as written. All-day dates are never shifted by a time zone.

All-day events

An .ics file stores the end of an all-day event as the day after it finishes, so a trip on 10 to 13 April ends on 14 April in the file. Choose Last day to export 13 April, which most people expect in a spreadsheet, or Day after to keep the calendar-file convention that some importers need.

What a CSV cannot hold

• Alarms, attendees' replies and attachments.
• Full repeat logic: a repeating event is one row, with its rule written in words and in its original form.
• Changed occurrences become separate rows marked with the date they replace.

Safe for Excel

The file is UTF-8 with a byte-order mark, so accented and non-Latin text opens correctly in Excel. Any cell that starts with =, +, - or @ gets a leading apostrophe so a spreadsheet treats it as text rather than running it as a formula.

Privacy

The calendar is converted in your browser and is not uploaded to A2Z Tools.

A2Z Tools is an independent service and is not affiliated with or endorsed by Apple Inc. iCloud, iPhone and Apple are trademarks of Apple Inc.