ICS to CSV: turn a calendar file into a spreadsheet

Short answer: choose an .ics file (or paste its text), pick the time zone you want the times in, and download a CSV with one row per event: title, start, end, all-day, place, notes and repeat rule. It is free and runs in your browser, so the calendar is never uploaded.

No account. Nothing uploaded. Free.

    2. Check the table

    3. Download it

    What the CSV contains

    ColumnWhat it holds
    SubjectThe event title.
    Start Date, Start TimeThe start, written as 2026-11-17 and 10:00. Empty time for an all-day event.
    End Date, End TimeThe end. For an all-day event this is the last day of the event.
    All Day EventTrue or False.
    Time ZoneThe zone the times are shown in.
    Location, DescriptionThe place and the notes.
    RepeatsThe repeat rule of a repeating event, such as FREQ=WEEKLY;BYDAY=MO.
    UIDThe unique id from the file.

    How times and time zones are handled

    Repeating events

    A repeating event is listed once, with its rule in the Repeats column. It is not expanded into one row for every occurrence, so a weekly meeting that runs for a year is one row, not 52. If you need every date, import the file into a calendar app and export or print that view.

    Open the file in Excel, Google Sheets or Numbers

    The download is a UTF-8 file with a byte-order mark, so Excel shows accents and non-Latin letters correctly. In some countries Excel expects a semicolon between columns instead of a comma: choose "Semicolon" above if everything lands in one column. In Google Sheets use File, Import, Upload.

    A cell that starts with =, +, - or @ is run as a formula by spreadsheet programs. Calendar files come from other people, so this page puts an apostrophe in front of such a cell and the text stays text.

    What it is useful for

    What is left out

    The CSV is a table of events, not a copy of the whole file. Reminders, guests, organizer details, attachments and time zone definitions are not included. To-dos and journal entries in the file are ignored. An event with no readable start date is skipped, and the page tells you which one.

    When the events are in an image, not a file

    Plans often arrive as a screenshot, a chat or a PDF you cannot copy from. Yotei is a Windows and Mac app that reads the event from your screen: press a shortcut, drag a box around it, check the details and confirm. It adds the event to Google Calendar, Outlook or iCloud directly. See how Yotei works, or test it yourself in your browser.

    Get Yotei for free

    FAQ

    How do I convert an ICS file to CSV?

    Choose the .ics file on this page, check the table, pick the time zone and separator you want, and press Download .csv file. The CSV opens in Excel, Google Sheets and Numbers.

    Is my calendar uploaded?

    No. The file is read by a script in this page and stays in your browser. The only request the page makes is an anonymous visit counter.

    Why are the times different from my calendar?

    Times stored in UTC are shown in the time zone you pick. Check "Show times in" and set it to the zone you want.

    Why does a repeating event appear only once?

    It is listed once with its repeat rule in the Repeats column, instead of one row for every occurrence.

    Can I turn the CSV back into a calendar file?

    Yes. Use the CSV to ICS page. It reads these columns. Repeat rules, guests and reminders are not carried through the CSV.

    Does it work with Google Calendar and Outlook exports?

    It reads standard .ics files, which is what both of them export.