Skip to content

ICS calendar to CSV, Excel and ICS converter

Turn Google Calendar, Outlook, and Apple Calendar .ics archives into billable spreadsheet tables entirely on your device.

Drop a Google, Outlook, or Apple Calendar .ics file here

Expands recurring RRULE schedules, ignores nested VALARM triggers, and calculates hours.

Loads recurring standups with nested VALARM, EXDATE, and Zoom links.

How to use ICS to CSV

  1. Pick conversion direction and load your calendar. Keep ICS to CSV / Excel active and drop a .ics, .ical, or .ifb export, or load the built-in sample ICS feed to inspect recurring events.
  2. Verify event totals and recurrence options. Check the 200-row preview header for calendar name, event count, and duration hours, then set RRULE expansion or optional From date and To date bounds.
  3. Select your spreadsheet format and encoding. Choose Excel Workbook (.xlsx), CSV (.csv), or TSV (.tsv) and keep UTF-8 BOM enabled when opening CSV files in desktop Excel.
  4. Download your file locally. Click Download XLSX, CSV, or TSV to save the 13-column table, or switch to CSV / Excel to ICS mode to generate an RFC 5545 calendar.

Your files are processed on this device and never uploaded. They stay private, and there's nothing to delete afterwards.

How does browser ICS parsing isolate VEVENT data from VALARM?

Dropping a .ics, .ical, or .ifb archive transfers raw file bytes into a local Web Worker that unfolds continued lines, tracks a strict BEGIN and END component stack, and reads only active VEVENT properties. Nested VALARM reminder blocks share SUMMARY and DESCRIPTION property names, so stack isolation keeps alarm text out of meeting rows without sending calendar data over the network.

The parser follows the IETF RFC 5545 iCalendar specification to prepare calendar feeds cleanly before extracting spreadsheet fields:

  • BOM and line unfolding: Leading UTF-8 byte order marks (0xEF 0xBB 0xBF) are removed, CR/CRLF line breaks normalize cleanly, and lines beginning with a single space or tab rejoin the preceding property.
  • Component stack isolation: Entering BEGIN:VEVENT opens a draft record while entering BEGIN:VALARM shifts active scope away from VEVENT until END:VALARM returns control.
  • Top-level calendar metadata: Calendar titles from X-WR-CALNAME or NAME at VCALENDAR scope populate the preview header alongside event counts and cumulative duration hours.

Organizations migrating both schedules and address books often convert exported iCloud or Outlook VCF contacts alongside calendar backups. Keeping both personal archives inside local browser memory avoids exposing private invite lists or phone directories.

Expanding recurring RRULE series and calculating event hours

Raw iCalendar files store repeating meetings as one template block with an RRULE rule instead of separate dated rows. For project audits, client invoices, or attendance logs, converting each occurrence and computing accurate decimal duration hours turns static calendar feeds into analyzable records.

Recurrence frequencies, BYDAY rules, COUNT limits, and EXDATE skips

Leaving Expand recurring RRULE occurrences checked walks each template forward chronologically across DAILY, WEEKLY (honoring BYDAY weekday codes such as MO,WE), MONTHLY, and YEARLY schedules while respecting numeric INTERVAL multipliers. Cancelled instances listed under EXDATE properties are excluded before sorting rows by start timestamp.

Two built-in safety bounds prevent infinite series from stalling browser memory. Explicit COUNT parameters are capped at 1000 occurrences, unbounded series cap at 500 rows per template, and rules without an UNTIL date or To date bound default to a 365-day expansion window starting from the first event or chosen From date.

Duration calculation, all-day dates, and conference URL extraction

Each resolved occurrence calculates Duration (Hours) by subtracting DTSTART from DTEND in UTC milliseconds and rounding to two decimals. If DTEND is absent, the parser evaluates RFC 5545 DURATION tokens (P1D, P1W, PT1H30M) or defaults to 24 hours for VALUE=DATE all-day entries and 1 hour for timed meetings.

Video links inside calendar invites frequently sit buried below dial-in PINs. Matching IETF RFC 3986 URI syntax, the extractor checks explicit URL and X-GOOGLE-CONFERENCE properties first, then scans LOCATION and DESCRIPTION for Zoom (zoom.us), Microsoft Teams (teams.microsoft.com), Google Meet (meet.google.com), and Webex (webex.com) addresses.

RFC 5545 Property Parser Handling Output Columns Affected Edge Case Behavior
SUMMARY (inside VEVENT) Escaped text unescaped Summary Nested VALARM summaries ignored
DTSTART / DTEND Normalized to UTC or date Start, End, All Day, Duration (Hours) VALUE=DATE sets All Day to Yes
DURATION Parses P[n]W and P[n]D[T...] End, Duration (Hours) Used when DTEND is omitted
RRULE + EXDATE Generates sorted occurrences Recurring, per-date rows Capped at 500 default or 1000 COUNT
X-GOOGLE-CONFERENCE / LOCATION Regex URI scan Meeting URL, Location Matches Zoom, Teams, Meet, Webex

Auditors who snapshot monthly project schedules before and after re-planning can open revised calendar spreadsheets without missed schedule edits to spot shifted rooms, dropped sessions, or modified duration totals across workbooks.

Rebuilding valid .ics calendars from CSV and Excel schedules

Switching to CSV / Excel -> ICS mode (or dropping a .csv, .tsv, or .xlsx workbook directly) reverses the pipeline and generates an importable RFC 5545 .ics file. Because spreadsheet teams rarely use identical header names, the exporter resolves common aliases cleanly without manual column renaming.

Column header matching and VCALENDAR 2.0 date formatting

Flexible header mapping checks case-insensitive aliases across each row before assembling VCALENDAR VERSION:2.0 blocks with PRODID:-//FreeToolsDock//ICS Converter//EN:

  • Event titles and locations: Maps Summary, Title, Subject, Event, or Name into SUMMARY, and Location, Place, or Room into LOCATION.
  • Timestamps and all-day flags: Parses Start/Begin/Date and End/Finish timestamps, emitting DTSTART;VALUE=DATE when All Day equals yes, true, 1, or y or lacks a time component.
  • Notes and organizers: Preserves Description, Notes, or Details plus Organizer or Owner, writing UID, DTSTAMP, and escaped CRLF line breaks per event.

Connecting calendar exports to billing sheets and media captions

Consultant teams frequently convert calendar timelines into tabular project logs first and inspect Total hours in the preview summary bar before building client billing sheets ready for payroll export from the verified decimal hour totals.

Notice how the preview summary bar displays the expanded event row count alongside the source VEVENT count and total hours immediately after worker parsing completes. Up to 200 rows display in the interactive preview grid, while downloads always export all expanded or filtered events.

Spreadsheet export formats, UTF-8 BOM, and formula safety

Choosing the right download format in an ICS to CSV converter depends on whether teammates open files directly in spreadsheet software or feed downstream scripts. Three structured formats export directly from the 13-column event table (Summary, Start, End, All Day, Duration (Hours), Location, Meeting URL, Organizer, Attendees, Status, Categories, Recurring, Description):

  • Excel Workbook (.xlsx): Builds an Events worksheet with bold Calibri 11 pt headers, inlineStr text storage, and auto-fitted column widths constrained between 8 and 60 characters.
  • Comma-Separated Values (.csv): Quotes fields containing commas, double quotes, or embedded invite line breaks according to the IETF RFC 4180 CSV specification, optionally prepending a UTF-8 BOM (0xEF 0xBB 0xBF) for desktop Excel compatibility.
  • Tab-Separated Values (.tsv): Separates columns with tabs so multi-comma Attendees and Categories lists paste cleanly without field shifting.

Untrusted external calendar invites can place leading =, +, @, or | characters inside SUMMARY or LOCATION text. Applying MITRE CWE-1236 formula injection guidance, every CSV and TSV export prefixes suspicious formula starters and non-numeric - strings with a single apostrophe so Excel opens external invites as inert text. Teams archiving recorded video calls alongside meeting agendas can also pair exported notes with our recorded meeting subtitle converter for caption preparation.

Questions

Why do simple ICS converters put reminder text in event descriptions?

RFC 5545 allows nested VALARM blocks inside a VEVENT, and both components carry DESCRIPTION and SUMMARY properties. This parser maintains an explicit BEGIN and END component stack and ignores every property whenever the active component is not VEVENT, keeping reminder text separate from meeting details.

How are recurring RRULE meetings and EXDATE cancellations expanded?

When Expand recurring RRULE occurrences is checked, DAILY, WEEKLY BYDAY, MONTHLY, and YEARLY rules generate timestamped rows up to 500 instances per series or an explicit COUNT capped at 1000. Cancelled dates listed in EXDATE properties are skipped, and series without UNTIL default to a 365-day window.

How does the converter calculate Duration Hours and handle all-day events?

Timed events subtract DTSTART from DTEND in UTC milliseconds and round to two decimal places, or evaluate RFC 5545 DURATION tokens such as PT1H30M or P1D when DTEND is missing. All-day DATE values export as YYYY-MM-DD and default to 24 hours when no end date is present.

Which video conference URLs are extracted into the Meeting URL column?

The parser inspects explicit URL and X-GOOGLE-CONFERENCE properties first, then scans LOCATION and DESCRIPTION fields for Zoom, Microsoft Teams, Google Meet, and Webex links. Matching conference addresses move cleanly into the dedicated Meeting URL column so attendees do not have to hunt through long invite notes.

Can I convert a CSV or Excel spreadsheet back into an importable .ics calendar?

Yes. Switch to CSV / Excel to ICS mode or drop a .csv, .tsv, or .xlsx file directly, and the island auto-switches direction. Flexible column names like Summary, Title, Start, End, All Day, Location, Organizer, and Description map into a VCALENDAR 2.0 file with CRLF endings.

Does uploading a private calendar archive send meetings over the network?

No. Calendar bytes transfer directly into the local everyday Web Worker running in browser memory and never touch an external server or API. Even large multi-year schedules expand, filter by date, and build Excel or CSV downloads offline on your device.

Updated