Calrows
How to turn a class timetable in Google Sheets™ into Google Calendar™ events
Updated 4 October 2026
Schools, tutoring centres and teachers often plan the term in a spreadsheet. Calrows turns that timetable into calendar events, so classes, rooms and teachers show up where people actually check their day.
Lay out the timetable
Use one row per lesson, with the date and time in Start and End:
| Title | Start | End | Location | Guests | Color |
|---|---|---|---|---|---|
| Maths: Year 9 | 2026-10-12 09:00 | 2026-10-12 09:50 | Room 4 | [email protected] | blue |
| Chemistry: Year 10 | 2026-10-12 10:00 | 2026-10-12 10:50 | Lab 2 | [email protected] | green |
| Half-term break | 2026-10-26 | 2026-10-30 | grey |
For a whole-day item like a holiday, add an All day column and put TRUE. Calrows puts all-day events on the right dates in any time zone.
Send it to the calendar
- Install Calrows from the Google Workspace Marketplace (free), open your sheet, then go to Extensions › Calrows › Open sidebar.
- Choose the calendar, for example a "Year 9 timetable" calendar you can share with students or parents.
- Map the columns and click Send rows to Calendar.
Teachers in the Guests column are added as guests on their lessons. Change a room or a time in the sheet and send again: the lesson updates instead of appearing twice.
At the end of term
Need a record of what was taught? Import from Calendar exports any date range back into a sheet, and the Timesheet panel adds up hours per class or tutor, which helps with tutor pay.
The free plan creates up to 50 new events a month, and its limits are shown in the sidebar before anything runs. Pro is unlimited and a one-time payment with no auto-renewal.
Frequently asked questions
Does it create weekly repeating lessons?
Calrows creates one event per row, not repeating series. Fill the term's dates down the sheet (Google Sheets can do this automatically) and send them all at once.
Can students see the timetable?
Send it to a calendar you share with them, or add them in the Guests column.
What if the timetable changes mid-term?
Edit the rows and send again; existing lessons are updated, not duplicated.