How to Make a Class Schedule in Google Sheets Step by Step

To make a class schedule in Google Sheets, create a sheet with one row per class and columns for the day, start and end times, course, room, instructor, and notes. Add your courses, format the table, then sort or filter it to find information quickly. You can do this in Google Sheets in a web browser; you will need a Google account and your class details. A simple table is easy to update and works well on a phone or computer, while a separate weekly grid can make the timetable easier to scan at a glance.

What You’ll Need

A Google account with access to Google Sheets in a web browser.
Your course names, meeting days, start and end times, locations, and instructor names, if known.
Any term dates, rotation details, or reminders you want to include, such as exam weeks or alternating labs.

Step-by-Step

Create a new spreadsheet. Go to sheets.google.com, sign in, and choose Blank spreadsheet. Click the title at the upper left, which may say “Untitled spreadsheet,” and give the file a clear name such as “Fall 2026 Class Schedule.” Use a name that identifies the term so you can distinguish this file from schedules for other semesters.
Set up the columns. In the first row, enter one heading per column: Day, Start Time, End Time, Course, Room, Instructor, and Notes. Put each heading in its own cell, starting at A1. This row-based layout keeps each meeting together on one line. If a course meets on Monday and Wednesday, give it two rows—one for each meeting—rather than putting both days into one cell. That makes sorting and filtering more reliable.
Add one row for each class meeting. Starting in row 2, enter the details under the matching headings. For example, a Monday biology lecture could have Monday in Day, 9:00 AM in Start Time, 10:15 AM in End Time, Biology 101 in Course, Science 204 in Room, and the instructor’s name in Instructor. Repeat the meeting as a separate row for Wednesday if it meets then. Add useful context in Notes, such as “bring lab coat” or “meets in alternate room on week 4.” Avoid putting several unrelated details into one cell.
Format the time columns. Select the Start Time and End Time columns by clicking their column letters. Choose Format > Number > Time. Enter times consistently, including AM or PM when you use a 12-hour clock. If you prefer a 24-hour clock, enter times in that format and check that Sheets recognizes them as times. If an entry stays left-aligned or sorts alphabetically instead of chronologically, it may have been entered as text; re-enter it as a recognizable time and apply the time format again.
Make the headings easy to use. Select row 1 and use the toolbar to make the text bold and apply a fill color. To keep the headings visible while you scroll, choose View > Freeze > 1 row. You can widen a column by dragging the boundary between its lettered headers. For long notes, select the Notes column and choose Format > Wrapping > Wrap so the text can show on multiple lines instead of running into the next cell.
Add dropdowns for repeat information. Dropdowns help prevent inconsistent day names such as “Mon,” “Monday,” and “monday.” Select the cells where you want the day choices, for example A2:A50, then choose Data > Data validation > Add rule. In the rule panel, choose the dropdown option and enter Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, and Sunday as the choices. Apply or save the rule. You can also add a dropdown for Course if you have a fixed list of course names. If the panel offers a choice between rejecting invalid input and showing a warning, choose based on whether you want to enforce the list or allow exceptions.
Use color to distinguish courses or days. For a quick visual improvement, select the schedule range and choose Format > Alternating colors, then choose a style. To give each course a distinct color, select the Course cells and choose Format > Conditional formatting. In the side panel, set the rule to apply when the text is exactly a course name, choose a formatting style, and add another rule for each course you want to highlight. Keep the colors light enough that the text remains readable. Color is an aid, not a substitute for the course name; the schedule should still make sense when printed in black and white.
Sort and filter the schedule. Select the table, including its headings, and choose Data > Create a filter. Filter icons appear in the header cells, letting you show only one day, course, or instructor. To arrange the full table by day, select the whole schedule range and choose Data > Sort range > Advanced range sorting options. Indicate that the range has a header row, then choose Day as the first sort column. You can sort by Start Time afterward if needed. Always sort the entire table, not just one column, or you may separate a time from its course or room.
Check for conflicts and save a usable copy. Review each day from earliest to latest and compare the end time of each class with the next class’s start time. Check that you have enough time to move between buildings and that repeated meetings are listed on every correct day. Google Sheets saves changes automatically to Drive. If you need a version you can carry or post, choose File > Download and select a format such as PDF or Microsoft Excel. For printing, choose File > Print and check the preview; a wide schedule may need landscape orientation or adjusted scaling.
Optional: make a visual weekly view. If you want a calendar-style display as well as the detailed table, add a second sheet using the plus button near the sheet tabs. Name it “Weekly View.” Put time slots down the first column and days of the week across the top row, then enter course names in the cells where they meet. Choose time intervals that suit your timetable, such as 30 or 60 minutes, and make rows taller or wrap text for longer course names. Keep the row-based schedule as your detailed source of truth: a grid can be awkward when classes have different lengths or overlap, so check that both views stay consistent whenever you edit a meeting.

