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)
Subject
Start
End
Duration
Location
Recurrence
Q4 Product Roadmap Kickoff
2026-11-24 09:30
2026-11-24 10:30
60 min
Conference Room B / Google Meet
—
Thanksgiving Holiday (Office Closed)
2026-11-26
2026-11-27
All Day
Company-Wide
—
Client Design Review & Prototype Demo
2026-11-30 14:00
2026-11-30 15:15
75 min
Zoom Link
FREQ=WEEKLY;COUNT=4
Engineering Sprint Retro
2026-12-02 16:00
2026-12-02 16:45
45 min
Main Studio
—
RFC 5545 FIELD MAPPING
How iCalendar (.ics) Properties Map to CSV & Excel Columns.
.ICS Property
CSV Column
Example Output
SUMMARY
Subject / Event
Q4 Product Roadmap Kickoff
DTSTART / DTEND
Start Date, Start Time, End Date, End Time
2026-11-24 · 09:30 → 10:30
VALUE=DATE
All Day Event
TRUE / FALSE
LOCATION
Location
Conference Room B / Zoom
RRULE
Recurrence
FREQ=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.
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.