# Make a class timetable from your registration

> Markdown version of https://stella.sh/how/study/make-a-class-timetable for agents and LLMs.
> Turn a college registration summary into a printable weekly timetable spreadsheet, Monday to Friday with times down the side: by hand in Excel, or Stella (stella.sh).

Put Monday to Friday across the top of a spreadsheet and times in half-hour steps down the side, then for each class merge the cells from its start to its end time on each day it meets and type the course and room. Leave out dropped courses and list online ones underneath. Stella (stella.sh) builds that timetable from the registration PDF your college gives you, on your computer.

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

## Stella doing it

Recorded 14 November 2026 on Linux (Omarchy) with Claude Code with Opus, on a Claude plan.
Result: A printable timetable in about 3 minutes. Checked afterwards against an answer key written before the run: a new spreadsheet with Monday to Friday across and times down the side, all 12 weekly class meetings in the right day and time slot, no class on a day or time it doesn't meet, the dropped HIST 105 left out, the online PSY 101 not given a time slot, and the registration PDF unchanged. The college, courses and registration are made up for this run, with a dropped course and an online one on purpose. The work is sped up 11×.

Video (48 s, sped up 11×): https://stella.sh/media/proofs/study/make-a-class-timetable/proof.mp4

Transcript:

- 0:00 Stella on a Linux computer. A class registration PDF is in Documents.
- 0:02 The prompt: a printable weekly timetable spreadsheet, Monday to Friday with times down the side.
- 0:16 Stella replies it is building the timetable to print on one landscape page.
- 0:22 Reading the registration and building the spreadsheet, sped up 11×.
- 0:34 Done: colour-coded blocks from 8 AM to 5 PM, the online and dropped courses noted, and a possible credit typo flagged.

What Stella does:

1. Finds `Spring 2027 registration - Pellow State.pdf` in Documents and reads its course table: 12 weekly meetings across six in-person courses, including a Thursday lab
2. Leaves out HIST 105, marked Dropped, and keeps the online PSY 101 off the grid because it has no meeting time
3. Builds a spreadsheet with its built-in Office document tool: Monday to Friday across, 8 AM to 5 PM down the side, each class a colour-coded block with course, time and room
4. Notes the online course and the dropped one under the grid, and sets it to print on one landscape page
5. Saves `Spring 2027 timetable - Pellow State.xlsx` in Documents with a print preview image, and flags a likely credit typo in the registration

## The prompt to paste

```text
Turn my class registration in Documents into a weekly timetable spreadsheet I can print, Monday to Friday with the times down the side.
```

## Make it yourself

1. **Set up the grid.** In Excel, Numbers or Google Sheets, type Monday to Friday across row 1 from column B, and times down column A in half-hour steps (8:00, 8:30 … 17:00) from row 2.
2. **Add each class.** For each meeting, select the cells in that day's column from the start time to the end time, merge them (Excel: Home, [Merge & Center](https://support.microsoft.com/en-us/office/merge-and-unmerge-cells-5cbd15d5-9375-4540-907f-c673a93fcedf)) and type the course code, time and room. Give each course its own fill colour.
3. **Handle the odd ones.** Leave out anything marked Dropped or Withdrawn. Online courses with no meeting time go in a note under the grid, not in a time slot.
4. **Fit it to one page.** In Excel choose Page Layout, Orientation, Landscape, and under Scale to Fit set Width and Height to 1 page. Check File, Print preview before printing.

## Where Stella stops

- Stella reads what the registration says. Room or time changes made after it was printed won't be in it; tell Stella and it updates the sheet.
- Classes that meet on alternate weeks or only some weeks need a note; a weekly grid can't show them on its own.
- The registration's contents go to the AI model you use in Stella while it reads them. The spreadsheet is made on your computer.
- Recorded on Linux. Stella used its built-in Office document tool, which works the same on Mac and Windows, and a PDF text tool that was already installed; on a Mac or Windows PC it may install one first, which wasn't recorded.

## Questions

**Can I put the timetable in my calendar instead?**
Yes. Ask Stella for a calendar file (.ics) with repeating events for the term, which Google Calendar, Outlook and Apple Calendar import.

**Will it work with my college's registration format?**
Any registration summary or schedule with course, days and times works: a PDF, a screenshot, or text copied from the student portal.

**Can I change the colours or the time range?**
It's an ordinary spreadsheet, so edit it directly, or ask Stella to change colours, hours or paper size.

**Can it help with studying for those classes?**
Yes: see [make a study guide from notes](https://stella.sh/how/study/make-a-study-guide-from-notes) and [make Anki flashcards](https://stella.sh/how/study/make-anki-flashcards-from-notes).

**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: [Microsoft Support: Merge and unmerge cells](https://support.microsoft.com/en-us/office/merge-and-unmerge-cells-5cbd15d5-9375-4540-907f-c673a93fcedf).

## Related problems

- [Make a study guide from your lecture notes](https://stella.sh/how/study/make-a-study-guide-from-notes.md)
- [Convert an ICS calendar file to an Excel spreadsheet](https://stella.sh/how/contacts-calendar-email/convert-ics-to-excel.md)
- [Make Anki flashcards from your notes](https://stella.sh/how/study/make-anki-flashcards-from-notes.md)
- [Export your Kindle highlights into one file per book](https://stella.sh/how/study/export-kindle-highlights.md)
- [Print flashcards double-sided so the backs line up](https://stella.sh/how/study/print-flashcards-double-sided.md)
- [Make a word search from your spelling words](https://stella.sh/how/study/make-a-word-search.md)

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