Common Mistakes

Combining multiple meetings into one row: A cell that says “Monday/Wednesday” is harder to filter and can hide a missing meeting. Use one row per day and keep the course details the same on both rows.

Sorting only one column: Sorting just the time column can leave the course and room behind. Select the complete table before sorting and confirm that the header-row option is set correctly.

Entering times as plain text: Entries such as “after lunch” or a time pasted with an unusual character may not sort as a real time. Use a consistent format and check that the times behave chronologically when sorted.

Making the visual grid too complicated: A separate grid with tiny time slots, merged cells, or too many colors can be difficult to maintain. Start with a simple table; add a weekly view only if it genuinely helps you see gaps and daily patterns.

Forgetting changes to the term: Room changes, holidays, and rotating schedules can make an otherwise correct timetable outdated. Put an update date or term label near the sheet title, and check special-week arrangements against an official course source.

Tips

Keep Notes for details that do not belong in the main columns, such as online meeting links, equipment, or an occasional room change. Do not put sensitive personal information in a schedule that you plan to share.
Use a consistent naming style for courses, rooms, and instructors. For example, choose either “Room 204” or “204” and use it throughout, rather than switching between several versions.
Use filter views if you want to save different filtered ways of looking at the same schedule without changing the view for everyone else. In Google Sheets, look under Data > Filter views to create or manage them.
Consider adding a “Type” column if lectures, labs, tutorials, and online sessions need to be distinguished. A dropdown can keep those labels consistent, and conditional formatting can give each type a restrained color.
Share carefully. Use the Share button to choose whether someone can view, comment on, or edit the file. If classmates only need to see your timetable, viewer access is safer than editor access.
Google Sheets in a browser is the focus of these directions. Excel has similar spreadsheet concepts, but its menu labels and some sharing and dropdown controls differ, so do not assume every Google Sheets path is identical in Excel.

Troubleshooting

The days or times sort in the wrong order. Check for inconsistent entries: “Mon” and “Monday” may be treated as different text, and times stored as text may sort alphabetically. Use one day label throughout, apply a dropdown if helpful, and re-enter times in a recognizable time format. If you sort by day, the order may be alphabetical rather than Monday-to-Sunday; for a fixed weekly order, use the weekly grid or add a custom day-order column with numbers and sort by that column first.

The dropdown arrow does not appear or a value is rejected. Confirm that the rule covers the cells you are editing and that the text you entered matches an allowed option. Select a cell with the rule and open Data > Data validation to inspect or edit it. If you pasted data into the range, the paste may have replaced validation; recreate or extend the rule over the affected cells.

The schedule looks crowded or is cut off when printed. Widen the Course, Room, or Notes columns, use text wrapping, or reduce unnecessary notes. In File > Print, review the preview and try landscape orientation or a fit-to-width scaling option. If the text becomes too small, print only the relevant term or day rather than shrinking the entire sheet.

A filter hides some classes. Open the filter menu in the relevant heading and clear the selected conditions, or choose the option to select all values. Also check that the class rows are inside the filtered range; newly added rows below the range may not be included. Recreate the filter on the full table if needed.

Someone cannot open the schedule. Click Share and check that the intended people or group have access. If you share a link, set general access deliberately rather than assuming everyone can view it. For a read-only timetable, give viewers access instead of editing access.

Frequently Asked Questions

Can I make a class schedule in Google Sheets for free?
Yes. A Google account can create and edit spreadsheets in Google Sheets without a paid spreadsheet app. Your available storage and account features can depend on your Google account or organization.

Should I use a table or a weekly calendar grid?
A table is usually better for entering, sorting, filtering, and updating class details. A weekly grid is more visual for spotting gaps and busy days. You can keep a detailed table on one sheet and a simpler weekly view on another.

How do I show a class that meets more than once a week?
Add a separate row for every meeting day, repeating the course name, time, room, and instructor as appropriate. This lets you filter by day without losing one of the meetings.

Can I share my schedule with classmates?
Yes. Use the Share button to invite specific people or create a link, then select their access level. Viewer access lets people see the schedule without changing it. Avoid including information you do not want shared.

Can I use the schedule on my phone?
Yes. You can open the spreadsheet in a mobile browser or the Google Sheets app. A narrow table may require horizontal scrolling, so keep headings short and use the browser or app’s freeze and zoom controls where available.

How do I keep a schedule for a new semester?
Use File > Make a copy to preserve the current term, then rename the copy for the new semester and update its rows. Check the copied schedule carefully instead of assuming course times, locations, or instructors are unchanged.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.