How to (Easily) Make Perfect Content Calendars in Google Sheets

For those who’re something like me, you possible use them to gather information, monitor marketing campaign or weblog publish analytics, or maintain monitor of weekly assignments.

And, extra particularly, have you ever ever thought of utilizing Google Sheets to make a purposeful calendar?

Free Download: Marketing Editorial Calendar Template

For those who typically work on campaigns for a number of completely different shoppers, creating particular person calendars in Google Sheets could possibly be uniquely helpful for making certain the consumer understands when sure content material will go stay. Alternatively, maybe you have to create an inner Google Sheet calendar on your staff to maintain monitor of upcoming tasks.

Making a calendar in a device that is generally used for spreadsheets sounds just a little intimidating, however don’t fret, the method is definitely fairly intuitive. And with the assistance of some ideas, you possibly can simply make a purposeful calendar you could sync your schedule with.

Beneath, we’ll go over the best way to make a calendar in Google Sheets and embrace some ideas that’ll aid you elevate the design. On the finish, your calendar will look one thing like this:

Google Sheets calendar January to May

So begin a brand new spreadsheet and prepare to create your very personal calendar. đź“…

1. Open a brand new spreadsheet and select your month.

First, open a new spreadsheet. Then, delete columns H — Z. They will not be wanted.

Then, select your month. For this instance, I made a decision to do January 2021, so I stuffed that into the primary cell. What’s nice about Google Sheets is that it robotically acknowledges dates, so typing in a month, adopted by the yr in YYYY format will inform Google that you’ll be working with dates.

2. Start to format your calendar.

Subsequent, format your calendar. I chosen the textual content, January 2021, in Column A, Row 1. I highlighted seven columns (A-G), and clicked Merge to make that cell span throughout the whole column. You’ll find this button to the suitable of the Fill device.

Formatting the January title in a Google Sheets calendar

Right here, I additionally center-aligned my textual content utilizing the device subsequent to Merge. Then, I elevated the font measurement and bolded the month.

3. Use a components to fill within the days of the week.

Subsequent, fill within the days of the week in every column (A-G). You are able to do this manually however I made a decision to make use of a components. Sheets has a perform that allows you to kind in formulation to finish sure actions directly.

To fill in days of the week, within the cell the place you need your first weekday to be, kind: =TEXT(1, “DDDD”). What this tells Google is that your quantity can be changed by a date or time and the format you are utilizing is weekdays.

Entering the weekday formula in a Google Sheets calendar

Spotlight the number one within the components and exchange it with: COLUMN(). Then, press enter and choose your first day. You are going to copy the components in Sunday’s cell by dragging the selector to the top of your row, (A-G), and urgent enter once more.

Filling in the weekdays in a Google Sheets calendar

Urgent enter ought to robotically fill in the remainder of the week. Keep in mind, if this does not be just right for you, you possibly can all the time fill within the days manually.

Urgent enter ought to robotically fill in the remainder of the week. Keep in mind, if this does not be just right for you, you possibly can all the time fill within the days manually.

4. Fill within the numbers.

Wonderful! You’ve got your days of the week. Now we will fill within the numerical values. Earlier than this step, I took the time so as to add colour to the times row and altered the font to at least one I appreciated just a little extra.

For the numerical values, we’ll merely determine the primary day of the month and click on and drag to fill in the remaining.


Place the number one on the field proper beneath the primary day of the month, the press and drag horizontally.

Filling in the day numbers in a Google Sheets calendar

5. Fill in the remainder of the numbers.

Be aware: On this step, I stuffed within the calendar numbers each different row to assist with my formatting later.

Now that you just’ve stuffed out your first row, it’s time to fill in the remaining. Manually insert the following quantity beneath “Sunday,” then click on and drag horizontally to fill in the remaining.

Filling in the rest of the numbers in a Google Sheets calendar

Repeat the method for the following rows. You’ll insert the primary quantity manually, the press and drag down the row. Right here’s what that appears like for the following row in January.

Filling in the next row of day numbers in a Google Sheets calendar

Be aware: Make sure that to finish the month on the suitable quantity! For January, that will be the thirty first.

6. Reformat your calendar if mandatory.

The whole lot is beginning to seem like a calendar, proper? At this stage, I reformatted issues to wash up the look of my calendar just a little.

Keep in mind these further rows in between the numbered rows? I expanded these rows to create bins beneath the numbers. To do that, I merely dragged the rows right down to make these cells greater. Expanding the cells in a Google Sheets calendar

Listed below are some extra formatting ideas:

  • Choose the empty rows beneath your numbers and middle them utilizing the middle textual content alignment device.
  • Choose your whole calendar and vertically align all components in order that they’re within the middle of their cells. To do that, use the vertical alignment device.
  • Daring your day numbers.
  • If desired, flippantly shade your numbered rows.
  • If desired, grey out the Saturday and Sunday columns in order that your workdays stand out.

7. Add design components to professionalize the look.

Lastly, you possibly can add in some enjoyable design components to personalize the appear and feel of your calendar. If it is for a consumer or upcoming undertaking, you may need to incorporate mandatory launch days right here.

Completed Google Sheets calendar

For this step, I added in a number of enjoyable photographs, included a number of hypothetical calendar occasions, and performed with font sizes.

8. Repeat the method from February to December.

It’s time to repeat for the month of February to December. Merely duplicate your January calendar when you’ve designed it the way you need it to look. To do that, proper click on the sheet’s tab and choose Duplicate from the menu.

Duplicate tab option in Google Sheets To fill within the numbers, you’ll solely must know the start day, then click on and drag to fill in the remainder of the rows. Listed below are the primary days for each month for the yr 2021:

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

Subsequent, you’ll need to know what number of days you’ll must fill in. Listed below are the variety of days you’ll want for every month:

  • January: 31
  • February: 28 or 29
  • March: 31
  • April: 30
  • Could: 31
  • June: 30
  • July: 31
  • August: 31
  • September: 30
  • October: 31
  • November: 30
  • December: 31

After which, you are executed!

It is useful to make use of Sheets as a result of you possibly can open your calendar proper in your browser. You can even maintain monitor of your schedule in a spot that is separate out of your telephone.

Alternatively, you possibly can create necessary enterprise paperwork equivalent to social and editorial calendars. Beneath, I share a template that’s excellent for the duty.

Google Sheets Calendar Template

Right here’s an editorial calendar template for your entire editorial planning wants. This template helps you lay out a powerful editorial technique each day.

Featured Useful resource: Free Editorial Calendar Templates

Free Editorial Calendar Template

Download the Free Templates

Use a Google Sheets Calendar to Arrange Your Duties

For those who’re useful with Sheets and need to give it a shot, create a Google Sheets calendar. It’s an amazing possibility if you have to create a clear calendar to trace an inner advertising and marketing marketing campaign, set up a consumer’s upcoming tasks, or share an occasion calendar with key stakeholders. However in the event you don’t need to create one from scratch, use our editorial calendar template to jumpstart your planning and group efforts instantly.

Editor’s notice: This publish was initially revealed in Could 2020 and has been up to date for comprehensiveness.

editorial calendar

About admin

Check Also

How to Create an Editorial Calendar in Google Calendar [Free Templates]

One of the frequent questions we get from aspiring and present inbound entrepreneurs is, “How …

Leave a Reply

Your email address will not be published. Required fields are marked *

%d bloggers like this: