.ics .csv For spreadsheets and bulk export

ICS to CSV Converter

Drop in an .ics file and download a clean CSV of every event inside it. Works with single‑event invites and multi‑event calendar exports. Parsing happens in your browser — nothing is uploaded.

01 · Upload .ics

Drop your .ics file here

or click to browse

iCalendar · RFC 5545

02 · CSV export

Your CSV export

Drop your .ics on the left and a downloadable CSV will appear here — one row per event.

100% in‑browser · No upload · Unlimited conversions

How the tool works

01

Drop the file

Drag in the .ics or click to pick it. Parsing happens immediately.
02

Every event → a row

Each VEVENT becomes one row in the CSV with 9 cleanly named columns.
03

Download & open

Save the file and open it in Excel, Google Sheets, Numbers, or any spreadsheet app.

What is an ICS file?

An .ics file — short for iCalendar — is the universal file format for sharing calendar data between applications. Defined by RFC 5545, an .ics is plain text but the structure is meant for machines: every event is a block of KEY:VALUE lines wrapped in BEGIN:VEVENT / END:VEVENT. Great for calendar apps. Awkward for humans.

A CSV exports the same data into rows and columns that any spreadsheet can read — Microsoft Excel, Google Sheets, Apple Numbers, LibreOffice Calc, and every analytics tool that handles CSV.

Why convert ICS to CSV?

A CSV unlocks everything you can't do inside a calendar app: bulk‑edit dozens of events at once, sort by location to spot conflicts, filter by attendee, run a pivot table over a year of meetings, share an event list with someone who doesn't use calendar software at all, or archive a season's schedule before pruning it from your calendar.

It's also the simplest way to back up an .ics — a CSV is human‑readable, future‑proof, and opens in every tool you'd ever want to use. Edit it, version it, diff it, then convert back to .ics whenever you're ready.

Columns in the CSV

Every row is one event. Start and End are formatted for humans — Jun 18, 2026, 11:00 AM for timed events, Jun 18, 2026 for all‑day — and use the event's original local time so the export is readable at a glance.

Subject: Event title (the SUMMARY field).
Start: Human‑readable date and time — Jun 18, 2026, 11:00 AM for timed events, Jun 18, 2026 for all‑day.
End: Same format as Start.
All Day Event: TRUE or FALSE.
Location: Physical address, meeting URL, or room name.
Description: Plain‑text body. Line breaks preserved.
Timezone: IANA TZID — America/New_York, Europe/London, etc.
Recurrence: The original RRULE string. Empty for one‑off events.
UID: The event's unique identifier — useful for deduplication.

Open the CSV in your favourite spreadsheet

Step‑by‑step for the apps people use most — Excel, Sheets, Numbers, and (if you need to) re‑importing back into Outlook.

Microsoft Excel

How to open the .csv in Microsoft Excel

1.Open Excel and choose File → Open.
2.Browse to your downloaded .csv file and open it.
3.Excel auto‑detects columns. If date columns appear as text, select the column → Data → Text to Columns → choose Delimited → Date.

Tip: the file is exported as UTF‑8 with a BOM, so non‑English characters (accented names, emoji) render correctly without any extra setup.

Google Sheets

How to open the .csv in Google Sheets

1.Open sheets.google.com and create a new blank sheet (or open an existing one).
2.Click File → Import.
3.Switch to the Upload tab and drop your .csv.
4.Pick Replace current sheet or Append to current sheet and click Import data.

Apple Numbers

How to open the .csv in Apple Numbers

1.Locate the downloaded .csv in Finder.
2.Double‑click the file — macOS opens it directly in Numbers if Numbers is your default CSV handler.
3.Otherwise: right‑click → Open With → Numbers.

Back to Outlook Calendar

How to import the .csv as events in Outlook

1.Open Outlook (classic desktop, Windows) and click File → Open & Export → Import/Export.
2.Choose Import from another program or file → Next.
3.Select Comma Separated Values → Next.
4.Browse to your .csv, choose how Outlook should handle duplicates, then click Next.
5.Pick a destination Calendar folder → Next → Finish.

Outlook expects MM/DD/YYYY dates for CSV imports. If imports fail, reformat the date columns in Excel before importing (Format Cells → Date → pick the US format).

Heads up. CSV is great for tabular analysis, but it can't carry every iCalendar field — attendees, alarms, attachments, complex VTIMEZONE rules. If you need a lossless export, keep the original .ics alongside the CSV.

Works with

Microsoft Excel · Google Sheets · Apple Numbers · LibreOffice Calc · Outlook · Power BI · any CSV‑aware tool

Questions

Yes. No signup, no limits. The tool runs entirely in your browser and we don't charge or gate anything.

No. The .ics is parsed in your browser with the open‑source ical.js library. The CSV is built locally and downloaded straight from your browser — nothing is sent to a server.

Subject, Start, End, All Day Event, Location, Description, Timezone, Recurrence (RRULE) and UID. Start and End use human‑readable dates — Jun 18, 2026, 11:00 AM for timed events, Jun 18, 2026 for all‑day — so the CSV is readable at a glance.

Yes. Every VEVENT in the file becomes one row in the CSV. The result panel shows the count so you know how many events are in the export.

Recurring events stay as a single row with the original RRULE string in the Recurrence column — they're not expanded into one row per occurrence. That keeps the export lossless and lets you re‑import or expand later if you need each instance.

Outlook accepts CSV calendar imports natively — see the manual import steps below. Google Calendar only accepts .ics for imports, but you can edit the CSV in Excel/Sheets and convert back to .ics if you need to.

Yes. Times are written in each event's original timezone (no UTC shift) and the Timezone column carries the IANA TZID so you have the full context in the spreadsheet.