ICS Calendar Converter

Convert ICS/iCal calendar files to CSV spreadsheet or CSV back to ICS. Supports VEVENT and VTODO components with timezone and recurrence rules.

1.0.0
Version
Auth
Batch

About ICS Calendar Converter

Calendar data is the most universally shared and the least universally exportable. Google Calendar gives you ICS but no CSV; Outlook gives you both but the CSV column layout is different from Google's; Apple Calendar gives you only ICS. So the moment you want to drop your year of meetings into Excel for a billable-hours summary, slice your travel itinerary into pivot tables, or batch- import a CSV of new events into a fresh calendar, you hit a conversion wall. The traditional fix is to re-import into Outlook and re-export, which loses timezones and recurrence rules along the way.

This ICS calendar converter goes both directions with the structure intact. ICS → CSV produces a twelve-column spreadsheet (Summary, Start Date, Start Time, End Date, End Time, All Day, Location, Description, Status, Organizer, URL, Recurrence Rule) ready for Excel, Google Sheets and LibreOffice. Timezone-aware events are normalised to local times with the original TZID preserved in the recurrence-rule column, all-day events come through with the All Day flag set, and VTODO tasks are included alongside VEVENT entries. CSV → ICS goes the other way — pick a template CSV, fill in the rows in your spreadsheet of choice, and download a valid BEGIN:VCALENDAR / END:VCALENDAR file that imports cleanly into Google Calendar, Apple Calendar, Outlook and Thunderbird. Preview before downloading so you can spot a date-format misread before it lands in your calendar.

Use it to extract a year of meetings for an annual review, build a shared travel itinerary from a Wise or Booking.com confirmation email, batch-import course schedules into a new calendar, merge an external speaker series ICS into a personal calendar, or just rescue a calendar export trapped in the wrong format. Files up to 20 MB are processed in a stateless serverless function and discarded immediately after the response.

ICS Calendar Converter Use Cases

  • Freelancers exporting a year of calendar meetings into Excel for billing summaries
  • Building a shared travel itinerary CSV from a Wise or Booking confirmation .ics
  • Batch-importing 200 class sessions or training events into a fresh calendar
  • Operations teams converting team-meeting cadences between Outlook and Google
  • Merging a public speaker-series ICS feed into a personal Google Calendar
  • Academic schedule planners turning a course timetable CSV into a phone-ready ICS
  • Quick sanity-check on what events sit in a calendar export before importing

ICS Calendar Converter Features

  • Two-way conversion — .ics/.ical → CSV for spreadsheet work and CSV → .ics for bulk calendar import
  • 12-column CSV layout (Summary, Start Date, Start Time, End Date, End Time, All Day, Location, Description, Status, Organizer, URL, Recurrence Rule)
  • Handles VEVENT and VTODO components — meetings and tasks both come through with their respective fields
  • Timezone-aware events normalised to local times with original TZID preserved alongside the recurrence rule
  • Recurrence rules (RRULE) preserved through ICS→CSV→ICS round-trips so weekly meetings stay weekly
  • Preview mode shows parsed events before download so you can spot a date-format misread before it touches your calendar
  • Files up to 20 MB processed in a stateless serverless function and discarded immediately after the response

How to Use ICS Calendar Converter

Pick a direction

Two modes. ICS → CSV when you have a calendar file and want a spreadsheet. CSV → ICS when you have a spreadsheet of events (own or downloaded as a template) and want a calendar file to import.

Upload your file

Drag-and-drop a .ics, .ical or .csv (up to 20 MB) onto the upload zone. Calendar files exported from Google, Apple, Outlook, Thunderbird, Fantastical and Wise/Booking emails all work — they all use the same RFC 5545 format.

Click Preview to verify

Preview shows the first events as the parser sees them — summary, start, end, location, recurrence. If a Wise Brazilian event lands an hour off, you'll spot it here before it lands in your calendar. Cancel and tweak; re-upload as needed.

Click Convert

ICS → CSV pass produces a UTF-8 BOM CSV (Excel opens it without a wizard) plus event count. CSV → ICS pass writes a valid BEGIN:VCALENDAR / END:VCALENDAR file with one VEVENT per row and the recurrence rule restored from the RRULE column.

Download and import

For CSV: open in Excel, Sheets or LibreOffice — UTF-8 BOM ensures non-ASCII titles render correctly. For ICS: drop the downloaded file into Google Calendar's Settings → Import, Apple Calendar's File → Import, or Outlook's File → Open & Export → Import.

