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

To make a weekly schedule in Google Sheets, create a grid with time slots down the first column and days of the week across the top, then enter activities in the matching cells. Add dates if you are planning a particular week, format the grid so it is easy to scan, and keep a blank copy to reuse. You can build and edit the schedule in a web browser with a Google account.

What You’ll Need

A Google account and a web browser with access to Google Sheets.
A rough list of your activities, their days and times, and any regular commitments you want to include.
A decision about whether this is a reusable weekly template or a schedule for specific dates.

Step-by-Step

Create a spreadsheet and name it. Open Google Sheets, choose Blank spreadsheet, and click the Untitled spreadsheet name at the top left to give the file a useful title, such as Weekly Schedule. A descriptive file name helps you find it later, especially if you keep separate personal, school, or work planners. The spreadsheet opens in a browser and saves changes automatically while you are online.
Set up the days across the top. In cell A1, type Time. In B1 through H1, enter Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, and Sunday, one day per cell. This layout gives you a full week in one view, with each day in its own column. If you only need weekdays, you can leave the weekend columns out; you can add them later by right-clicking a column letter and choosing Insert 1 column left or Insert 1 column right.
Choose whether to add dates. For a repeating schedule, day names may be enough. For a plan tied to a particular week, use row 2 for dates: keep the day names in row 1 and enter the corresponding date beneath each day. Enter dates as spreadsheet dates where possible rather than relying on labels such as 6/1, which can be ambiguous. To change how a date looks, select the date cells and choose Format > Number, then choose a date format. Check that the dates match the week you intend to plan.
Build time slots down column A. Starting in A2 for a simple template, or A3 if you added a date row, enter the first time you want to show, such as 8:00 AM. Enter the next time beneath it, such as 8:30 AM, and select both cells. Drag the small blue square at the lower-right corner of the selection down the column to continue the half-hour pattern. If the displayed results are not times, select the column and choose Format > Number > Time. Choose an interval that suits your routine: 30-minute slots show detail, while hourly slots make a less crowded overview.
Enter activities in the matching cells. Find the row for the start time and the column for the day, then type the activity, appointment, or task. For example, put a Monday 9:00 AM meeting in the Monday column on the 9:00 AM row. Use short labels such as Team meeting or Study so the grid stays readable. For an activity that lasts several time slots, enter its name in each relevant cell, or select the cells covering the block and use the merge option only if you do not need separate entries in those cells. The first approach is easier to edit and filter later.
Make the schedule easier to read. Select row 1 and use the toolbar’s bold and fill-color controls to distinguish the headings. You can also select column A and use bold text for the times. To resize a column, drag the boundary between its letter headings; double-clicking the boundary adjusts the width to fit its contents. For long task names, select the relevant cells and choose Format > Wrapping > Wrap. Adjust row heights if wrapped text is cut off. Avoid using too many colors: one shade for headings and a few consistent activity categories are usually enough.
Highlight categories or important items. Apply a fill color to selected cells for recurring categories such as work, meals, or exercise, and use the same color for the same type of activity throughout the week. If you want rules rather than manual coloring, select the schedule range and choose Format > Conditional formatting. In the side panel, set a rule that matches text, then choose a formatting style. For instance, a rule for cells containing the word Workout can highlight those entries. Check the Apply to range field so the rule covers the schedule cells, not unrelated headings.
Keep a clean copy and check the finished week. If the plan will be reused, leave one tab as a blank template and make a copy for each new week. Use the arrow on the sheet tab or its right-click menu and choose Duplicate, then rename the copied tab with the week’s date. Before relying on the schedule, scan each day for overlaps, missing dates, and activities entered in the wrong column. If you need a paper copy, choose File > Print and review the print preview; landscape orientation or a fit-to-width setting may help a seven-day grid fit on a page.

Common Mistakes

Choosing slots that are too large or too small: Hourly rows are quick to fill but can hide the difference between a 9:00 and 9:30 appointment. Five- or ten-minute rows can make the sheet unwieldy if you only plan broad blocks. Pick an interval based on how precisely you need to plan, and change it if the grid becomes hard to maintain.

Mixing up dates and day names: A dated schedule can become misleading if you change the week but leave old dates in place. Confirm that each date sits under the correct weekday. For a recurring template, use day names without dates or clear the old dates before reusing it.

