{"id":30360,"date":"2022-06-17T09:00:00","date_gmt":"2022-06-17T09:00:00","guid":{"rendered":"https:\/\/toggl.com\/blog\/?p=30360"},"modified":"2024-06-15T07:41:33","modified_gmt":"2024-06-15T07:41:33","slug":"google-sheets-schedule-planner","status":"publish","type":"post","link":"https:\/\/toggl.com\/blog\/google-sheets-schedule-planner","title":{"rendered":"How To Make A Schedule In Google Sheets (With Free Templates)"},"content":{"rendered":"\n<p>Google Sheets is a free, flexible, and online alternative to <a href=\"https:\/\/toggl.com\/blog\/best-planner-apps\">planner apps<\/a> that you can use to organize and manage your schedule. Want to know how? Keep reading to learn how to make a schedule and daily planner in Google Sheets.<\/p>\n\n\n\n<p>Here\u2019s what\u2019s in the article:<\/p>\n\n\n\n\n\n<p>Ready to get started? Let\u2019s dive in.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>How to make a weekly schedule in Google Sheets<\/strong><\/h2>\n\n\n\n<p>Here\u2019s a simple three-step process to create a weekly planner in Google Sheets.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 1: Make a copy of the free Google Sheets Weekly Schedule template.<\/strong><\/h3>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"670\" src=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2022\/06\/make-a-copy-1024x670.jpg\" alt=\"Make a copy of the schedule template\" class=\"wp-image-30364\" srcset=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2022\/06\/make-a-copy-1024x670.jpg 1024w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2022\/06\/make-a-copy-300x196.jpg 300w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2022\/06\/make-a-copy-768x502.jpg 768w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2022\/06\/make-a-copy-940x615.jpg 940w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2022\/06\/make-a-copy.jpg 1040w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>To make a copy:<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li>Click to open the <a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1RNlJECZA4FScjZZ_wzyGtClE5oTvuyHpy8O0U2uH2KQ\/copy\" target=\"_blank\">Weekly Schedule Planner template<\/a>.<\/li><li>Go to File \u2192 Make a copy to save the template to your Google Drive.<\/li><\/ol>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 2: Familiarize yourself with the schedule template<\/strong><\/h3>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"588\" src=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2022\/06\/weekly-schedule-planner-1024x588.jpg\" alt=\"Weekly Schedule Planner Template for Google Sheets\" class=\"wp-image-30362\" srcset=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2022\/06\/weekly-schedule-planner-1024x588.jpg 1024w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2022\/06\/weekly-schedule-planner-300x172.jpg 300w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2022\/06\/weekly-schedule-planner-768x441.jpg 768w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2022\/06\/weekly-schedule-planner-350x200.jpg 350w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2022\/06\/weekly-schedule-planner-940x540.jpg 940w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2022\/06\/weekly-schedule-planner.jpg 1200w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<p>You\u2019ll notice that this weekly planner has the following features:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Space to organize your schedule for an entire week<\/li><li>Undated planner with a customizable week start date<\/li><li>30-minute slots to plan your day in detail<\/li><li>Space to add notes and to-do items at the end<\/li><li>Automatic light-green background for scheduled events<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 3: Customize the weekly schedule start date<\/strong><\/h3>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"616\" src=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2022\/06\/customize-weekly-schedule-start-date-1024x616.jpg\" alt=\"Customize weekly schedule start date\" class=\"wp-image-30365\" srcset=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2022\/06\/customize-weekly-schedule-start-date-1024x616.jpg 1024w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2022\/06\/customize-weekly-schedule-start-date-300x181.jpg 300w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2022\/06\/customize-weekly-schedule-start-date-768x462.jpg 768w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2022\/06\/customize-weekly-schedule-start-date-230x137.jpg 230w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2022\/06\/customize-weekly-schedule-start-date-940x566.jpg 940w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2022\/06\/customize-weekly-schedule-start-date.jpg 1130w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<p>You\u2019ll notice that you can customize the week start date in cell \u201cC4\u201d of the Google Sheet. Changing this date automatically adjusts the dates and days in rows 7 and 8.<\/p>\n\n\n\n<p>To customize the week start date:<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li>Double-click on the \u201cC4\u201d cell.<\/li><li>On the calendar popup, select the date from which you want the week to start.&nbsp;<\/li><\/ol>\n\n\n\n<p>Alternatively, you can type in the date in cell \u201cC4\u201d in your local format.<\/p>\n\n\n\n<p>With this feature, you can choose if you want your week to start on a Sunday, Monday, or any other day of the week.&nbsp;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>How to make a monthly schedule in Google Sheets?<\/strong><\/h2>\n\n\n\n<p>The steps to create a monthly schedule are very similar to those above. However, you need a different template for a monthly planner.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 1: Make a copy of the Google Sheets Monthly Schedule Template<\/strong><\/h3>\n\n\n\n<p>To make a copy:<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li>Click to open the <a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1lfJtXm2lt7j9tN2uMPysRbcQjYusdf3mV92Zk4wO1ZI\/copy\" target=\"_blank\">Monthly Schedule Planner template<\/a>.<\/li><li>Go to File \u2192 Make a copy to save the template to your Google Drive.<\/li><\/ol>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 2: Familiarize yourself with the monthly planner<\/strong><\/h3>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"588\" src=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2022\/06\/monthly-schedule-planner-1024x588.jpg\" alt=\"Monthly schedule planner template\" class=\"wp-image-30366\" srcset=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2022\/06\/monthly-schedule-planner-1024x588.jpg 1024w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2022\/06\/monthly-schedule-planner-300x172.jpg 300w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2022\/06\/monthly-schedule-planner-768x441.jpg 768w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2022\/06\/monthly-schedule-planner-350x200.jpg 350w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2022\/06\/monthly-schedule-planner-940x540.jpg 940w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2022\/06\/monthly-schedule-planner.jpg 1200w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<p>It comes with the following features:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Space to organize an entire month\u2019s schedule<\/li><li>Space to add notes and to-do items<\/li><li>Undated calendar with customizable month<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 3: Customize the monthly schedule planner<\/strong><\/h3>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"616\" src=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2022\/06\/customize-monthlt-schedule-planner-1024x616.jpg\" alt=\"Customize the monthly schedule planner\" class=\"wp-image-30367\" srcset=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2022\/06\/customize-monthlt-schedule-planner-1024x616.jpg 1024w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2022\/06\/customize-monthlt-schedule-planner-300x181.jpg 300w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2022\/06\/customize-monthlt-schedule-planner-768x462.jpg 768w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2022\/06\/customize-monthlt-schedule-planner-230x137.jpg 230w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2022\/06\/customize-monthlt-schedule-planner-940x566.jpg 940w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2022\/06\/customize-monthlt-schedule-planner.jpg 1130w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>You can change the month in cell \u201cC4\u201d. When you change the month, it automatically changes the days and the dates for the month below.<\/p>\n\n\n\n<p>To customize the month:<\/p>\n\n\n\n<ol class=\"wp-block-list\" start=\"3\"><li>Double-click on the \u201cC4\u201d cell.<\/li><li>On the calendar popup, select any date from the month for which you want to create a planner.<\/li><\/ol>\n\n\n\n<p>Alternatively, you can type in the first date of a month in cell \u201cC4\u201d in your local format.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Tips to improve your Google Sheets scheduling experience<\/strong><\/h2>\n\n\n\n<p>Google Sheets comes with powerful features. Here are three tips to improve your scheduling and planning experience.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Tip 1: Create schedules for more than a week or month<\/strong><\/h3>\n\n\n\n<p>You can easily create schedules for multiple weeks (or months) by duplicating the sheet \u201cSheet 1\u201d in your Google Sheets spreadsheet.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"670\" src=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2022\/06\/duplicate-sheet-1024x670.jpg\" alt=\"Duplicate sheet to create a schedule for multiple weeks\" class=\"wp-image-30368\" srcset=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2022\/06\/duplicate-sheet-1024x670.jpg 1024w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2022\/06\/duplicate-sheet-300x196.jpg 300w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2022\/06\/duplicate-sheet-768x502.jpg 768w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2022\/06\/duplicate-sheet-940x615.jpg 940w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2022\/06\/duplicate-sheet.jpg 1040w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>To duplicate a sheet:<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li>Click on the dropdown arrow next to the sheet\u2019s name.&nbsp;<\/li><li>Then click \u201cDuplicate\u201d<\/li><\/ol>\n\n\n\n<p>To make more sense of your weeks, you can also rename the sheet to a suitable name.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Tip 2: Freeze rows to improve efficiency<\/strong><\/h3>\n\n\n\n<p>Freezing a row lets you see it continuously on the screen even when you scroll to the bottom of the sheet.&nbsp;<\/p>\n\n\n\n<p>In the week or month planner, freezing the Day rows will save you the mental energy to figure out which day of the week or month you\u2019re looking at. Plus, you don\u2019t have to scroll up and down constantly to look up a specific date or day.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"670\" src=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2022\/06\/freeze-rows-1024x670.jpg\" alt=\"Freeze rows in Google Sheets schedule to improve productivity\" class=\"wp-image-30369\" srcset=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2022\/06\/freeze-rows-1024x670.jpg 1024w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2022\/06\/freeze-rows-300x196.jpg 300w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2022\/06\/freeze-rows-768x502.jpg 768w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2022\/06\/freeze-rows-940x615.jpg 940w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2022\/06\/freeze-rows.jpg 1040w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<p>To freeze date and day rows:<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li>Select rows 7 and 8 in the weekly planner or row 7 in the monthly schedule planner.<\/li><li>Then click on \u201cView \u2192 Freeze \u2192 Up to row 4\u201d in the spreadsheet menu to freeze the rows.<\/li><\/ol>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Tip 3: Make your schedule available offline<\/strong><\/h3>\n\n\n\n<p>There are times when you may have to access your schedule spreadsheet without an internet connection.&nbsp;<\/p>\n\n\n\n<p>All you need is the <a href=\"https:\/\/chrome.google.com\/webstore\/detail\/google-docs-offline\/ghbmnnjooekpmoecnnnilnnbdlolhkhi\" target=\"_blank\">Google Docs Offline<\/a> extension (along with the Chrome browser).<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"792\" height=\"623\" src=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2022\/06\/google-docs-offline-settings.jpg\" alt=\"Enable offline mode in Google Docs\" class=\"wp-image-30371\" srcset=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2022\/06\/google-docs-offline-settings.jpg 792w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2022\/06\/google-docs-offline-settings-300x236.jpg 300w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2022\/06\/google-docs-offline-settings-768x604.jpg 768w\" sizes=\"auto, (max-width: 792px) 100vw, 792px\" \/><\/figure>\n<\/div>\n\n\n<p>Once you\u2019ve installed the extension, here\u2019s how you can enable offline mode for all your Google documents:<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li>Go to <a href=\"https:\/\/docs.google.com\/\" target=\"_blank\">docs.google.com<\/a><\/li><li>Click on the hamburger menu icon before the logo, then click on \u201cSettings\u201d<\/li><li>Finally, enable the offline mode<\/li><\/ol>\n\n\n\n<p>Now you can access your schedule even with limited internet.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Pros and cons of a Google Sheets schedule<\/strong><\/h2>\n\n\n\n<p>Google Sheets can be a powerful yet cost-effective way to make and manage your schedule. It comes with the following advantages:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>It\u2019s free<\/strong>: Google Sheets comes free with your Gmail (or Google Workspace) account. You can save some money spent on a scheduling tool.<\/li><li><strong>Everyone knows how to use a spreadsheet:<\/strong> It\u2019s simple. So you don\u2019t have to spend time learning a new tool.&nbsp;<\/li><li><strong>Easy to share and collaborate:<\/strong> Share your daily schedule with your team. Let them add comments or notes.<\/li><\/ul>\n\n\n\n<p><strong>Disadvantages <\/strong>include:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>Team schedules are a nightmare: <\/strong>Managing and coordinating plans with your team, across multiple spreadsheets can be a challenge.&nbsp;<\/li><li><strong>Limited details:<\/strong> You can only include so much information in a spreadsheet cell. You can\u2019t attach a file or document.<\/li><li><strong>Missing long-term view:<\/strong> With Google Sheets, you can plan for a week or a month in advance. But what if you need a bird\u2019s-eye view over the next six months or a year?&nbsp;<\/li><\/ul>\n\n\n\n<p>If these drawbacks affect your work efficiency, you may want to consider using other tools to manage your (and your team\u2019s) schedule.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Google Sheets alternatives for managing schedules<\/strong><\/h2>\n\n\n\n<p>From free calendars to simple timeline tools you have a lot of options for managing schedules.<\/p>\n\n\n\n<p>Calendars are great for capturing, organizing, and managing personal events. However, for managing your entire team&#8217;s event schedules and tasks you need a bit more.<\/p>\n\n\n\n<p>Toggl Plan\u2014a simple work scheduling and tracking tool for teams\u2014can help.<\/p>\n\n\n\n<p>To plan your week, month, or even a year create a Plan timeline. Then click on the timeline to create a task. Change the tasks\u2019 schedule with simple drag and drop. Or drag the tasks\u2019 ends on the timeline.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"814\" height=\"501\" src=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2022\/06\/workload-management-toggl-plan.jpg\" alt=\"Toggl Plan's drag and drop timelines\" class=\"wp-image-30353\" srcset=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2022\/06\/workload-management-toggl-plan.jpg 814w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2022\/06\/workload-management-toggl-plan-300x185.jpg 300w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2022\/06\/workload-management-toggl-plan-768x473.jpg 768w\" sizes=\"auto, (max-width: 814px) 100vw, 814px\" \/><\/figure>\n<\/div>\n\n\n<p>With <a class=\"wpil_keyword_link\" href=\"https:\/\/toggl.com\/plan\/index\"   title=\"Toggl Plan\" data-wpil-keyword-link=\"linked\">Toggl Plan<\/a> you can create unlimited Plan timelines and add unlimited color-coded milestones. To get a clear overview of your schedule zoom in on a week\u2019s schedule or zoom out to a month, quarter, or year.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"661\" src=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2021\/10\/illus-zoom-levels-2x-1024x661.png\" alt=\"Adjust timeline zoom levels in Toggl Plan to get a long-term overview.\" class=\"wp-image-27653\" srcset=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2021\/10\/illus-zoom-levels-2x-1024x661.png 1024w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2021\/10\/illus-zoom-levels-2x-300x194.png 300w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2021\/10\/illus-zoom-levels-2x-768x495.png 768w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2021\/10\/illus-zoom-levels-2x-940x606.png 940w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2021\/10\/illus-zoom-levels-2x.png 1240w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Next, assign tasks to team members (or yourself). Add task details, attach files, or include a task checklist to improve the task-completion quality. You can also schedule the tasks for a specific time.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"720\" height=\"506\" src=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2020\/06\/team-timeline.png\" alt=\"See your entire team's schedule in one place with Toggl Plan's Team timeline.\" class=\"wp-image-21522\" srcset=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2020\/06\/team-timeline.png 720w, https:\/\/toggl.com\/blog\/wp-content\/uploads\/2020\/06\/team-timeline-300x211.png 300w\" sizes=\"auto, (max-width: 720px) 100vw, 720px\" \/><\/figure>\n<\/div>\n\n\n<p>Finally, you can also visualize your team\u2019s schedule with the Team timeline. This helps you detect any scheduling conflicts and team members overwhelmed with work.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Pricing<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>Free forever<\/strong> for solo users.<\/li><li><strong>Team plan: $9 \/user\/month.<\/strong> Team timelines, recurring tasks, in-app and email notifications.<\/li><li><strong>Business plan: $15 \/user\/month.<\/strong> Guest users, single sign-on, data export.<\/li><\/ul>\n\n\n\n<p><a href=\"https:\/\/togglplan.page.link\/?link=https%3A%2F%2Fplan.toggl.com%2F%23signup&amp;apn=com.teamweek.android.app&amp;ibi=com.teamweek.app&amp;isi=1242738862\" target=\"_blank\">Try Toggl Plan for free<\/a>. No credit card required.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Learn step-by-step how to make a weekly &#038; monthly schedule in Google Sheets using free templates to manage your schedule like a pro.<\/p>\n","protected":false},"author":607,"featured_media":31905,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[995],"tags":[],"class_list":["post-30360","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-resource-management"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How To Make A Schedule In Google Sheets (With Free Templates)<\/title>\n<meta name=\"description\" content=\"Learn step-by-step how to make a weekly &amp; monthly schedule in Google Sheets using free templates to manage your schedule like a pro.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/toggl.com\/blog\/google-sheets-schedule-planner\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Make A Schedule In Google Sheets (With Free Templates)\" \/>\n<meta property=\"og:description\" content=\"Learn step-by-step how to make a weekly &amp; monthly schedule in Google Sheets using free templates to manage your schedule like a pro.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/toggl.com\/blog\/google-sheets-schedule-planner\" \/>\n<meta property=\"og:site_name\" content=\"Toggl Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/Toggl\/\" \/>\n<meta property=\"article:published_time\" content=\"2022-06-17T09:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-06-15T07:41:33+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2022\/06\/Blog-Header-Make-a-schedule-on-Google-Sheets_Blog-Header-1640x982-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"2560\" \/>\n\t<meta property=\"og:image:height\" content=\"1537\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Jitesh Patil\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@toggl\" \/>\n<meta name=\"twitter:site\" content=\"@toggl\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jitesh Patil\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/toggl.com\/blog\/google-sheets-schedule-planner#article\",\"isPartOf\":{\"@id\":\"https:\/\/toggl.com\/blog\/google-sheets-schedule-planner\"},\"author\":{\"name\":\"Jitesh Patil\",\"@id\":\"https:\/\/toggl.com\/blog\/#\/schema\/person\/1f14ae0cadc59db374eaaf4c8de016e6\"},\"headline\":\"How To Make A Schedule In Google Sheets (With Free Templates)\",\"datePublished\":\"2022-06-17T09:00:00+00:00\",\"dateModified\":\"2024-06-15T07:41:33+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/toggl.com\/blog\/google-sheets-schedule-planner\"},\"wordCount\":1190,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/toggl.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/toggl.com\/blog\/google-sheets-schedule-planner#primaryimage\"},\"thumbnailUrl\":\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2022\/06\/Blog-Header-Make-a-schedule-on-Google-Sheets_Blog-Header-1640x982-1.png\",\"articleSection\":[\"Resource Management\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/toggl.com\/blog\/google-sheets-schedule-planner\",\"url\":\"https:\/\/toggl.com\/blog\/google-sheets-schedule-planner\",\"name\":\"How To Make A Schedule In Google Sheets (With Free Templates)\",\"isPartOf\":{\"@id\":\"https:\/\/toggl.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/toggl.com\/blog\/google-sheets-schedule-planner#primaryimage\"},\"image\":{\"@id\":\"https:\/\/toggl.com\/blog\/google-sheets-schedule-planner#primaryimage\"},\"thumbnailUrl\":\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2022\/06\/Blog-Header-Make-a-schedule-on-Google-Sheets_Blog-Header-1640x982-1.png\",\"datePublished\":\"2022-06-17T09:00:00+00:00\",\"dateModified\":\"2024-06-15T07:41:33+00:00\",\"description\":\"Learn step-by-step how to make a weekly & monthly schedule in Google Sheets using free templates to manage your schedule like a pro.\",\"breadcrumb\":{\"@id\":\"https:\/\/toggl.com\/blog\/google-sheets-schedule-planner#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/toggl.com\/blog\/google-sheets-schedule-planner\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/toggl.com\/blog\/google-sheets-schedule-planner#primaryimage\",\"url\":\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2022\/06\/Blog-Header-Make-a-schedule-on-Google-Sheets_Blog-Header-1640x982-1.png\",\"contentUrl\":\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2022\/06\/Blog-Header-Make-a-schedule-on-Google-Sheets_Blog-Header-1640x982-1.png\",\"width\":2560,\"height\":1537,\"caption\":\"Illustration of a woman writing something in a book that has Google Sheets logo as the cover\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/toggl.com\/blog\/google-sheets-schedule-planner#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/toggl.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Make A Schedule In Google Sheets (With Free Templates)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/toggl.com\/blog\/#website\",\"url\":\"https:\/\/toggl.com\/blog\/\",\"name\":\"Toggl Blog\",\"description\":\"Everything works much better with Toggl\",\"publisher\":{\"@id\":\"https:\/\/toggl.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/toggl.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/toggl.com\/blog\/#organization\",\"name\":\"Toggl\",\"url\":\"https:\/\/toggl.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/toggl.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2022\/10\/toggl-logo.png\",\"contentUrl\":\"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2022\/10\/toggl-logo.png\",\"width\":814,\"height\":814,\"caption\":\"Toggl\"},\"image\":{\"@id\":\"https:\/\/toggl.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/Toggl\/\",\"https:\/\/x.com\/toggl\",\"https:\/\/www.instagram.com\/usetoggl\/\",\"https:\/\/www.linkedin.com\/company\/toggl\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/toggl.com\/blog\/#\/schema\/person\/1f14ae0cadc59db374eaaf4c8de016e6\",\"name\":\"Jitesh Patil\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/18c6b101c496f4ed723c0e9716f9344068d223a5ae60030e45f79cfc521e7477?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/18c6b101c496f4ed723c0e9716f9344068d223a5ae60030e45f79cfc521e7477?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/18c6b101c496f4ed723c0e9716f9344068d223a5ae60030e45f79cfc521e7477?s=96&d=mm&r=g\",\"caption\":\"Jitesh Patil\"},\"description\":\"Jitesh is an SEO and content specialist. He manages content projects at Toggl and loves sharing actionable tips to deliver projects profitably.\",\"sameAs\":[\"https:\/\/toggl.com\",\"https:\/\/www.linkedin.com\/in\/jiteshpatil\/\"],\"url\":\"https:\/\/toggl.com\/blog\/author\/jitesh-patil\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How To Make A Schedule In Google Sheets (With Free Templates)","description":"Learn step-by-step how to make a weekly & monthly schedule in Google Sheets using free templates to manage your schedule like a pro.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/toggl.com\/blog\/google-sheets-schedule-planner","og_locale":"en_US","og_type":"article","og_title":"How To Make A Schedule In Google Sheets (With Free Templates)","og_description":"Learn step-by-step how to make a weekly & monthly schedule in Google Sheets using free templates to manage your schedule like a pro.","og_url":"https:\/\/toggl.com\/blog\/google-sheets-schedule-planner","og_site_name":"Toggl Blog","article_publisher":"https:\/\/www.facebook.com\/Toggl\/","article_published_time":"2022-06-17T09:00:00+00:00","article_modified_time":"2024-06-15T07:41:33+00:00","og_image":[{"width":2560,"height":1537,"url":"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2022\/06\/Blog-Header-Make-a-schedule-on-Google-Sheets_Blog-Header-1640x982-1.png","type":"image\/png"}],"author":"Jitesh Patil","twitter_card":"summary_large_image","twitter_creator":"@toggl","twitter_site":"@toggl","twitter_misc":{"Written by":"Jitesh Patil","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/toggl.com\/blog\/google-sheets-schedule-planner#article","isPartOf":{"@id":"https:\/\/toggl.com\/blog\/google-sheets-schedule-planner"},"author":{"name":"Jitesh Patil","@id":"https:\/\/toggl.com\/blog\/#\/schema\/person\/1f14ae0cadc59db374eaaf4c8de016e6"},"headline":"How To Make A Schedule In Google Sheets (With Free Templates)","datePublished":"2022-06-17T09:00:00+00:00","dateModified":"2024-06-15T07:41:33+00:00","mainEntityOfPage":{"@id":"https:\/\/toggl.com\/blog\/google-sheets-schedule-planner"},"wordCount":1190,"commentCount":0,"publisher":{"@id":"https:\/\/toggl.com\/blog\/#organization"},"image":{"@id":"https:\/\/toggl.com\/blog\/google-sheets-schedule-planner#primaryimage"},"thumbnailUrl":"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2022\/06\/Blog-Header-Make-a-schedule-on-Google-Sheets_Blog-Header-1640x982-1.png","articleSection":["Resource Management"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/toggl.com\/blog\/google-sheets-schedule-planner","url":"https:\/\/toggl.com\/blog\/google-sheets-schedule-planner","name":"How To Make A Schedule In Google Sheets (With Free Templates)","isPartOf":{"@id":"https:\/\/toggl.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/toggl.com\/blog\/google-sheets-schedule-planner#primaryimage"},"image":{"@id":"https:\/\/toggl.com\/blog\/google-sheets-schedule-planner#primaryimage"},"thumbnailUrl":"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2022\/06\/Blog-Header-Make-a-schedule-on-Google-Sheets_Blog-Header-1640x982-1.png","datePublished":"2022-06-17T09:00:00+00:00","dateModified":"2024-06-15T07:41:33+00:00","description":"Learn step-by-step how to make a weekly & monthly schedule in Google Sheets using free templates to manage your schedule like a pro.","breadcrumb":{"@id":"https:\/\/toggl.com\/blog\/google-sheets-schedule-planner#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/toggl.com\/blog\/google-sheets-schedule-planner"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/toggl.com\/blog\/google-sheets-schedule-planner#primaryimage","url":"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2022\/06\/Blog-Header-Make-a-schedule-on-Google-Sheets_Blog-Header-1640x982-1.png","contentUrl":"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2022\/06\/Blog-Header-Make-a-schedule-on-Google-Sheets_Blog-Header-1640x982-1.png","width":2560,"height":1537,"caption":"Illustration of a woman writing something in a book that has Google Sheets logo as the cover"},{"@type":"BreadcrumbList","@id":"https:\/\/toggl.com\/blog\/google-sheets-schedule-planner#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/toggl.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How To Make A Schedule In Google Sheets (With Free Templates)"}]},{"@type":"WebSite","@id":"https:\/\/toggl.com\/blog\/#website","url":"https:\/\/toggl.com\/blog\/","name":"Toggl Blog","description":"Everything works much better with Toggl","publisher":{"@id":"https:\/\/toggl.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/toggl.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/toggl.com\/blog\/#organization","name":"Toggl","url":"https:\/\/toggl.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/toggl.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2022\/10\/toggl-logo.png","contentUrl":"https:\/\/toggl.com\/blog\/wp-content\/uploads\/2022\/10\/toggl-logo.png","width":814,"height":814,"caption":"Toggl"},"image":{"@id":"https:\/\/toggl.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/Toggl\/","https:\/\/x.com\/toggl","https:\/\/www.instagram.com\/usetoggl\/","https:\/\/www.linkedin.com\/company\/toggl"]},{"@type":"Person","@id":"https:\/\/toggl.com\/blog\/#\/schema\/person\/1f14ae0cadc59db374eaaf4c8de016e6","name":"Jitesh Patil","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/18c6b101c496f4ed723c0e9716f9344068d223a5ae60030e45f79cfc521e7477?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/18c6b101c496f4ed723c0e9716f9344068d223a5ae60030e45f79cfc521e7477?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/18c6b101c496f4ed723c0e9716f9344068d223a5ae60030e45f79cfc521e7477?s=96&d=mm&r=g","caption":"Jitesh Patil"},"description":"Jitesh is an SEO and content specialist. He manages content projects at Toggl and loves sharing actionable tips to deliver projects profitably.","sameAs":["https:\/\/toggl.com","https:\/\/www.linkedin.com\/in\/jiteshpatil\/"],"url":"https:\/\/toggl.com\/blog\/author\/jitesh-patil"}]}},"_links":{"self":[{"href":"https:\/\/toggl.com\/blog\/wp-json\/wp\/v2\/posts\/30360","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/toggl.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/toggl.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/toggl.com\/blog\/wp-json\/wp\/v2\/users\/607"}],"replies":[{"embeddable":true,"href":"https:\/\/toggl.com\/blog\/wp-json\/wp\/v2\/comments?post=30360"}],"version-history":[{"count":17,"href":"https:\/\/toggl.com\/blog\/wp-json\/wp\/v2\/posts\/30360\/revisions"}],"predecessor-version":[{"id":32671,"href":"https:\/\/toggl.com\/blog\/wp-json\/wp\/v2\/posts\/30360\/revisions\/32671"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/toggl.com\/blog\/wp-json\/wp\/v2\/media\/31905"}],"wp:attachment":[{"href":"https:\/\/toggl.com\/blog\/wp-json\/wp\/v2\/media?parent=30360"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/toggl.com\/blog\/wp-json\/wp\/v2\/categories?post=30360"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/toggl.com\/blog\/wp-json\/wp\/v2\/tags?post=30360"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}