skip to Main Content

Content Calendar Template

4.4 (5 reviews)

Actively plan and manage your editorial content calendar in Excel! With this template be on top of your plan without worrying about deadlines.

Learn more about License Types


Someka refunds icon

30-Days
Return

Someka one time payment icon

One-Time
Payment

Someka direct download icon

Instant
Download

TEMPLATE DESCRIPTION

Are you a freelance content creator or an in-house marketing professional actively creating or managing content? Then by now you probably know a well-organized content marketing strategy is a must in today’s business sphere. If you would like to exist in the digital world, content marketing is vital and so as a well-planned editorial content calendar! You have to regularly share numerous materials with your audience to get their attention such as social media posts or blogs. On the other hand, to keep this attention continuously, it is important to follow a strategic timeline across multiple channels.Content-Calendar-Template-Someka-S09

Our Content Calendar Template will help you keep your content marketing development and activation plan organized and efficient. With this spreadsheet, you will have your content schedule across various platforms and channels in one place altogether. You and/or your team will know exactly what to do and when to do so.

How to use Content Calendar Template?

Our spreadsheet has two pillars to track your content development and publishing plan. These are inputs and outputs.

Inputs:

Settings:

Firstly, you need to define your content types, stages, and editors that you are working with. You can specify the Calendar Year from this section. After that, the template will update the calendar sheet ( days and months ) according to your calendar year selection.

Content-Type-Editors-Settings-Someka-S01

Schedule Standard Task:

This section will help you define repeating tasks and assign them to a specific editor. You can select the content type and the responsible person (optional) from the dropdown button. The available input for both cases will be based on your previous selection in the settings sheet. The table will allow you to set the repetition frequency of each task whether monthly or weekly.

Schedule-Standard-Task-Someka-S02

Besides that, you can also set a custom duration per task. In that way, you can determine the start and end date of each task and set the expected total working days. Please enter the “X” sign manually to set the days the editor will work on that specific task.

Custom-Duration-Per-Task-Someka-S04

Note! If you would like to create a schedule that spreads across several years, for example from June 2020 to April 2021, you will be able to view only the schedule for the previously chosen calendar year in the setting section.

The scheduler allows you to create up to 100 different schedules.

Add Custom Task:

You can set personal targets or tasks for each editor in this section. In addition, you can input target keywords to be used in the campaign and track the current stage of the specific ongoing tasks.

This section can be used as a reminder as well via using the current stage column actively.

Add-Custom-Task-Someka-S05

Outputs:

Once you finished filling in the necessary information in the input areas of the content calendar template, you will be able to move forward with the output sections to see and check all the schedules, summary charts, task lists, etc.

Calendar:

This calendar view will be the most useful one if you would like to track your overall monthly schedule. You will be able to simultaneously view the responsible editor, task name, and the status of the work in the calendar.

Note that, you can view up to 3 tasks per day in the calendar view.

Content-Calendar-Template-Someka-S10

You can filter the calendar according to month, editor name, and task source separately by using dropdown buttons on the top. Task source options, in this case, would be the automatic Schedule and the individual Tasks or both.

Summary:

In this Content Calendar Template summary section, there are three available charts which are Monthly Tasks Number, Tasks by Channel, and Tasks by Editor. You can filter the charts based on the month, editor, and task source.

Summary-Charts-Someka-S07

Tasks List View:

This list is for getting a broad picture of all previously defined tasks ( custom and schedule ). You can also filter it by month selection. Besides, each column has its own sorting and filter options as well. Please do not try to change anything on this list. It’s an informative summary list showing the tasks you have created before.

Editorial-Task-List-View-Someka-S08

Content Calendar Template Features Summary:

  • Schedule your editorial content in Excel
  • Prepare a content planner for your social media and blog posts
  • Informational notes included
  • No installation needed. Ready to use
  • Works both on Mac and Windows
  • Compatible with Excel 2010 and later versions
  • Does not include any VBA code or macros

This Content Calendar Template is ready-to-use Excel Template and provided as-is. If you need customization on your reports or need more complex templates, please refer to our custom services.

PRODUCT VIDEO

Watch the video below to see the template in action! Presentantation also includes usage notes, explanations and tips & tricks about the template.

FREQUENTLY ASKED QUESTIONS

USER REVIEWS & COMMENTS

5 reviews for Content Calendar Template

  1. Oladapo

    Thanks and another questions:
    Does it automatically create the months in the year?

    • Someka

      Hi again, you do not have to change anything on the Calendar sheet as the calendar is totally dynamic. Just select your desired year/month from the Calendar filters (dropdowns) and the template will adjust output automatically.

  2. Serey

    Very useful thank for your effort. Keep going. My only comment is develop UI

    • Someka

      Hi Serey,
      Thank you very much for your comment.
      Your feedback is very valuable for us. We keep trying our best to produce more and more useful templates for our customers.
      For any questions, please do not hesitate to contact us at contact@someka.net.

  3. Oladapo

    Can I please ask how do you add a new year to the content calendar?

    • Someka

      Hi Oladapo, our Content Calendar Template is totally dynamic. On the Settings section just write down the year you want to see on the Calendar:

      content_calendar_excel_template_settings

      Now the months on the calendar will populate accordingly!

  4. Jenny Hand

    I’m working with the content calendar and I’ve input several tasks, however nothing is showing up on the calendar. I want to use the product ASAP can you help?

    • Someka

      Could you please initially check your data input format? Please, if you copy and paste any data, always use “Paste Special” option. (“Ctrl”” and “V” keys and select “Values”).

      If this does not solve your problem please send your file to us at contact@someka.net so we can solve the case as quick as possible.

    • Jenny Hand

      Fabulous, thank you so much!!

  5. Mikael Giunta

    thanks. nice free template for content creators working on Excel, otherwise there are other paid software options too

Leave a customer review

Only verified users who have downloaded and used the template may leave a review.

RELATED EXCEL TEMPLATES