Friday, May 24, 2024

How one can Create an Editorial Calendar [+Free Templates]

Must read

Whether or not managing hundreds of weblog posts or just a few dozen articles, having an editorial calendar is crucial to maintain observe of all of it.

The excellent news is there are lots of nice calendar instruments on the market you possibly can select from. In actual fact, for these of you who’re HubSpot prospects, 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 embrace options like repeat scheduling, syncing, and adjustable visibility so you possibly can collaborate successfully together with your staff. Are you intrigued but?

Right here’s learn how to arrange your editorial calendar utilizing Google Calendar, spreadsheets, or challenge administration software program.

Comply with Alongside With These Free Editorial Calendar Templates

Obtain the Template for Free

How one can Create an Editorial Calendar

We’ll evaluate what it’s best to 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 incessantly, there are just a few greatest practices to recollect.

Begin by asking your self:

  • What forms of content material is my viewers occupied with?
  • The place does my viewers hang around on-line?
  • What forms of content material is my competitors utilizing, and the way incessantly do they submit?
  • How usually can I decide to writing blogs and creating content material?

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

Select Your Platforms

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

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

Nevertheless, by establishing the place you need a presence early within the editorial calendar creation course of, you possibly can streamline your efforts higher.

Decide Content material Tips and Frequency

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

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

Nevertheless, the extra usually you possibly can create top-notch content material that engages your viewers, the extra doubtless you’ll keep high of thoughts.

Now can also be a wonderful time to find out what content material you’ll share. Whereas this could change as you go should you can consider big-picture classes and your content material objectives, that may assist you to decide your frequency.

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

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

You possibly can create and flesh out your editorial calendar utilizing the above instance extra simply.

Select an Editorial Calendar Platform

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

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

  • Publication date so you realize when the submit will go dwell
  • Due date so you realize when you have to end the draft
  • Name-to-action (CTA) so you realize what you’re constructing in the direction of
  • Matter/Title so you realize what the article is about
  • Key phrases (if relevant), so you realize what phrases to make use of
  • Hyperlinks to the ultimate revealed content material for straightforward reference later
  • Every other info that’s helpful for you or your staff

How one can Create an Editorial Calendar in Google Calendar

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

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

Obtain Now

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

Right here we’ll go over learn how 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 will probably be stamped for a earlier 12 months.

Now is a superb time to alter them to the present 12 months within the spreadsheet. It’s also possible to decide posting cadence now or regulate 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 simple. This consists of 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 emblem.

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 learn how 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 ensure you’re already logged into the Gmail account you need this calendar to present 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 beneath.

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 screen. This features a transient description of your calendar, as proven beneath, to present folks correct context if you invite them to your calendar.

Once you’re finished 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 laptop,” 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 beneath your imported file, click on the “Add to calendar” dropdown. You’ll want to select the calendar title you simply created from the dropdown menu, as proven beneath. 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.”

In the event 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. Nevertheless, should you change this to a distinct variety of posts every 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 title.

For instance, on the week of January 3, should you’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 on daily basis you will have an merchandise scheduled.

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

Step 9. Decide your publishing schedule.

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

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

You possibly can select to publish each Monday, Wednesday, and Friday. Or maybe you intend on posting simply on Thursdays. You will have adjusted this already, or you are able to do so now.

Both manner, bear 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 successful. How usually your organization ought to weblog will differ relying on your enterprise objectives and sources.

In the event 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 instances each day, updating this calendar is as simple 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. At present, 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.

In the event you chosen only one week of dates to add to Google Calendar (not three hundred and sixty five days), you can also make these recurring occasions in your calendar.

When you’ve got an everyday publishing schedule, say each Monday, Wednesday, and Friday at 10:00 a.m., you possibly can put that in as a recurring “slot” in your calendar.

It’s okay should you don’t have a bit of accomplished content material or a working title to place there but. It’s only a reminder that you just 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 submit, the place you possibly can create a customized recurring schedule for every project, as proven within the screenshot beneath.

You possibly can set the submit up as recurring, so it robotically seems each Monday, Wednesday, and Friday at 10:00 a.m. (or no matter days and instances you need).

When you’ve chosen the recurring days, hit “Completed” 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 further particulars you need to be certain you embrace for every submit.

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

In the event you don’t have a recurring schedule like this, you won’t want an editorial calendar simply but — however it is a wonderful strategy to set objectives for your self.

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

Step 11. Fill in your publishing slots.

Now that you realize all of the slots you need to fill, you’ve received to fill them. (If you do not have matter concepts but, take a look at this free matter thought generator. It’ll provide you with 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 Details About Tapirs,” and one of many posts you’ve already written and need to publish later is “Assume You are Minimize Out to Personal a Tapir? Learn This First.”

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

Let‘s say you don’t need to write “10 Stunning Details About Tapirs,” and also you need your colleague to put in writing it as an alternative.

To assign the submit to an creator, 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 submit by typing their title or electronic mail handle into the “Add friends” field. Choose “Add” when their title pops up and hit “Save” on the occasion when you’re finished.

Now, anybody can see who’s liable for writing the submit.

You possibly can take it a step additional by including particulars to the “Description” field of the occasion, as proven within the giant field within the screenshot above.

You would possibly embrace a fast synopsis, the key phrases you intend to focus on the submit for, the audience you‘re making an attempt to achieve, and the provide or CTA you’ll direct the reader to on the finish of the submit. Don’t neglect so as to add the draft’s due date.

Earlier than Google Calendar allows you to save the occasion, you may 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 immediately and sooner or later.

Step 12. Share your editorial calendar with others.

Now that your calendar is ready up, you possibly can invite folks to see it. Let’s begin together with your instant staff, common contributors, and anybody who repeatedly asks you about publishing content material in your firm weblog.

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

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

Then, you possibly can add the names of individuals you’d prefer to share on the calendar and set the proper permission ranges for every invitee.

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

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

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

How one can Use Excel or Google Spreadsheets for Editorial Calendars

In the event you’re a spreadsheet superfan, Excel and Google Sheets are nice choices on 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 consists of hyperlinks to Google Sheets editorial calendar information and an Excel weblog editorial calendar template you possibly can adapt to your organization.

Google Sheets

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

This may robotically save to your Drive. From there, you possibly can adapt to your schedule/wants and share with staff members for straightforward collaboration.


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

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

How one can 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 possibly can 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.

You then’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 possibly can title your calendar “Editorial Calendar” and add occasions.

Step 3. Arrange your calendar.

Select a date and time on the calendar, title the occasion “Weblog Title,” “Electronic mail,” “Instagram Publish,” and so forth., and select how usually you need it to recur.

Then you possibly can go into every occasion and fill out particulars like Title, Content material Define, and every other info.

You possibly can then additionally share that calendar with different folks in your staff to allow them to plan accordingly.

How one can Use a Undertaking Administration Platform for Editorial Calendars

Undertaking administration instruments like Asana or ClickUp make nice editorial calendars as a result of you possibly can view the content material in a number of methods. Every merchandise is its card, permitting you to place as a lot info as potential.

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

Typically talking, you possibly can toggle between Record, Board, or Calendar views. It’s also possible to assign a wide range of duties and subtasks with totally different deadlines.

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

Record view provides you an easy manner to take a look at every thing in your plate, as on this ClickUp instance.

The Board view allows you to observe progress.

And the calendar view permits you to lay every thing out based mostly on the week or month.

No matter which choice you select, it’s a good suggestion to make sure your staff understands your content material calendar and learn how 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, should you use Gmail on your company electronic mail, everybody you’re employed with will already be in Gmail (and their calendar, particularly) all day.

Because of this, it received’t be onerous for folks to habitually verify the editorial calendar as a result of will probably be simple for them to search out it.

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

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

Lastly, this units a precedent for different groups to coordinate together with your staff straightforwardly. You possibly can have a calendar for upcoming campaigns, provides, social media pushes, product launches — you title it.

And you may all share these calendars for a single-screen view of every thing happening so you possibly can coordinate extra simply.

Whereas there are different options for sustaining an editorial calendar, should you’re on the lookout for a free, not-too-shabby, minimum-viable product, then Google Calendar is for you.

Create a Calendar As we speak

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

It is going to assist you to maintain observe of all of the shifting components: what content material you need to publish, when, and who’s liable for making it. Up your content material publishing with a calendar immediately!

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

marketing editorial calendar templates


Supply hyperlink

More articles


Please enter your comment!
Please enter your name here

Latest article