skip to Main Content

Content Calendar Excel Template

4.63 (8 reviews)

Social media content planner in Excel. Manage your editorial calendar. No more worries about deadlines. No installation needed. Ready to use.

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 trying to get organized with all those social media posts? Do you feel the pressure of missing the deadlines? Then, our Content Calendar Excel Template will help you to actively plan and manage your editorial contents. Additionally, you’ll track the entire social medial channels in all-in-one tool. Content-Calendar-Template-Someka-S09

Our Content Calendar Excel 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.

Content Calendar Excel Template Main Features

Basically, 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 the 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

Note: If you want this template in Google Sheets, you can download our Content Calendar Google Sheets Template.

Content Calendar Excel 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

Content Calendar Template is a 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! Presentation also includes usage notes, explanations and tips & tricks about the template.

FREQUENTLY ASKED QUESTIONS

USER REVIEWS & COMMENTS

8 reviews for Content Calendar Excel Template

  1. Barbra

    like the fact there is content type color option in settings and it is in calender with those colors. thx

  2. Gorden R

    useful to see the content together with responsible and stage in calender

  3. Celeste

    Nice Calendar!! I want to my team can see and use my templateç Please help

    • Someka

      Hello Celeste,

      If you have already purchased the Multi-User Licenced, you can upload it to a google drive folder or a One Drive folder to use in your network. They all will be able to use it. Check this guide to learn more about it: Licence Details

  4. 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.

  5. 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.

  6. 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!

  7. 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!!

  8. 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 TEMPLATES