Guide

THE TOOLBOX / CALENDAR & DATA

ICS to CSV Converter —
Convert iCalendar (.ics) to Excel CSV & CSV Back to .ICS Locally.

Extract events, durations, locations, and recurrence rules from any .ics file into clean Excel-ready CSV or Google Sheets TSV—or generate an .ics calendar from a CSV spreadsheet—100% in your browser.

Parsed Calendar Summary4 of 4 events · 3.0 hrs

Live Event Preview (4 rows)

SubjectStartEndDurationLocationRecurrence
Q4 Product Roadmap Kickoff2026-11-24 09:302026-11-24 10:3060 minConference Room B / Google Meet—
Thanksgiving Holiday (Office Closed)2026-11-26 2026-11-27 All DayCompany-Wide—
Client Design Review & Prototype Demo2026-11-30 14:002026-11-30 15:1575 minZoom LinkFREQ=WEEKLY;COUNT=4
Engineering Sprint Retro2026-12-02 16:002026-12-02 16:4545 minMain Studio—

RFC 5545 FIELD MAPPING

How iCalendar (.ics) Properties Map to CSV & Excel Columns.

.ICS PropertyCSV ColumnExample Output
SUMMARYSubject / EventQ4 Product Roadmap Kickoff
DTSTART / DTENDStart Date, Start Time, End Date, End Time2026-11-24 · 09:30 → 10:30
VALUE=DATEAll Day EventTRUE / FALSE
LOCATIONLocationConference Room B / Zoom
RRULERecurrenceFREQ=WEEKLY;COUNT=4

1. Ideal for Time Audits & Client Billing

Choose the Excel Time-Tracking schema to automatically calculate each meeting's duration in minutes alongside the total scheduled hours—perfect for freelancer timesheets, quarterly audits, and workload reviews.

Frequently Asked Questions

How do I convert an .ics calendar file to CSV or Excel?

Click "Upload .ics File" (or paste raw iCalendar text) in the converter above. Every VEVENT is parsed instantly in your browser—complete with start/end dates, duration in minutes, locations, and recurrence rules—then click "Download Excel CSV (UTF-8)" to open cleanly in Microsoft Excel or Google Sheets.

How do I export an .ics file from Google Calendar, Apple Calendar, or Outlook?

In Google Calendar, go to Settings → Import & export → Export to download a ZIP containing your .ics files. In Apple Calendar on Mac, select a calendar and choose File → Export → Export…. In Outlook, go to File → Save Calendar or Settings → Calendar → Shared calendars → Publish ICS.

Can I convert a CSV spreadsheet back into an .ics calendar file?

Yes. Switch to the "CSV → .ICS Calendar" tab at the top, upload or paste your spreadsheet rows (with Subject, Start Date in YYYY-MM-DD, Start Time, End Date, and Location), and download a standards-compliant RFC 5545 .ics file ready for Google, Apple, or Outlook import.

Why does the Excel CSV download include a UTF-8 BOM?

Microsoft Excel on Windows and macOS often garbles accented characters, emojis, and non-Latin text in plain UTF-8 CSV files. Including a UTF-8 Byte Order Mark (BOM) tells Excel to display international event titles and locations properly on double-click.

Does this ICS to CSV converter handle multi-line descriptions and folded lines?

Yes. Per RFC 5545, iCalendar files fold long lines using CRLF followed by a space or tab, and escape commas and newlines. Our parser unfolds continuation lines and unescapes characters automatically before writing clean quoted CSV cells.

Is my private calendar data uploaded to a server?

Never. All .ics parsing, filtering, and CSV/Excel generation runs 100% locally in your web browser—your meetings, client names, and private schedules never leave your device.