How to Make a Timetable in Google Sheets (2026 Step-by-Step)

Google Sheets is the default tool a lot of students and team leads reach for when they need a weekly timetable. It's free, it's already open in another tab, and you don't need to learn a new app. But getting a Sheets timetable to actually look like a timetable — and not a wall of unevenly-sized cells — takes a few specific moves.

This guide walks through the cleanest way to make a timetable in Google Sheets, plus a faster shortcut if it turns out you didn't need a spreadsheet at all.

Before you start: should you actually use Sheets?

Sheets is great when:

• Multiple people need to edit the same timetable.
• You want totals, formulas, or conditional formatting (e.g. red cells when a slot is double-booked).
• You already live in Google Workspace and don't want to install anything.

Sheets is overkill when:

• You just want a clean weekly grid you can print or share as an image.
• You need pretty themes, color-coding, or a watermark-free PDF export.
• You don't want to fight column widths and merged cells.

If the second list is closer to your situation, our free weekly timetable template does this in under a minute, and exports a clean PDF or PNG with no sign-up.

Step 1: Open a blank Sheet and set up the grid

Open Sheets and start a blank spreadsheet. Then:

1. Type your column headers in row 2. Use A2 for "Time" and B2 through H2 for Mon–Sun. Leave row 1 for a title.
2. Type a title in A1 like "Weekly Timetable" and merge A1:H1. Format it bold and bumped to size 18.
3. In column A, list your hours down from A3 (e.g. 08:00, 09:00, 10:00, ...). Use the fill handle to drag-fill — Sheets auto-increments time.

You now have a recognizable grid. The defaults still look bad — column widths are wrong and the rows are too short.

Step 2: Fix the column and row sizing

This is where most people give up on Sheets timetables. Two specific moves fix it:

• Select columns B–H, right-click, "Resize columns". Pick "Fit to data" or set them all to 130 px. Equal widths read as a calendar; uneven widths read as a list.
• Select rows 3 to your last hour, right-click, "Resize rows". Set to 40 px or "Fit to data". Equal-height rows make the grid feel like a real timetable.

For column A (the time column), set it narrower — around 80 px is enough to fit "08:00" comfortably.

Step 3: Style the header row

Click row 2 (the day-of-week header). Then:

• Bold it.
• Fill it with a pale color (light blue, mint, or pastel pink). Format → Fill color.
• Center-align horizontally and vertically.
• Add a thin bottom border so the header reads as separated from the body.

Repeat for the title row (row 1). A bold title row plus a colored header row gives the grid an instant "professional timetable" feel rather than "spreadsheet I haven't styled yet".

Step 4: Drop in your activities

Click any body cell (e.g. C4 for Monday at 09:00) and type the activity name — "Math 101", "Standup", "Squat day", whatever. A few tips:

• Use cell fill colors to color-code by category. Subjects, projects, or activity types get different colors. This is what makes a timetable readable at a glance.
• Merge cells for multi-hour activities. Select two adjacent cells and Format → Merge cells → Merge vertically. The activity now spans two hours visually.
• Wrap text (Format → Wrapping → Wrap) so longer activity names don't overflow into the next column.

Step 5: Add conditional formatting (optional, powerful)

Conditional formatting is the one thing Google Sheets does that our online editor doesn't. It's worth using:

• Highlight all cells with the same activity name. Format → Conditional formatting → "Custom formula is" → =COUNTIF(B$3:H$15, B3) > 1. Now any activity that appears twice gets highlighted automatically.
• Mark cells red when a placeholder text like "TBD" appears — useful for spotting unscheduled slots before printing.

Step 6: Share or export

To share the timetable with a team or class:

• Click Share in the top right and either invite by email or copy the share link.
• Set permissions to "Viewer" if it's just for reading, or "Commenter" if you want feedback without edit access.

To export:

• File → Download → PDF (.pdf) for print.
• File → Download → Microsoft Excel (.xlsx) if a colleague uses Excel.
• File → Print and adjust scale if the PDF looks cramped — usually 75% scale fits cleanly on A4.

The shortcut: skip Sheets entirely

You'll have noticed this took eight steps and around fifteen minutes. If you don't actually need formulas or shared editing, you can do all of the above in under two minutes with our free weekly timetable maker — same grid, color themes already tuned, exports clean PDFs, no sign-up.

Or if you want the comfort of a real .xlsx file, download our Excel timetable template and drag it into Google Drive. Sheets converts it cleanly and you skip steps 1–4 above.

FAQ

Can I make a Monday-to-Friday only timetable in Google Sheets? Yes — just leave columns G and H (Sat/Sun) out of your day headers, or hide those columns entirely.

How do I print a Sheets timetable on one page? File → Print, then in the print dialog, set "Scale" to "Fit to width" or "Fit to page". Landscape orientation works better for 7-day grids.

What's the best way to color-code subjects? Use cell fill colors, not text colors. Fill colors are visible from across the room and survive black-and-white printing as different shades of grey.

Can I import a timetable PDF into Sheets? Not directly — PDFs aren't structured data. Use the Excel timetable template instead and drag the .xlsx into Drive.

---

Made with Google Sheets and a lot of column-width fiddling? Or done in two minutes with our free timetable maker. Both work — pick the one that fits your week.