Monthly content calendar template: a ready-to-use spreadsheet

A monthly content calendar with one row per post. Each includes a pillar, a status and a reason to post now. Download it or make a copy.

No email, no sign-up. There's no paid upgrade: everything's already in the file.

Fill it in: seven steps

  1. 01

    Fill in the month's dates and the platforms you use.

  2. 02

    Choose how often your team can post consistently for all four weeks.

  3. 03

    Plan your mix of pillars for each week using the Pillars sheet.

  4. 04

    For each date, write the topic and format.

  5. 05

    In the Why now column, give a reason: season, holiday, customer question.

  6. 06

    Add the goal, key message, call to action and the owner.

  7. 07

    Update each post's status until it reaches Published, then add reach and reactions at the end of the month.

Three filled-in examples

See the first two weeks of March planned for a beauty salon, a coffee shop and an online school. Choose a niche to compare reasons to post and content pillars. The businesses are fictional, and the numbers are illustrative.

Download this example · XLSX
DateWeekdayPlatformFormatPillarTopicWhy nowStatus
Mar 2MondayInstagramCarouselValueWhat not to do in the first 24 hours after coloringClients who had their hair colored in February keep asking the same questions in DMsPublished
Mar 3TuesdayInstagramStoriesSalesOpen manicure slots before International Women's DayFive days to the holiday, and Mar 7 slots go firstPublished
Mar 4WednesdayTelegramPostEngagementPoll: nude or bold nails for the holidayClients ask about nail designs most often right before the holidayPublished
Mar 5ThursdayInstagramReelsExpertiseBefore and after: repairing hair after a bad bleach jobThe client agreed to let us share the results, and more clients book lightening treatments in springScheduled
Mar 6FridayTelegramPostSalesGift certificates for International Women's DayThe holiday is two days away, and people are looking for last-minute giftsScheduled
Mar 9MondayInstagramCarouselBehind the scenesHow we sterilize our toolsNew clients arrive after the holidays and ask about sterilization more oftenPending approval
Mar 10TuesdayInstagramReelsExpertiseMeet our new brow stylistShe starts taking clients at the salon on Mar 10Draft
Mar 12ThursdayTelegramPostValueMyth or fact: lamination damages your browsThis comes up in almost every brow consultationIdea
Mar 14SaturdayInstagramStoriesEngagementQuiz: what treatment does your hair need this springThe season is changing, and clients mention dry hair after winterIdea

Five pillars for your content calendar

A content pillar explains why a post matters to your brand. These proportions are a guide based on common social media practice. You can increase the share of sales posts for a week before a launch or holiday.

Value

30–35% of the plan

Solves one problem for a follower: a tip, a checklist, an answer to a question you hear often.

  • What not to do in the first 24 hours after coloring
  • Flat white, latte, cappuccino: what's the difference
  • Five mistakes that make adults quit learning English
  • Holiday opening hours

Expertise

20–25% of the plan

Shows what you can do: finished work, breakdowns, case studies, answers to objections.

  • Before and after, with an explanation of what the stylist needed to do
  • How milk changes the taste of coffee
  • A student case study: where they started and what changed
  • Answering the “I don't have time” objection

Sales

15–20% of the plan

Asks directly for a booking or a sale: open slots, offers, announcements with dates.

  • Open slots for tomorrow, with exact times
  • Gift cards for the holiday
  • Cohort announcement with the program and dates

Engagement

10–15% of the plan

Gives a follower a reason to respond: a poll, a quiz, a guessing game, a choice between two options.

  • Poll: nude or bold nails for the holiday
  • Guess the ingredient in the new drink
  • Quiz: what kind of student are you

Behind the scenes

10–15% of the plan

Shows the people and process a client doesn't usually see.

  • How we sterilize our tools
  • Opening the coffee shop at 7 a.m.
  • How we review homework

Four mistakes that make people drop the plan

Selling in every other post

Followers come for useful content and the people behind the brand. When sales posts make up more than 20–30% of the calendar, reach and reactions usually drop. Use the remaining posts to share value and expertise.

A frequency nobody can keep up

Seven posts a week look good in a spreadsheet, but by week two the team runs out of steam. Start with three. Add more once you can post consistently for three weeks in a row.

One post copied to every platform

An Instagram carousel dropped into Telegram unchanged turns into a stack of images with no caption. Keep the topic, change the format and the copy for each platform.

Hunting for topics from scratch every week

You have content pillars but no bank of ideas, so every Friday you start from scratch looking for Monday's topic. Keep a list of questions and timely reasons to post, then use it to build your calendar.

Where the template stops helping

A spreadsheet shows what was published, but the reason for choosing the topic gets lost. The Why now column gets filled in carefully the first week, and by month's end nobody can say why that topic was picked.

The result disappears along with the reason: a spreadsheet doesn't measure it. Reach and reactions get typed in by hand, nobody has time to compare them with last month, and the next plan gets built on a hunch again.

Brandbass keeps the reason and the result for every post in the system. Opportunity Inbox suggests up to 5 ideas per brand every morning, each with a reason and a score calculated using a formula. Topics that don't meet the brand's rules are filtered out before scoring. Brandbass pulls metrics from Instagram and turns them into a client report for the week, month or quarter.

How Opportunity Inbox works →How the result is measured →

Early access: 30% off

The first agencies we onboard get 30% off their plan for 12 months from their first payment. In return, we ask for a call every two weeks: what's working, what's getting in the way.

Request access

Questions

It's a spreadsheet that records, for every date in the month, what the brand posts, on which platform and why. Each row is one post, and the status shows what stage it's at.

Start with dates and platforms, then pick a frequency the team can keep up. Plan your mix of pillars for each week, then choose a topic, a reason to post it and a format for each date. Fill in the goal, key message and call to action last. The full steps are in the section above and on the How to use it sheet.

As many as the team can keep up for the whole month. In our examples, the salon posts 4 to 5 times a week counting Stories, the coffee shop posts 3 feed posts plus Stories for daily events, and the online school posts 4 to 5 times a week ahead of a cohort launch.

A media plan covers paid promotion: where you buy placements, how much you spend and what reach you expect. A content calendar covers the brand's own posts. The two overlap when a post from the calendar gets boosted with ad spend.

No. A funnel maps the customer's path from first contact to purchase; a content calendar is a posting schedule. You can tie pillars to funnel stages: value and behind the scenes introduce the brand, expertise addresses doubts, and sales encourages a purchase.

Yes. Download the XLSX and import it into Google Sheets via File → Import. The same file opens in Excel, Numbers and LibreOffice. We don't ask for an email, and there's no paid version of the template.