Stella
Contacts, calendars and email

Convert an ICS calendar file to an Excel spreadsheet

Six months of a family calendar as 57 rows, weekly lessons and all, in Chicago time.

Download StellaFree with the plan you already have.

A real run on 13 November 2026, on a Linux computer, using Claude Code with Opus, on a Claude plan. The waiting is sped up; it took 1 min 55 s in real time.

The short answer.

Classic Outlook on Windows can do it: open the .ics to import it, then File, Open & Export, Import/Export, Export to a file, Comma Separated Values, choose the calendar and set a date range. New Outlook, Apple Calendar and Google Calendar can't export to a spreadsheet. Online converters often list a weekly event once instead of every week, and show times in UTC. Stella (stella.sh) lists every occurrence in your range, in your time zone, in an .xlsx.

Stella does this on Windows, Mac and Linux.

What happened.

The spreadsheet in about 1 minute 20 seconds. Checked afterwards against an answer key written before the run: all 57 appointments are there with the right date and Chicago start time, repeats expanded, nothing from outside January to June, no piano lesson on 31 March, and the .ics unchanged. One optional check missed: it counted 4 extra rows, which are lines on the separate Notes sheet that name appointments while explaining them. The appointments sheet itself has exactly 57 rows.

The calendar is made up for this run, with repeating events, a cancelled date and invites stored in universal time on purpose. The work is sped up 6×.

How Stella does it.

  1. Reads Family calendar export.ics in Downloads
  2. Expands every repeating event into one row per date: weekly piano lessons, monthly book club, fortnightly bins, a yearly birthday
  3. Leaves out the piano lesson cancelled on 31 March and everything outside January to June 2026
  4. Converts invites stored in universal time to Chicago time, and flags one that lands at 11:30 PM as worth checking
  5. Saves Family appointments Jan-Jun 2026.xlsx in Downloads, with multi-day events as one row with an end date, plus a Notes sheet explaining its choices

The prompt.

I exported my family calendar as an .ics file (in my Downloads). Make me a spreadsheet of every appointment from January to June 2026, one row each, with the date, start and end time, title and location. We're in Chicago.

Paste it into Stella and press Enter.

This is the exact prompt from the recording. If your files are somewhere else, say where.

Do it yourself.

  1. Windows with classic Outlook

    Double-click the .ics to import it into Outlook. Then File, Open & Export, Import/Export, Export to a file, Comma Separated Values, pick the calendar, and set the date range when asked. Open the CSV in Excel.

  2. No classic Outlook

    New Outlook, Outlook on the web, Apple Calendar and Google Calendar can import an .ics but can't export a spreadsheet. Import it into Google Calendar (Settings, Import & export) and use a third-party export add-on, or print the agenda view to PDF.

  3. Check the repeats

    Make sure a weekly event appears on every date, not just once, and that cancelled dates are gone. Converters that read the file directly often get this wrong.

  4. Check the times

    Invites from other people are often stored in universal time (UTC). If a 10 AM call shows as 4 PM, the converter didn't change it to your time zone.

Where it stops.

  • Stella reads the file you export; it doesn't connect to your calendar account.
  • Times are shown in the time zone you name. Say which one, as in the prompt here.
  • It added a Notes sheet that mentions some appointments by name. If you sort or filter, use the first sheet; delete the Notes sheet if you don't want it.
  • Event titles, times and places go to the AI model you use in Stella while it works. The spreadsheet is made on your computer.
  • Recorded on Linux. On a Mac or Windows PC Stella may install a calendar and a spreadsheet library first, which wasn't recorded.

Questions.

How do I open an .ics file?

Double-click it: it opens in Calendar on a Mac or Outlook on Windows and offers to add the events. To just read it, open it in a text editor, but repeating events appear once, as a rule.

Why does my weekly event only appear once in the spreadsheet?

The .ics stores it once with a repeat rule. A converter has to expand the rule into dates and drop any cancelled ones; many don't.

Can I export Google Calendar to Excel?

Export it from Google Calendar's Settings, Import & export (you get .ics files in a zip), then convert the .ics as shown here.

What else can it convert?

Contacts both ways: VCF to Excel and CSV to VCF. Saved emails can go into one PDF: see EML to PDF.

Is Stella free for this?

Yes. Free with the ChatGPT or Claude plan you already have. Sign in with your ChatGPT plan, or use your Claude plan through Claude Code, and this task costs nothing extra. New accounts also get a small free trial of Stella’s own models.

Can I control what Stella changes on my computer?

Yes. Stella works on Windows, Mac and Linux with your own files and shows each step in the chat, so you can watch it and stop it at any point. Tell it what it may not do, as the prompts on these pages do (“don't delete anything without asking”). In the Downloads recording it deleted nothing until it was told to go ahead. It also refuses commands that would wipe a whole disk, your home folder or system folders.

Checked against these sources on 13 November 2026.

Stella