Home Marketing How (Easy) to Create the Perfect Content Calendar in Google Sheets

How (Easy) to Create the Perfect Content Calendar in Google Sheets


If you’re like me, you can use them for data collection, campaign tracking or analyzing the blog post, or keep track of weekly exercises.

And more specifically, have you ever thought of using Google Sheets to create a functional calendar?

If you typically work on campaigns for a number of different customers, creating individual calendars in Google Sheets can be useful only to ensure customers understand when certain assets will appear. Alternatively, perhaps you need to create an internal Google Sheets calendar for your team to keep track of upcoming projects.

Creating a calendar in a commonly used tool for spreadsheets sounds a bit intimidating, but don’t worry, the process is actually quite intuitive. And with the help of some tips, you can easily create a functional calendar with which you can synchronize your schedule.

Below, we’ll look at how to create a calendar in Google Sheets and include some tips that will help you improve the design. In the end, your calendar should look like this:

Google Sheets Calendar from January to May

So start a new spreadsheet and get ready to create your own calendar. 📅

1. Open a new workbook and select your month.

First, let’s open one New spreadsheet. Then delete the H – Z columns. They won’t be needed.

Then choose your month. For this example I decided to do it January 2021, so I filled that in the first box. The great thing about Google Sheets is that it automatically recognizes the date, so entering a month, then the year in YYYY format will tell Google that you’ll be working with the date.

2. Start formatting of your calendar.

Next, format your calendar. I selected the text, January 2021, in Column A, Row 1. I have highlighted seven columns (AG) and clicked Unify to make the cell span the entire column. You can find this button to the right of the Fill tool.

January title format in Google Sheets calendar

Here, I also center my text using the tool next to Merge. Then I increased the font size and bolded the month.

3. Use the formula to fill in the days of the week.

Next, enter the days of the week in each column (AG). You can do this manually but I decided to use a formula. Sheets has a function that allows you to enter a formula to complete several actions at the same time.

To enter the days of the week, in the cell where you want to be the first day of the week, type: = TEXT (1, “DDDD”). This tells Google that your number will be replaced with a date or time, and the format you’re using is the day of the week.

Enter the formula of day of the week in the Google Sheets calendar

Highlight the number 1 in the formula and replace it with: COLUMN(). Then press enter and choose your first date. You will copy the formula in Sunday’s cell by dragging the selector to the end of the row, (AG) and pressing enter again.

Fill in the days of the week in the Google Sheets calendar

Pressing enter will automatically fill in the rest of the week. Remember, if this doesn’t work for you, you can always enter the date manually.

Pressing enter will automatically fill in the rest of the week. Remember, if this doesn’t work for you, you can always enter the date manually.

4. Fill in the numbers.

Clever! You have weekdays. Now we will fill numeric values. Before this step, I took the time to add daily color and change the font to a font that I prefer a bit more.

For numeric values, we only need to specify the first day of the month and click and drag to fill in the rest.

How?

Place the number 1 in the box just below the first day of the month, click and drag horizontally.

Fill in the number of days in the Google Sheets calendar

5. Fill in the remaining numbers.

Note: In this step, I’ve populated the calendar numbers in each other row to help with formatting later.

Now that you’ve filled in your first row, it’s time to fill in the rest. Manually insert the next number under “Sunday”, then click and drag horizontally to fill the rest.

Fill in the remaining numbers in your Google Sheets calendar

Repeat the process for the next rows. You will manually insert the first number, click and drag down the row. Here’s what will look like for the next row in January.

Fill in the row for the next number of days in the Google Sheets calendar

Note: Make sure the month ends with the correct number! For January, that would be the 31st.

6. Format your calendar as needed.

Everything is starting to look like a calendar, right? At this stage, I reformatted everything to clean up my calendar look a bit.

Remember the extra rows in between the numbered rows? I’ve expanded those rows to create boxes below the numbers. To do this, I just drag the rows down to make those cells bigger. Expand cells in the Google Sheets calendar

Here are some additional formatting tips:

  • Select the empty rows below your numbers and center them Use the text center tool.
  • Choose your entire calendar and vertically aligned all elements such that they are between their cells. To do this, use a vertical alignment tool.
  • brave your number of days.
  • If you want, Light shade your numbered rows.
  • If you want, Gray out Saturday and Sunday columns to make your working days stand out.

7. Add design elements to professionalize the look.

Finally, you can add some fun design elements to personalize your calendar look and feel. If it’s for the client or upcoming project, you’ll want to incorporate the necessary launch dates here.

Completed Google Sheets Calendar

For this step I added a couple of fun visuals, including a couple of mock calendar events, and playing with the font size.

8. Repeat the process from February to December.

It’s time to repeat February through December. Just copy your January calendar after you’ve designed the calendar the way you want. To do this, right-click on the tab of the sheet and select Copy from the menu.

Duplicate tab option in Google Sheets To fill in numbers, you just need to know the start date, then click and drag to fill in the remaining rows. Here are the first dates of each month for 2021:

  • January: Friday
  • February: Monday
  • March: Monday
  • April: Thursday
  • may: Saturday
  • June: Tuesday
  • July: Thursday
  • August: Sunday
  • September: Wednesday
  • October: Friday
  • November: Monday
  • December: Wednesday

Next, you will want to know how many days you need to fill in. Here are the number of days you need for each month:

  • January: thirty first
  • February: 28 or 29
  • March: thirty first
  • April: 30
  • may: thirty first
  • June: 30
  • July: thirty first
  • August: thirty first
  • September: 30
  • October: thirty first
  • November: 30
  • December: thirty first

And then you’re done!

It’s handy to use Sheets because you can open your calendar right from your browser. You can also keep track of your schedule in one place separate from your phone.

In addition, you can create important business documents such as social calendars and editorial calendars. Below, I share a perfect sample for the task.

Google Sheets calendar template

Here is the editor calendar template for all your editorial planning needs. This template helps you come up with an effective daily editing strategy.

Featured resources: Free editor calendar template

Free editor calendar template

Download free templates

Use the Google Sheets Calendar to organize your work

If you’re using Sheets and want to give it a try, create a Google Sheets calendar. It’s a great option if you need to create a clean calendar to track internal marketing campaigns, organize upcoming client projects, or share event calendars with key stakeholders. But if you don’t want to create a calendar from scratch, use our editorial calendar template to start your planning and organization efforts right away.

Editors’ note: This post was originally published May 2020 and has been updated for inclusion.

editorial calendar

RELATED ARTICLES

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Most Popular

Recent Comments