Whether or not managing 1000’s of weblog posts or a couple of dozen articles, having an editorial calendar is crucial to maintain observe of all of it.

a woman looks at editorial calendar online

The excellent news is there are numerous nice calendar instruments on the market you’ll be able to select from. The truth is, for these of you who’re HubSpot clients, there’s a advertising and marketing calendar constructed proper into HubSpot’s software program.

However there are a number of glorious choices on the market. They embody options like repeat scheduling, syncing, and adjustable visibility so you’ll be able to collaborate successfully along with your crew. Are you intrigued but?

Right here’s the best way to arrange your editorial calendar utilizing Google Calendar, spreadsheets, or undertaking administration software program.

Observe Alongside With These Free Editorial Calendar Templates

Download the Template for Free

Tips on how to Create an Editorial Calendar

We’ll assessment what you should put into your editorial calendar. Whereas there’s no one-size-fits-all rule for figuring out what content material to create, the place to publish, and the way steadily, there are a couple of greatest practices to recollect.

Begin by asking your self:

  • What varieties of content material is my viewers focused on?
  • The place does my viewers hang around on-line?
  • What varieties of content material is my competitors utilizing, and the way steadily do they publish?
  • How typically can I decide to writing blogs and creating content material?

Whereas your solutions most likely gained’t offer you a black-and-white image of what it’s best to do, they’ll present primary tips for what is sensible to your viewers and your capability.

Select Your Platforms

Most companies select to publish content material on a weblog. Nonetheless, to get extra eyes on the content material, they repurpose it on numerous different channels, together with Fb, LinkedIn, Instagram, YouTube, e-mail, and TikTok.

Whilst you don’t have to point out up on all these platforms, you do want to choose those probably for use by your viewers. Furthermore, a few of your posts shall be higher suited to repurposing on completely different platforms.

Nonetheless, by establishing the place you desire a presence early within the editorial calendar creation course of, you’ll be able to streamline your efforts higher.

Decide Content material Tips and Frequency

After figuring out how steadily your competitors updates content material, it’s your flip to determine how typically you’ll publish. Typically talking, consistency and high quality trump frequency.

It’s higher to publish constantly 2-4 occasions a month than to publish 4 articles weekly after which abandon ship for a month or longer.

Nonetheless, the extra typically you’ll be able to create top-notch content material that engages your viewers, the extra possible you’ll keep prime of thoughts.

Now can be a superb time to find out what content material you’ll share. Whereas this will change as you go for those who can consider big-picture categories and your content material targets, that may show you how to decide your frequency.

For instance, right here’s a pattern publication define you can use to repurpose content material:

  • 1x week: Weblog (Tuesdays).
  • 2x week: E-mail (Tuesdays, Thursdays).
  • 2x week: Instagram, Fb, YouTube (Wednesdays, Fridays).

You’ll be able to create and flesh out your editorial calendar utilizing the above instance extra simply.

Select an Editorial Calendar Platform

Now that you’ve a tough thought of the content material you need to create, the place to publish it, and the way typically, it’s time to decide on and construct your editorial calendar platform.

The preferred choices are spreadsheets, on-line calendars, or undertaking administration instruments like Trello, Asana, or ClickUp. No matter which possibility you select, you’ll need to be certain you’re protecting observe of issues like:

  • Publication date so when the publish will go dwell
  • Due date so when you want to end the draft
  • Name-to-action (CTA) so what you’re constructing in the direction of
  • Matter/Title so what the article is about
  • Key phrases (if relevant), so what phrases to make use of
  • Hyperlinks to the ultimate revealed content material for simple reference later
  • Another info that’s priceless for you or your crew

Tips on how to Create an Editorial Calendar in Google Calendar

Now that we’ve lined the fundamentals, we’ll dive into some particular how-tos for numerous platforms, emphasizing Google Calendar. Most of the later steps could be utilized to the opposite calendar codecs.

Step 1. Download HubSpot’s free editorial calendar templates.

Download Now

First, obtain the calendar templates above (they’re free.) By doing this, you’ll have three editorial calendar templates in your pc: one for Google Calendar, one for Excel, and one for Google Sheets.

Right here we’ll go over the best way to add the Excel calendar into Google Calendar.

Step 2. Customise your template and put together it for import into Google Calendar.


The publish dates in your templates shall be stamped for a earlier yr.

Now is a superb time to alter them to the present yr within the spreadsheet. You can too decide posting cadence now or modify your posting schedule after importing the file into Google Calendar.

Google Calendar makes loading a calendar you may need pre-created in one other program into Google straightforward. This contains Microsoft Excel.

To import the weblog editorial calendar template into Google Calendar, you’ll have to take the next steps:

1. Delete the header row with the HubSpot brand.

2. Change the phrases “Publish Date” to “Begin Date.”

3. Change the wired “Matter/Title” to “Topic.”

4. Transfer the “Topic” column to be the primary column and the “Begin Date” column to be the second column “Due Date.”

5. Transfer the “Topic” column to be the primary column and the “Begin Date” column to be the second column “Due Date.”

6. Save the doc as a .csv file.

Subsequent, we’ll present you the best way to import the Excel calendar template you downloaded into Google Calendar.

Step 3. Open Google Calendar.

When you’ve downloaded (or created) a calendar that opens in Microsoft Excel, it’s time to open Google Calendar. Simply be sure to’re already logged into the Gmail account you need this calendar to provide entry to.

Click on the grey dots subsequent to your profile image, then click on “Calendar.”

Step 4. Use the left-hand dropdown menu to create a brand new calendar.

Subsequent, arrange your Google Calendar to accommodate the knowledge in your Excel spreadsheet. To do that, go into your Google Calendar and click on the plus signal to the proper of “Different Calendars,” as proven within the screenshot under.

Then, choose “Create new calendar ” within the dropdown menu.”

Step 5. Fill out the main points of your new calendar.

Fill out the fields that seem on the following display. This features a temporary description of your calendar, as proven under, to provide individuals correct context once you invite them to your calendar.

If you’re performed filling within the particulars, click on “Create calendar.”

Step 6. Import your XLS or CSV file from the identical dropdown menu.

Utilizing the identical dropdown menu you used to create your editorial calendar, you’ll now import the Excel .csv file itself into Google Calendar. Click on that plus signal and choose

Click on the add field that reads “Choose file out of your pc,” and find the file entitled “Weblog Editorial Calendar – Excel” that was included within the ZIP file you downloaded in Step 1 above.

Step 7. Choose which calendar so as to add this file to.

Within the second field under your imported file, click on the “Add to calendar” dropdown. Be sure you select the calendar identify you simply created from the dropdown menu, as proven under. Then, click on “Import.”

Step 8. Click on Import.

When you’ve uploaded your Excel file and chosen the calendar you need to add this file to, click on “Import.”

When you stored all of the occasions in your Excel file, it’s best to see an import calendar dialog field telling you that 365 occasions had been efficiently imported. Nonetheless, for those who change this to a special variety of posts per week, that quantity will differ.

Click on “OK.”

Navigate to the beginning of your calendar. Guarantee all of your different calendars are briefly hidden by clicking the coloured field to the left of the calendar identify.

For instance, on the week of January 3, for those who’ve typed in Weblog TBD in your Excel file, you’ll see a “Weblog TBD” calendar occasion on that date. In any other case, you’ll see “(no topic)” occasions each day you might have an merchandise scheduled.

Use the edit window of every task to alter the publish date. Every task will then seem as occasion blocks in your month-to-month calendar view.

Step 9. Decide your publishing schedule.

Now that you’ve your calendar created, it’s time to fill it in with assignments for the yr. That is when you could resolve about your weblog’s publishing schedule.

Whereas the Excel file you imported accounts for one weblog publish per day, this doesn’t imply you want to publish seven days per week.

You’ll be able to select to publish each Monday, Wednesday, and Friday. Or maybe you propose on posting simply on Thursdays. You might have adjusted this already, or you are able to do so now.

Both method, keep in mind: High quality over amount is the important thing to profitable running a blog.

Don’t overcommit to a running a blog schedule if the standard of your content material will take a success. How often your company should blog will fluctuate relying on your small business targets and assets.

When you resolve to lower the variety of days you need to publish, click on on the calendar occasion of that day and choose “Delete.”

Even if you wish to publish a number of occasions day by day, updating this calendar is as straightforward as including an occasion.

Choose a slot in your calendar so as to add one other “Weblog TBD” occasion and replica the default description from one other one of many occasions you imported.

Subsequent, it is time for some minor changes. Presently, the “Weblog TBD” occasions are set for 10 a.m. Be happy to maneuver these occasions to whichever time your weblog publishes content material in the course of the day.

Step 10. Arrange recurring occasions.

When you chosen only one week of dates to add to Google Calendar (not twelve months), you can also make these recurring occasions in your calendar.

If in case you have an everyday publishing schedule, say each Monday, Wednesday, and Friday at 10:00 a.m., you’ll be able to put that in as a recurring “slot” in your calendar.

It’s okay for those who don’t have a chunk of accomplished content material or a working title to place there but. It’s only a reminder that you simply need to publish one thing that day.

So as to add your recurring slot, click on in your first “Weblog TBD” occasion and click on the pencil icon to edit your occasion.

This may take you to the main points of the publish, the place you’ll be able to create a customized recurring schedule for every task, as proven within the screenshot under.

You’ll be able to set the publish up as recurring, so it mechanically seems each Monday, Wednesday, and Friday at 10:00 a.m. (or no matter days and occasions you need).

When you’ve chosen the recurring days, hit “Achieved” and “Save,” and also you’ll have an editorial calendar framework to work with.

For now, maintain the occasion’s title as “Weblog TBD,” however be happy to customise the outline with any additional particulars you need to be certain you embody for every publish.

Wait to ask any friends, as we’ll use this to assign posts to an writer as soon as you start filling in your subjects. With every part full, click on “Save.”

When you don’t have a recurring schedule like this, you won’t want an editorial calendar simply but — but it surely is a superb technique to set targets for your self.

For instance, if you need to publish a sure variety of posts every week, even for those who don’t hit each single slot, it’s reminder for your self and your crew that that is one thing it’s best to all attempt for.

Step 11. Fill in your publishing slots.

Now that all of the slots you need to fill, you’ve acquired to fill them. (If you do not have matter concepts but, check out this free topic idea generator. It’ll offer you some good concepts for content material to placed on the calendar.)

Let‘s say one of many posts you need to write is “10 Stunning Info About Tapirs,” and one of many posts you’ve already written and need to publish later is “Suppose You are Reduce Out to Personal a Tapir? Learn This First.”

Simply add them each to the calendar by clicking on “Put up – TBD” on the right date, selecting “Edit Occasion,” after which altering the “Put up – TBD” textual content to the precise title of the publish.

Let‘s say you don’t need to write “10 Stunning Info About Tapirs,” and also you need your colleague to jot down it as an alternative.

To assign the publish to an writer, you‘ll invite them to the occasion as friends. To do that, click on on the event, and hit “Edit Occasion.”

Then ask that colleague to the publish by typing their identify or e-mail handle into the “Add friends” field. Choose “Add” when their identify pops up and hit “Save” on the occasion when you’re performed.

Now, anybody can see who’s chargeable for writing the publish.

You’ll be able to take it a step additional by including particulars to the “Description” field of the occasion, as proven within the massive field within the screenshot above.

You would possibly embody a fast synopsis, the key phrases you propose to focus on the publish for, the audience you‘re attempting to succeed in, and the supply or CTA you’ll direct the reader to on the finish of the publish. Don’t overlook so as to add the draft’s due date.

Earlier than Google Calendar enables you to save the occasion, you will see a dialog field asking if you wish to change simply this occasion or all the occasions within the sequence. Choose “Solely this occasion.”

Repeat these steps to assign every weblog matter right this moment and sooner or later.

Step 12. Share your editorial calendar with others.

Now that your calendar is ready up, you’ll be able to invite individuals to see it. Let’s begin along with your rapid crew, common contributors, and anybody who often asks you about publishing content material in your firm weblog.

To share this calendar with individuals, merely discover your editorial calendar underneath “My Calendars,” as proven under. Click on the three dots subsequent to the calendar identify and choose “Settings and sharing” when it seems within the dropdown menu.

You may be taken to the identical display the place you first fill out the main points of your editorial calendar in Step 2.

Then, you’ll be able to add the names of individuals you’d wish to share on the calendar and set the right permission ranges for every invitee.

It‘s clever to maintain these with the permission settings to handle adjustments and sharing to a minimal so there are only some cooks within the kitchen. Nonetheless, let everybody see all occasion particulars so it’s clear precisely what content material goes up in every slot.

Underneath the “Share with particular individuals” heading, enter the e-mail addresses of these in your content material crew and resolve if they’ve viewing, enhancing, or admin privileges. Save your up to date settings.

And there, you might have your editorial calendar on Google Calendar!

Tips on how to Use Excel or Google Spreadsheets for Editorial Calendars

