# Convert an ICS calendar file to an Excel spreadsheet

> Markdown version of https://stella.sh/how/contacts-calendar-email/convert-ics-to-excel for agents and LLMs.
> Turn an exported calendar (.ics) into a spreadsheet of every appointment in a date range, repeats expanded, in your time zone: Outlook, or Stella (stella.sh).

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.

- Checked: 13 November 2026
- Stella does it on: Windows, Mac, Linux

## Stella doing it

Recorded 13 November 2026 on Linux (Omarchy) with Claude Code with Opus, on a Claude plan.
Result: 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×.

Video (44 s): https://stella.sh/media/proofs/contacts-calendar-email/convert-ics-to-excel/proof.mp4

Transcript:

- 0:00 Stella on a Linux computer. A family calendar export (.ics) is in Downloads.
- 0:02 The prompt: every appointment from January to June 2026, one row each, in Chicago time.
- 0:12 Stella replies: repeating appointments included, all times in Chicago time.
- 0:18 Reading the calendar, sped up 6×.
- 0:30 Done: 57 appointments sorted by date, the cancelled lesson left out, four universal-time invites converted, one late-night time flagged.

What Stella does:

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 to paste

```text
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.
```

## Convert 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 Stella 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](https://stella.sh/how/contacts-calendar-email/convert-vcf-to-excel) and [CSV to VCF](https://stella.sh/how/contacts-calendar-email/convert-csv-to-vcf). Saved emails can go into one PDF: see [EML to PDF](https://stella.sh/how/contacts-calendar-email/convert-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.

Sources: [Timetackle: Export Outlook calendar to CSV](https://www.timetackle.com/how-to-export-outlook-calendar-to-csv/), [Google Calendar Help: Import events](https://support.google.com/calendar/answer/37118).

## Related problems

- [Convert a VCF contacts file to Excel](https://stella.sh/how/contacts-calendar-email/convert-vcf-to-excel.md)
- [Convert EML files to one PDF, oldest first](https://stella.sh/how/contacts-calendar-email/convert-eml-to-pdf.md)
- [Combine multiple Excel files into one sheet](https://stella.sh/how/pdf-excel/combine-excel-files-into-one-sheet.md)
- [Convert a contacts CSV to a VCF file for your phone](https://stella.sh/how/contacts-calendar-email/convert-csv-to-vcf.md)
- [Merge duplicate contacts from two lists](https://stella.sh/how/contacts-calendar-email/merge-duplicate-contacts.md)
- [How to open an mbox file](https://stella.sh/how/contacts-calendar-email/open-mbox-file.md)

Get Stella: https://stella.sh/download. Free with the ChatGPT or Claude plan you already have.
