Google Sheets calendar templates
Six free calendars for Google Sheets, each one its own file. Type the year (or the month, or the day) at the top and the dates, weekdays and layout redraw themselves. Also for Excel.
Monthly calendar · Yearly calendar · Social media calendar · Content calendar · Daily schedule · Marketing calendar. Free to use, no sign-up needed.
A Google Sheets calendar template gives you a calendar you can shape however you like: plan a month, map out the year, schedule social posts, run a content calendar or block out a single day. Unlike a calendar app, a spreadsheet lets you add the columns you need (owners, statuses, budgets, notes) and share it with anyone.
The six calendars above are free, with no sign-up. Each one is its own file: click Open in Google Sheets to save a copy to your Google Drive, or download it for Excel. Every calendar redraws itself from the year, month or date at the top, so you can use it again next year without rebuilding anything.
Which calendar template do you need?
| Calendar | Best for | Layout |
|---|---|---|
| Monthly calendar | Planning days and events, on a computer or a phone | 12 tabs, one row per day |
| Yearly calendar | Seeing the whole year, holidays and deadlines at a glance; printing | 12 month grids on one page |
| Social media calendar | Planning posts across platforms | Weeks across, platforms down, plus a list of posts |
| Content calendar | Blogs, newsletters, videos and their deadlines | A list of pieces with statuses and an overview |
| Daily schedule | Time-blocking a single day | Time slots, priorities and a to-do list |
| Marketing calendar | Campaigns, launches and promotions across the year | A timeline of months with budgets and key dates |
How to use these Google Sheets calendar templates
- Open your copy. Click Open in Google Sheets on the calendar you want and choose Make a copy. It is saved to your own Google Drive, and nobody else can see it until you share it. (Or download it for Excel.)
- Set the date at the top. Each calendar shows the current year (or month, or day) until you type another. Everything else redraws to match: dates, weekdays, month layouts and highlights.
- Replace the examples. The marketing, content and social media calendars come with a few example rows so you can see how they work. Overwrite or delete them.
- Use the dropdowns. Statuses, types and platforms are chosen from lists, which keeps the colors and counts working. Change the lists to suit you.
- Read the How to use tab. Every file has one, with the details for that calendar.
Today's date is highlighted in yellow on every calendar, so you can always see where you are.
Google Sheets monthly calendar template
The monthly calendar has a tab for each month and a row for each day, with the weekday beside the date. Write plans, tasks or events in the row, add a time and notes, and choose Yes under Done to cross something off. Weekends are shaded.
Why a list rather than a grid? A row per day leaves room to write properly, and it is far easier to use in the Google Sheets app on a phone, where a seven-column grid means scrolling sideways. Type a new year on the Start here tab and all twelve months update.
Google Sheets yearly calendar template
The yearly calendar shows all twelve months on one page, with weeks starting on Monday. Next to it is a Key dates list: add a date, a name and a type (Holiday, Deadline or Event), and the date is colored on the calendar in that type's color. It prints on a single landscape page, which makes it a good wall planner.
Tip: enter dates that repeat every year as formulas, such as =DATE($B$4,12,25) for Christmas Day. They move with the year, so next year's calendar is ready the moment you change the year.
Social media calendar template for Google Sheets
Choose a year and month and the calendar shows each week of that month, Monday to Sunday, with a row for each platform: Instagram, Facebook, LinkedIn, TikTok, X, YouTube and Pinterest. Rename them to the ones you use. Write a short description of each post in the day and platform it goes out on, and you can see the whole month's mix at a glance.
The Posts tab holds the detail for each post: the date, platform, format, full caption, the image or video, the owner, the status (Idea, Drafting, In review, Scheduled, Published), the link once it is live, and a note on how it did. Each status has its own color, so it is easy to see what still needs work.
Content calendar template
The content calendar is for anything you publish: blog posts, guides, videos, newsletters, case studies. Each piece has a publish date, title, topic, format, main keyword, author and a date the draft is due, plus a status that moves from Idea to Brief, Drafting, In review, Scheduled and Published.
Beside the list, a timeline draws each piece across six months of days, from when work starts to publish day: purple while it is being written, amber for review and design, and a dark mark on the day it goes out. Two things keep it honest. A draft due date that has passed turns red until the piece reaches review, so stalled drafts are obvious. And the Overview tab counts how many pieces are at each stage and how many are planned for each month, so gaps in the schedule show up before they become missed weeks. For a full guide with examples, see our content calendar template page.
Google Sheets daily schedule template
The daily schedule is for time-blocking: giving each part of your day a job. Set when your day starts and how long each block is (30 minutes by default; try 60 for a lighter plan or 15 for detail), then fill in the blocks. Write your top three priorities first and give them the best blocks. The block you are in right now is highlighted, and there is a to-do list and space for notes beside the schedule.
To plan a week, duplicate the tab (right-click it and choose Duplicate) and change the date at the top of each copy. Our productivity tips cover time-blocking and the other habits that make a schedule work.
Marketing calendar template
The marketing calendar is the big picture: one row for each campaign, launch or promotion, with its channel, owner, start and end dates, budget, status and goal. The twelve month columns fill in for every month a campaign runs, colored by status (purple when planned, amber when live, green when done), so the whole year's activity reads like a timeline. The current month is shaded, and the budget totals at the bottom.
The Key dates tab lists common US marketing and retail dates for the year, including the ones that move every year: Mother's Day, Memorial Day, Father's Day, Labor Day, Thanksgiving, Black Friday, Small Business Saturday, Cyber Monday and Giving Tuesday are all worked out from the year automatically. Add your own industry's dates below them.
Use the marketing calendar for the plan, and the content and social media calendars for the individual pieces that make each campaign happen.
How to make a calendar in Google Sheets
If you would rather build your own, here is how to make a monthly calendar grid in Google Sheets that updates when you change the month.
- In cell A1, type the first day of the month, such as
1/10/2026or10/1/2026depending on your region, and format it as Format > Number > Custom date and time > *Month Year* so it reads October 2026. - In row 2, type the days of the week across seven columns, from Mon to Sun.
- In cell A3, enter
=SEQUENCE(6,7,A1-WEEKDAY(A1,2)+1). This fills a six-week grid with dates, starting on the Monday on or before the first of the month. - Select the grid (A3:G8) and format it as Format > Number > Custom date and time, choosing just the day number, so each cell shows 1, 2, 3.
- To fade the days that belong to the previous or next month, select the grid, choose Format > Conditional formatting, pick Custom formula is, and enter
=MONTH(A3)<>MONTH($A$1)with a light grey text color. - To highlight today, add a second rule with
=A3=TODAY()and a yellow fill. - Change the date in A1 to any other month and the whole grid redraws.
To build a list-style calendar instead, put the first date of the month in A2 and =A2+1 below it, add =TEXT(A2,"dddd") in the next column for the weekday, and leave the remaining columns for your plans.
| Formula | What it does |
|---|---|
=DATE(2026,10,1) | Makes a date from a year, month and day |
=EOMONTH(A1,0) | The last day of A1’s month |
=WEEKDAY(A1,2) | The day of the week as a number, Monday = 1 to Sunday = 7 |
=TEXT(A1,"dddd") | The name of the day, such as Wednesday |
=SEQUENCE(6,7,start) | A 6-by-7 grid of dates counting up from a start date |
=WORKDAY(A1,5) | The date five working days later, skipping weekends |
=TODAY() | Today’s date, updated every day |
Two Google Sheets features are worth knowing: Insert > Checkbox turns cells into tick boxes (handy for a Done column), and Insert > Dropdown creates a list to choose from, such as statuses or platforms.
Google Sheets or Google Calendar?
| Google Sheets calendar | Google Calendar | |
|---|---|---|
| Best for | Plans with extra details: owners, statuses, budgets, notes | Meetings and appointments at a set time |
| Reminders | No | Yes, by notification and email |
| Invites guests | No | Yes |
| Custom columns and totals | Yes, any you like | No |
| Printing a year or month | Easy, with your own layout | Limited |
| Sharing and editing together | Yes | Yes |
Many people use both: Google Calendar for appointments, and a Google Sheets calendar for planning work such as content, campaigns and projects, where the details matter more than the time of day.
How to print a calendar from Google Sheets
- Open the tab you want to print and choose File > Print.
- Under Paper size, choose your paper; under Page orientation, choose Landscape for the yearly and marketing calendars and Portrait for the monthly and daily ones.
- Under Scale, choose Fit to width (or Fit to page for the yearly calendar).
- Under Formatting, untick Show gridlines for a cleaner page.
- Click Next and print, or save as a PDF.
How to share a calendar in Google Sheets
Click Share at the top right and add people by email. Choose Viewer for people who only need to see it, Commenter for people who should suggest changes, and Editor for people who update it. To stop the formulas being overwritten by accident, select the cells with formulas and choose Data > Protect sheets and ranges.
Tips for a calendar people actually use
- Keep one calendar per purpose. A marketing plan, a content schedule and a team's holidays are easier to manage apart than in one crowded sheet.
- Give every item an owner. A calendar entry with no owner is a wish, not a plan.
- Use statuses and colors consistently, so anyone can read the calendar at a glance.
- Review it weekly. Ten minutes on a Friday to update statuses and look at next week keeps the calendar true.
- Plan around fixed dates first, such as holidays, launches and deadlines, and fill in the rest around them.
When to move beyond a spreadsheet calendar
A spreadsheet calendar is ideal for planning. It is weaker at the day-to-day: it cannot remind anyone, hand work from one person to the next, or show tasks and meetings together. When several people work from the same calendar, a planning tool helps.
In Coavon, Flow runs content and marketing calendars as projects, with an owner, a due date and a status for every piece, recurring tasks for the work that repeats, and automations for hand-offs such as sending a draft to the editor. Coavon's Calendar shows events and Flow tasks side by side, so the plan and the meetings live in one view.
Frequently asked questions
Does Google Sheets have a calendar template?
Google Sheets includes an annual calendar in its template gallery (File > New > From template gallery). For more choice, the six free templates on this page cover monthly, yearly, social media, content, daily schedule and marketing calendars, and each one updates when you change the year.
How do I make a calendar in Google Sheets?
Type the first day of the month in a cell, add the days of the week in the row below, and use =SEQUENCE(6,7,A1-WEEKDAY(A1,2)+1) to fill a six-week grid of dates. Format the grid to show only the day number, and use conditional formatting to fade other months and highlight today.
How do I copy a calendar template into my Google account?
Click Open in Google Sheets on the calendar you want. Google asks whether to make a copy; click Make a copy and it is saved to your own Google Drive. If you are not signed in to Google, it asks you to sign in first.
Do these calendars update for next year?
Yes. Each calendar shows the current year until you type another at the top, and the dates, weekdays and month layouts redraw. On the marketing calendar, holidays that move each year, such as Thanksgiving and Black Friday, are worked out automatically.
Can I use these calendar templates in Excel?
Yes. Each calendar has an Excel download with the same layout, formulas and colors. They also open in Numbers.
Can I sync a Google Sheets calendar with Google Calendar?
Not directly. Google Sheets and Google Calendar do not sync on their own; it takes an add-on or a script. Many people keep appointments in Google Calendar and planning in a spreadsheet.
What is the difference between a content calendar and a social media calendar?
A content calendar tracks pieces you create and publish, such as articles, videos and newsletters, with authors, deadlines and statuses. A social media calendar plans what goes out on each platform each day. Many teams use both, with the social calendar promoting what the content calendar produces.
How do I print a calendar from Google Sheets?
Choose File > Print, pick landscape or portrait to suit the calendar, set the scale to Fit to width or Fit to page, untick Show gridlines under Formatting, then print or save as a PDF.