When you’re a spreadsheet superfan, Excel and Google Sheets are nice choices to your editorial calendar as a result of they permit on-line real-time collaboration.

The only option is whether or not your group makes use of Google Workspace or Microsoft Groups.

The editorial calendar template bundle you downloaded contains hyperlinks to Google Sheets editorial calendar information and an Excel weblog editorial calendar template you’ll be able to adapt to your organization.

Google Sheets

To make use of the Google Sheets possibility, open the hyperlink within the included pdf and choose “Make a Copy.”

This may mechanically save to your Drive. From there, you’ll be able to adapt to your schedule/wants and share with crew members for simple collaboration.


Save the Excel file to your Groups folder and share it with the suitable crew members.

No matter which spreadsheet you utilize, solely present “edit” entry to individuals who want it.

Tips on how to Use On-line Calendars for Editorial Calendars

Whether or not you’re utilizing Google Calendar, Outlook, or iCal to handle your private and work schedules, you’ll be able to simply use your on-line calendar as an editorial calendar.

Step 1. Create a brand new calendar.

Step one is to create a brand new calendar.

In Outlook, you’ll add a calendar.

Then you definitely’ll select “Create clean calendar.”

In Google Calendar, you’ll create a brand new calendar:

In iCal, you’ll create a brand new calendar and select iCloud:

Step 2. Rename your calendar.

No matter which app, you’ll be able to identify your calendar “Editorial Calendar” and add occasions.

Step 3. Arrange your calendar.

Select a date and time on the calendar, identify the occasion “Weblog Title,” “E-mail,” “Instagram Put up,” and many others., and select how typically you need it to recur.

Then you’ll be able to go into every occasion and fill out particulars like Title, Content material Define, and some other info.

You’ll be able to then additionally share that calendar with different individuals in your crew to allow them to plan accordingly.

Tips on how to Use a Venture Administration Platform for Editorial Calendars

Venture administration instruments like Asana or ClickUp make nice editorial calendars as a result of you’ll be able to view the content material in a number of methods. Every merchandise is its card, permitting you to place as a lot info as doable.

That features dates, hyperlinks, assignees, checklists, and customized fields.

Typically talking, you’ll be able to toggle between Record, Board, or Calendar views. You can too assign a wide range of duties and subtasks with completely different deadlines.

And since they’re often drag and drop, updating your editorial calendar as issues change is simple.

Record view offers you a simple method to take a look at every part in your plate, as on this ClickUp instance.

The Board view enables you to observe progress.

And the calendar view means that you can lay every part out primarily based on the week or month.

No matter which possibility you select, it’s a good suggestion to make sure your crew understands your content calendar and the best way to use it to maintain your course of shifting easily.

Why Utilizing Google Calendar as an Editorial Calendar Works

Whereas different options work for editorial calendars, we need to give an additional plug for Google Calendar as a result of it has spectacular options that will help you handle your editorial calendar.

For starters, for those who use Gmail to your company e-mail, everybody you’re employed with will already be in Gmail (and their calendar, particularly) all day.

Consequently, it gained’t be laborious for individuals to habitually verify the editorial calendar as a result of it is going to be straightforward for them to seek out it.

Google Calendar additionally makes issues straightforward to maneuver round and schedule. It has all of the performance you want to schedule and let the individuals who have to find out about it know.

Alongside these strains, permitting individuals to view your calendar is straightforward, making it straightforward for a number of groups to collaborate, see what’s being revealed, and work out once they would possibly launch content material and campaigns.

Lastly, this units a precedent for different groups to coordinate along with your crew straightforwardly. You’ll be able to have a calendar for upcoming campaigns, provides, social media pushes, product launches — you identify it.

And you’ll all share these calendars for a single-screen view of every part happening so you’ll be able to coordinate extra simply.

Whereas there are different options for maintaining an editorial calendar, for those who’re in search of a free, not-too-shabby, minimum-viable product, then Google Calendar is for you.

Create a Calendar At present

No matter you select — an internet calendar, undertaking administration software program, or a spreadsheet — having a well-organized and up-to-date editorial calendar is important to a profitable weblog.

It’s going to show you how to maintain observe of all of the shifting elements: what content material you need to publish, when, and who’s chargeable for making it. Up your content material publishing with a calendar right this moment!

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

marketing editorial calendar templates


Lascia un commento

Il tuo indirizzo email non sarà pubblicato. I campi obbligatori sono contrassegnati *