Putting several unrelated activities in one cell: Long lists inside a single cell are difficult to scan and color consistently. Give each activity its own time slot when possible. Also avoid merging large areas just to make them look like a calendar block; merged cells can make later editing and copying more awkward.

Using color as the only label: A colored cell may be hard to interpret when printed in black and white or viewed by someone who distinguishes colors differently. Include the activity name, and use color as an extra visual cue rather than its only explanation.

Tips

Start with fixed commitments. Add work hours, classes, recurring appointments, and other non-negotiable events first. Then place flexible tasks into the open spaces. This makes the schedule more realistic than filling every cell with ideal plans.
Leave room for transitions. Add travel, preparation, breaks, or reset time between demanding activities. A schedule that includes only appointment start times can look possible on screen but be difficult to follow in practice.
Use a consistent naming system. Keep labels short and choose the same wording each week, such as Admin, Focus work, or Lunch. Consistency makes the plan easier to skim and makes text-based conditional formatting more dependable.
Freeze the headings when the schedule is long. In Google Sheets, choose View > Freeze > 1 row to keep the day headings visible while scrolling. If you added a second row of dates and want both heading rows to stay visible, choose View > Freeze > 2 rows. You can freeze column A as well with View > Freeze > 1 column, so the times remain visible when moving horizontally.
Use sharing carefully. Click Share to invite collaborators or adjust access. Give people Editor access only when they need to change the schedule; Viewer access is enough for people who only need to read it. Check the sharing settings before putting private appointments or personal information in a file.
Make a weekly review part of the routine. At the end of the week, note which plans changed and which time slots were consistently too tight. Adjust the reusable template instead of repeatedly copying a schedule that does not fit your needs.

Troubleshooting

The times display as numbers or do not advance in order: Select the time cells and choose Format > Number > Time. When using autofill, select the first two correctly entered times before dragging the fill handle so Sheets can recognize the interval. If it repeats the same value, undo the fill and confirm that the two starting entries are different and use the same time format.

Text is hidden or makes columns too wide: Select the affected cells and choose Format > Wrapping > Wrap, then increase the row height if necessary. For a schedule that is difficult to read because of long descriptions, shorten the labels and put extra details in a note or a separate notes column rather than widening every day column.

A date appears under the wrong weekday: Check the actual date value and the column heading instead of changing the display format alone. Correct the date or move it to the appropriate day column. If the schedule is meant to repeat every week, consider removing dates and keeping only the weekday names to avoid carrying forward stale information.

Conditional formatting colors the wrong cells: Open Format > Conditional formatting and inspect the Apply to range field and the rule text. Correct the selected range, then make sure the rule matches the wording actually used in the cells. Remove duplicate or outdated rules if several rules compete for the same range.

The printed page is cut off: Choose File > Print and inspect the preview before printing. Try landscape orientation, adjust the scale to fit the schedule to the page width, or print only the schedule range. If the text becomes too small, use a larger page size or print across more than one page rather than shrinking it until it is unreadable.

Frequently Asked Questions

Can I make a weekly schedule without using a template?

Yes. Create the day and time grid directly in a blank spreadsheet. A template is useful only if you want to reuse the same layout; you can make a blank version yourself and duplicate it for later weeks.

How do I make a schedule that starts on Sunday?

Put Sunday in column B1 and enter the remaining days from Monday through Saturday across the next columns. The schedule does not require a particular first day; keep the dates, if included, aligned with the headings.

Can I use 15-minute time slots?

Yes. Enter two times 15 minutes apart in the first two time cells, select both, and drag the fill handle down. Check the sequence before adding activities, since a long list of small intervals can make the sheet harder to scan.

How do I reuse the schedule next week?

Right-click the sheet tab and choose Duplicate, then rename the copy and update its dates and activities. Keep the original tab as a blank template so you can start over without deleting the source layout.

Can other people edit my Google Sheets schedule?

Yes. Use the Share button to invite specific people and choose their access level. Editors can change the sheet, while viewers can read it without editing. Review access if the schedule contains information you do not want shared broadly.

Is making this schedule different in Excel?

The basic grid works in both programs, but the menus and sharing tools differ. This guide uses Google Sheets in a web browser, including its Google Sheets menu paths; do not assume an Excel menu command will be in the same place.

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.