ICS Calendar Converter FAQ

Yes, the file is uploaded to a stateless serverless function for parsing or generation, and deleted immediately after the response is sent. Nothing is logged to durable storage. For a calendar containing confidential meetings (M&A, healthcare, legal), an offline path like Outlook's File → Import/Export or the icalendar Python library locally is safer.

Yes. The RRULE string from the original ICS is written to the 'Recurrence Rule' column in the CSV, and read back when going from CSV to ICS. A weekly Tuesday meeting (RRULE:FREQ=WEEKLY;BYDAY=TU) stays a weekly Tuesday meeting on the return trip. Edit the column in Excel only if you understand the RRULE grammar — a malformed rule is the easiest way to break an import.

Events with an explicit TZID are normalised to the time you'd see in the originating calendar's local view, and the TZID is appended to the Recurrence Rule column so the round-trip can restore it. All-day events get the All Day flag set so importing tools (Google, Apple, Outlook) treat them correctly rather than as midnight-to-midnight events. Floating events (no TZID) pass through as-is.

Twelve columns: Summary, Start Date, Start Time, End Date, End Time, All Day (boolean), Location, Description, Status (CONFIRMED/TENTATIVE/CANCELLED), Organizer, URL, Recurrence Rule. Dates use YYYY-MM-DD and times use HH:MM:SS. The header is the first row. UTF-8 BOM is included so Excel renders non-ASCII characters correctly.

Yes. The generator writes RFC 5545-compliant ICS with VERSION:2.0, PRODID, BEGIN:VCALENDAR/END:VCALENDAR wrappers and one VEVENT per row. Tested against Google Calendar's Import dialog, Apple Calendar's File → Import, Outlook desktop, Outlook on the web, Thunderbird and Fantastical. If an event refuses to import, the most common cause is a malformed RRULE — leave the column blank for a one-off event.

Yes. VTODO components from ICS exports (Apple Reminders export, OmniFocus export, Things sync) are pulled alongside VEVENTs. The CSV row marks them as tasks via the Status column. For now there's no separate task-only round-trip; if you need pure task workflows, dedicated tools (Todoist, TickTick) export task-specific formats.

20 MB, which comfortably covers several years of personal calendar data or a few thousand events. Corporate shared calendars with attachments or large descriptions can exceed this — for those, split the export by year or use the icalendar Python library locally.

Upload a .ics or .ical calendar file (max 20MB). Exported from Google Calendar, Outlook, or Apple Calendar.

Select a calendar file to convert

ICS/iCal → CSV spreadsheet
CSV → ICS/iCal

ICS Calendar Converter Tutorial

ICS to CSV

Convert your calendar events (ICS/iCal files) to a CSV spreadsheet for easy viewing and editing in Excel or Google Sheets.

  1. Select "ICS to CSV" mode
  2. Upload your .ics calendar file
  3. Click "Preview Events" to inspect the data
  4. Click "Convert" and download the CSV

CSV to ICS

Convert a CSV spreadsheet back to ICS format for importing into Google Calendar, Outlook, or Apple Calendar.

  1. Select "CSV to ICS" mode
  2. Upload your .csv file with event columns
  3. Click "Convert" and download the ICS

CSV columns: Summary, Start Date, Start Time, End Date, End Time, All Day, Location, Description, Status, Organizer, URL, Recurrence Rule

Why Convert ICS to CSV?

ICS (iCalendar) is the universal calendar file format used by Google Calendar, Microsoft Outlook, Apple Calendar, and virtually all calendar applications. While ICS files are great for sharing events between calendar apps, they are difficult to read, edit, or analyze directly.

Converting ICS to CSV lets you:

  • View events in a spreadsheet - Open in Excel, Google Sheets, or LibreOffice for easy reading
  • Bulk edit events - Modify dates, times, locations, and descriptions across many events at once
  • Analyze calendar data - Sort, filter, and create charts from your calendar data
  • Migrate between services - Export from one calendar app and import to another
  • Archive events - Keep a readable backup of your calendar history

Supported Calendar Sources

  • Google Calendar - Settings → Import & Export → Export (downloads .ics)
  • Microsoft Outlook - File → Save Calendar → iCalendar format
  • Apple Calendar - File → Export → Export as .ics
  • Yahoo Calendar - Settings → Import/Export