I export our company's shared Google Calendar as an ICS file each quarter and convert it to CSV for reporting. Having start date, end date, and location in separate columns lets me build attendance summaries and room utilization reports in Excel.
ICS to CSV Excel Converter Online Free
or drop files here .ics (up to 50 MB)
Free 5-row preview · No sign-up required
Invoice import blocked if Sales Tax enabled in QBO
Convert Complete
Your converted file is ready!
Download now before closing this page
Events CSV/Excel Format
Showing valid rows only (download includes all rows + errors)
All rows valid
| $ |
|---|
+ more rows
valid rows
invalid rows skipped from preview
credits
| Row | Column | Value | Error |
|---|---|---|---|
Showing first 50 errors. more errors not shown.
more errors hidden. Download the full validation report to see all errors.
Validation Report Download
The download includes your original file with an added "Validation Error" column showing error messages for each row. Valid rows have an empty error column.
• credits
Use credits to download
Click any download button to use your credits
- Full CSV & Excel export
- Google Sheets export
- Instant browser download
for credits
One-time payment
256-bit SSL encryption
14-day money-back guarantee
PCI DSS compliant
Powered by Paddle
Want to save on credits?
Buy bundles and get up to 27% off. Perfect for recurring monthly conversions.
Liked the preview?
Upload your actual file to get the real conversion
Transform iCalendar files into editable spreadsheets for data analysis, scheduling, or migration between calendar apps.
Free preview — then from $5. Save with bundles.
Free preview before you pay
Files never leave your browser
No account needed to start
How to Convert ICS → CSV
1
Export from your calendar
Export calendar events as ICS (.ics) from Google Calendar, Outlook, or Apple Calendar
2
Upload and Configure
Upload ICS Calendar Events (.ics) CSV and choose Calendar Events CSV format
3
Preview and Download
Review converted data, download Calendar-ready file
4
Open in spreadsheet
Open the CSV in Excel, Google Sheets, or any spreadsheet app for editing
5
Import to Google Calendar
Go to Google Calendar → Settings → Import & Export → Import → Select CSV file
Output is in Events CSV/Excel format — ready to import directly, no manual reformatting needed.
ICS → CSV Conversion Questions
What calendar apps export ICS files?
Google Calendar, Apple Calendar, Outlook, Thunderbird, Yahoo Calendar, and most calendar apps support ICS export. In Google Calendar, go to Settings and use Export to download an ICS file.
Can I convert a file with hundreds of events?
Yes. The tool handles ICS files containing any number of VEVENT entries. Each event becomes one row in the CSV output with all properties extracted.
What columns will the CSV have?
The output includes Subject, Start Date, Start Time, End Date, End Time, All Day Event, Location, Description, Category, Private, Status, Organizer, Recurrence, and UID columns.
Common Calendar Events CSV Import Errors
Issues you might encounter when importing ICS Calendar Events (.ics) data to Calendar Events CSV - and how we solve them
Invalid ICS File
File is not a valid iCalendar format
Random text content
BEGIN:VCALENDAR\nBEGIN:VEVENT\n...
Ensure file is a valid .ics export from your calendar app
Re-export from Google Calendar, Outlook, or Apple Calendar
No Events Found
ICS file contains no VEVENT components
BEGIN:VCALENDAR (no VEVENT)
BEGIN:VCALENDAR\nBEGIN:VEVENT\nSUMMARY:Meeting\n...
Ensure your calendar export includes events
Check export settings in your calendar app
Why Convert ICS to CSV?
The Editing Problem
ICS files are structured text that cannot be easily edited, sorted, or filtered. Converting to CSV lets you work with events in any spreadsheet application for analysis or bulk editing.
What This Tool Does
Upload your ICS file exported from any calendar app. The tool parses VEVENT components and creates a flat CSV with separate columns for dates, times, locations, and descriptions.
Multi-Event Support
Handles ICS files with hundreds or thousands of events. Each VEVENT entry becomes one row in the output spreadsheet with all properties extracted.
How People Use ICS → CSV
We needed to migrate scheduling data from Apple Calendar to a project management tool that only accepts CSV. I converted the ICS exports to CSV and the all-day event detection correctly handled our multi-day milestones without off-by-one date errors.
Each semester I convert the academic calendar ICS file to Excel to build room assignment spreadsheets. The ICS to CSV converter parsed all the VEVENT entries and split the datetime values into separate date and time columns, saving me from manual reformatting.
Field Mapping
How Calendar Ics fields map to Calendar Events Csv
| Calendar Ics | Source Value | Calendar Events Csv | Target Value | Note | |
|---|---|---|---|---|---|
SUMMARY |
Team Meeting |
→ | Subject |
Team Meeting
|
Event title |
DTSTART |
20250115T090000 |
→ | Start Date + Start Time |
|
Split into date and time columns |
DTEND |
20250115T100000 |
→ | End Date + End Time |
|
Split into date and time columns |
LOCATION |
Conference Room A |
→ | Location |
Conference Room A
|
Event location |
DESCRIPTION |
Weekly sync |
→ | Description |
Weekly sync
|
Event description (newlines unescaped) |
CATEGORIES |
Meeting |
→ | Category |
Meeting
|
Event category |
CLASS |
PUBLIC |
→ | Private |
PUBLIC
|
PRIVATE → TRUE, PUBLIC → FALSE |
STATUS |
CONFIRMED |
→ | Status |
CONFIRMED
|
CONFIRMED → Confirmed, etc. |
ORGANIZER |
jane@example.com |
→ | Organizer |
jane@example.com
|
Extract email from mailto: |
RRULE |
FREQ=WEEKLY;BYDAY=MO |
→ | Recurrence |
FREQ=WEEKLY;BYDAY=MO
|
Recurrence rule preserved as-is |
UID |
abc123@example.com |
→ | UID |
abc123@example.com
|
Unique event identifier |
Why Use the ICS → CSV Converter?
Multi-Event ICS Parsing
Handles ICS files with any number of events from any calendar application.
Smart Date and Time Splitting
Splits ICS datetime values into separate date and time columns with AM/PM format.
All-Day Event Detection
Correctly identifies all-day events and adjusts exclusive end dates per ICS standard.
Organizer Email Extraction
Extracts organizer email addresses from mailto URI format automatically.
Encoding Detection
Automatically detects UTF-8, Latin-1, and other encodings for international events.
Browser-Based Privacy
Files process locally in your browser. Calendar data never leaves your computer.
Data Transformation
Each VEVENT becomes one CSV row
Input
VEVENT Component
ICS VEVENT with properties
Key columns:
SUMMARY,
DTSTART,
DTEND
1:1 — One input row creates one output row
Output
Event Row
Date split
Content
Metadata
Each VEVENT should have SUMMARY and DTSTART
Your ICS → CSV Conversion is Secure
Local Processing Engine
Your ICS → CSV files stay on your device. Processing happens client-side, nothing leaves your machine.
Zero Server Storage
Your ICS → CSV files are never cached, logged, or stored anywhere. Every session is ephemeral.
Privacy-First Architecture
Designed for data sovereignty. No third-party trackers or analytics touch your ICS → CSV files.
More credits - more savings
Buy bundles and get up to 60% off. Perfect for recurring monthly conversions.
Frequently Asked Questions
You can, but free scripts and AI often miss edge cases that break real-world data: missing SKUs, currency formatting quirks, tax calculation errors, or date format mismatches. We have battle-tested validators specifically designed for accounting software imports that catch these issues before they corrupt your books. Plus, you get instant browser-based conversion without installing Python or managing dependencies.
Google Calendar, Apple Calendar, Outlook, Thunderbird, Yahoo Calendar, and most calendar apps support ICS export. In Google Calendar, go to Settings and use Export to download an ICS file.
Yes. The tool handles ICS files containing any number of VEVENT entries. Each event becomes one row in the CSV output with all properties extracted.
The output includes Subject, Start Date, Start Time, End Date, End Time, All Day Event, Location, Description, Category, Private, Status, Organizer, Recurrence, and UID columns.
All-day events are detected from VALUE=DATE parameters or date-only DTSTART values. The exclusive DTEND is adjusted back by one day to show the actual last day of the event.
Yes. After processing, you can download the result as either CSV or Excel (XLSX) format.
In Google Calendar, go to Settings, select your calendar, scroll to Export Calendar, and click the export button. This downloads a ZIP file containing an ICS file.
Recurring events are preserved with their RRULE in the Recurrence column. The tool does not expand recurrences into individual occurrences.
Calendar → Calendar Data Ecosystem
All available data flows from Calendar to Calendar
Calendar
Calendar Events CSV
Calendar events CSV with dates, times, locations, and descriptions
→
Calendar
ICS Calendar Events (.ics)
iCalendar (ICS) format compatible with Google Calendar, Outlook, and Apple Calendar
Subject → SUMMARY
Start Date + Start Time → DTSTART
End Date + End Time → DTEND
Calendar
ICS Calendar Events (.ics)
iCalendar (ICS) events file with VEVENT components including dates, times, and recurrence
→
Calendar
Calendar Events CSV
Calendar events in CSV format for spreadsheet editing or Google Calendar import
SUMMARY → Subject
DTSTART → Start Date + Start Time
DTEND → End Date + End Time
🥦
Quick question before you go
Help us improve—what stopped you today?
🎉
Thank you!
Enter your email to claim your welcome bonus