Skip to content
ToolPlankDEV
Text Tools
100% In-Browser Execution

Updated:

ICS to CSV Converter

Paste a calendar and get a CSV as you type. This ics to csv converter reads Google, Outlook and Apple calendar files, expands repeating events, converts time zones, filters by date or keyword and adds up the hours. Nothing is uploaded.

Options:

ICS calendar

Input
0 chars · 0 lines

CSV

Ready
Processing in browser...
0 chars · 0 linesUpdates as you type

Events and notes

The first events, anything that needs attention and how times and repeats were handled appear here.

Processed on your device. Your text is not sent to our servers.

More free tools you may need next.

Quick Guide

How to use ICS to CSV

Simple step-by-step instructions to get the exact output you need.

  1. 01

    Paste or open your ICS file

    Paste the text of the .ics file into the left box, press Paste, or open the file. Export it from Google Calendar, Outlook or Apple Calendar first. Example loads three events, and Billable hours, Outlook with Windows zone and Repeats without an end load other cases.

  2. 02

    Check the events and the notes

    The CSV appears on the right with the number of events and the total hours. The panel under it shows the first events, anything skipped, how time zones were treated and how many rows repeating events produced.

  3. 03

    Set time zone, repeats, range and keyword

    Choose to keep times as written, convert to UTC or to this browser's zone. Expand repeating events into one row each or list them once. Type a date range such as 2026-11-01 to 2026-11-30 or a keyword to narrow the list.

  4. 04

    Copy or download the CSV

    Press Download to save calendar.csv and open it in Excel or Google Sheets, or press Copy to paste the rows into a sheet.

How to convert ICS to CSV

An ICS file is a text file that holds calendar events between BEGIN:VEVENT and END:VEVENT lines. A CSV is a table. To convert ics to csv, the tool reads every event and writes one row with the title, start, end, duration in hours, location, description, organizer, attendees, status, categories and ID.

Calendars show where you are and who you meet, so the file never leaves your computer. The conversion runs in your browser, as the Privacy Policy explains.

Total hours and billable time

The status line above the result shows the event count and the sum of all timed events in hours, such as 12 events · 19.25 hours total. The Duration (hours) column holds each event as a decimal, 1.5 for an hour and a half, so a spreadsheet can sum it. Use the date range to total one week or one month, and the keyword to total one client.

All-day events have no hours. Their Duration cell is empty and they are left out of the total. Cancelled events are still exported with their status, so filter on the Status column if you need to remove them.

Repeating events and RRULE

A weekly meeting is stored once with a rule such as FREQ=WEEKLY;BYDAY=MO,WE;COUNT=6. With Expand into rows on, the tool writes one row for each occurrence. It supports daily, weekly, monthly and yearly rules with INTERVAL, COUNT, UNTIL, BYDAY (including the second Tuesday or the last Friday), BYMONTHDAY and BYMONTH.

  • Dates excluded with EXDATE are removed from the rows.
  • A changed single instance of a repeating event replaces the original occurrence.
  • A rule with no end stops at the end of the date range, or 12 months after today when there is no range.
  • Rules that use BYSETPOS, BYWEEKNO, BYYEARDAY or time parts, yearly rules with BYDAY or BYMONTHDAY and no BYMONTH, and hourly rules, are not expanded. The first occurrence is listed and the notes say so.

List once keeps one row per event and writes the rule text in the Repeats column.

Time zones

Each time in a calendar file is one of three kinds: UTC (a Z at the end), local to a named zone (TZID) or floating, with no zone at all. As written leaves every time as it appears in the file. UTC and This browser convert the times that have a zone and apply daylight saving correctly, so a 09:00 meeting in Berlin becomes 08:00 UTC in winter and 07:00 UTC in summer.

Outlook writes Windows names such as W. Europe Standard Time. The tool knows the common ones and maps them to the standard names. A zone name it does not know is reported, and those times are used as written. Floating times and all-day events are never shifted, because they have no zone to shift from.

A worked example

A weekly Monday and Wednesday meeting in Berlin, six occurrences, with the second Wednesday excluded:

Text
BEGIN:VEVENT
DTSTART;TZID=Europe/Berlin:20261102T090000
DTEND;TZID=Europe/Berlin:20261102T103000
RRULE:FREQ=WEEKLY;BYDAY=MO,WE;COUNT=6
EXDATE;TZID=Europe/Berlin:20261104T090000
SUMMARY:Team sync
END:VEVENT

It becomes five rows, because six occurrences minus one excluded date is five:

csv
Summary,Start,End,Duration (hours)
Team sync,2026-11-02 09:00,2026-11-02 10:30,1.5
Team sync,2026-11-09 09:00,2026-11-09 10:30,1.5
Team sync,2026-11-11 09:00,2026-11-11 10:30,1.5
Team sync,2026-11-16 09:00,2026-11-16 10:30,1.5
Team sync,2026-11-18 09:00,2026-11-18 10:30,1.5

Google Calendar, Outlook and Apple Calendar files

Google Calendar exports a .ics file under Settings, Import and export. Outlook can save a calendar as an iCalendar file, and Apple Calendar exports through File, Export. Several calendars in one pasted file are fine, and every event becomes a row. A subscription URL cannot be read here, because a web page cannot fetch it. Download the file first.

To go the other way and build calendar events from a spreadsheet, use CSV to ICS. If the CSV needs merging with others first, Merge CSV Files does that, and CSV to Markdown turns the rows into a table for a document.

Limits

Only events become rows. To-dos, journal entries and free/busy blocks are named in the notes and left out. Extra dates added with RDATE are not added. Text that begins with =, +, -, @ or a tab gets a ' in front so Excel does not run it as a formula. A very large calendar is cut at 100,000 rows, and one event never produces more than 10,000.

Frequently Asked Questions

Technical Q&A for ICS to CSV

Common questions about edge cases, character encoding, and privacy guarantees.

Paste the text of the .ics file or open the file, and the CSV appears on the right. Press Download to save calendar.csv.

Download the CSV and double-click it, or paste the rows into a sheet. With the UTF-8 BOM option on, Excel on Windows shows accents correctly.

Export the calendar as .ics from Settings, Import and export, then paste or open that file here. Google does not export CSV itself.

Yes. Daily, weekly, monthly and yearly rules become one row per occurrence, with excluded dates removed. Choose List once to keep one row per event.

Times can stay as written, or be converted to UTC or to this browser's zone with daylight saving applied. Floating times and all-day events are never shifted.

Yes. The status line shows the total hours of timed events, and each row has a decimal Duration (hours) column. Use a date range or keyword to total part of the calendar.

All-day events have no hours, so their duration is left empty and they are not in the total.

No. A web page cannot fetch another site's calendar feed. Download the .ics file from your calendar app and paste or open it here.

No. The file is read in your browser and nothing is sent to a server.