It is nine at night, the shop has just closed, and you remember you haven’t posted anything this week. You scroll your camera roll, pick a photo you have already used twice, type a caption in a hurry and post it. Next week the same thing happens, except you forget entirely.
A social media content calendar stops that cycle. It moves the decision about what to post from a tired evening to one planning session a month, so the daily job becomes simply publishing what is already ready. This guide shows how to plan social media posts a month ahead with a plain spreadsheet: setting themes, filling the month, batching the work, handling approvals and reviewing what happened. Finding ideas to fill the calendar is a separate topic, covered in its own guide.
What a content calendar is, and what it is not
A content calendar is a list of planned posts, each with a date, a platform, a format and enough detail that anyone could make it. It answers “what are we posting on Thursday?” before Thursday arrives.
It is not a rigid schedule you must follow whatever happens. Good calendars leave room for things that come up during the month, such as new stock or a customer’s lovely review. And it is not a substitute for replying to people; a full calendar with an ignored inbox is still a neglected account.
Set your themes once, then reuse them
Before filling dates, decide on a small set of recurring themes, often called content pillars. Four or five is enough for most small businesses. They are the categories every post falls into, and they keep the feed balanced without you having to think about balance each time.
For an independent pharmacy, the themes might be:
- Health tips that pharmacists are asked about at the counter.
- New or seasonal products.
- The people behind the counter.
- Practical notices such as hours, delivery areas and holiday closures.
- Community: local events, school health camps, a nearby clinic you work with.
Write your themes at the top of the spreadsheet. They rarely change, and having them there means planning starts from a menu, not a blank page.
A social media content calendar in a spreadsheet
A shared spreadsheet in Google Sheets or Excel is all most small businesses need. Specialised planning tools exist, but they are no help if nobody opens them. Start with these columns:
| Column | What goes in it | Why it matters |
|---|---|---|
| Date | The day the post goes out | Lets you see gaps and clusters at a glance |
| Platform | Instagram, Facebook, LinkedIn and so on | Different platforms may get different posts |
| Format | Reel, carousel, single image, story, text post | Tells you what material must be shot or designed |
| Theme | One of your pillars | Shows whether the month is lopsided |
| Idea | One line describing the post | Anyone can pick it up and make it |
| Caption draft | The text, or notes for it | Approvals happen on real words, not intentions |
| Material needed | Photos, clips, product details, who supplies them | Stops the night-before scramble |
| Status | Idea, in progress, ready, approved, scheduled, posted | Everyone sees where each post stands |
| Link | The website page the post should send people to | Keeps links pointing at the right place |
One row per post. One tab per month, so past months stay available for review. A colour for each status helps the eye, but keep it simple.
How to plan social media posts for a month
Hold the planning session in the last week of the month before. With practice it becomes a short, routine meeting. Work through it in this order:
- Mark the fixed dates. Festivals, public holidays, local events, school terms, your own sales or launches. In India, festival dates move each year, so check them rather than copying last year’s calendar.
- Mark the practical notices. Holiday closures, changes in hours, delivery cut-offs. These are easy to forget and are often what customers most need.
- Decide your rhythm. How many posts per week, on which days. Choose a pace you could keep in your busiest month.
- Fill the slots by theme. Rotate through your pillars so no single theme takes over. Avoid putting two offers back to back.
- Choose formats. Mix them, based on what you can actually produce. If you can make one decent reel a week, plan one, not four.
- Leave open slots. Keep a few dates marked “flexible” for things that happen during the month.
- List the material. For each post, note what is needed and who will supply it, with a date.
Stories usually do not need individual rows. Note a few story themes for the week, such as behind the scenes on Tuesday and a poll on Friday, and fill them on the day.
Batch the making, not just the planning
Planning a month is half the benefit. The other half is making the posts in batches instead of one at a time.
Set aside a couple of short sessions each month for production:
- A shooting session. Photograph and film everything on the calendar that needs new material, in one go, while the light is good and the shop is quiet. Shoot extra; spare clips are useful later.
- A writing session. Write all the captions for the next two weeks together. Your tone stays consistent, and it is faster than starting fresh each time.
- A design session, if you use graphics, for carousels and notices.
Once a post is ready and approved, you can schedule it so it publishes on its own. Our guide to scheduling social media posts in advance explains how that works in Meta Business Suite and other tools.
Approvals without bottlenecks
If more than one person has a say, such as a partner, a manager or an outside helper, approvals can quietly stall a whole month. A few habits keep them moving:
- Approve the month in one go. Share the spreadsheet and drafts at the same time each month, and agree a date by which feedback is due.
- Comment in one place. Comments in the spreadsheet, next to the post, rather than scattered across WhatsApp, email and calls.
- Name one final decision-maker. When two people disagree about a caption, someone decides.
- Agree a fast route for urgent posts. A same-day post about a sudden closure should not wait for the monthly cycle. A short message with the draft and a quick yes is enough.
- Decide what happens if feedback is late. For example, posts not commented on by the due date go ahead as drafted.
Agreeing these rules once avoids arguing about them every month.
Keeping the calendar honest during the month
Plans change. A product sells out, a staff member is ill, a news event makes a cheerful post feel wrong. The calendar should bend:
- Swap posts between dates rather than deleting them; an unused post can move to next month.
- Pause scheduled posts if something serious happens locally or nationally. Automated cheerfulness at a bad moment looks careless.
- Use the flexible slots for real events as they happen.
- Update the status column as you go, so the sheet stays a true record.
Review the month before planning the next
At the start of each planning session, spend a few minutes on the month just gone. Add two columns to last month’s tab, results and notes, and fill them in:
- Which posts led to messages, comments asking questions, website visits or calls?
- Which themes and formats did nothing, even after several tries?
- Which posts were planned but never made, and why?
The last question is often the most useful. If carousels keep slipping because nobody has time to design them, plan fewer carousels. A calendar that matches your real capacity is better than an ambitious one you keep falling behind.
Reusing what you already have
A calendar becomes easier to fill once you treat good material as reusable. A blog post can become a carousel, a short clip and a story. A popular post from six months ago can return with a fresh photo. Our guide to turning blog posts into social posts covers that approach. When you need fresh ideas for empty slots, our list of post ideas for businesses is grouped by type, so it slots straight into your themes.
For how a calendar fits into a wider plan for organic social media, see our small business guide to social media, and for the rest of the marketing picture, our overview of online marketing services.
Frequently asked questions
How far ahead should a small business plan its posts?
A month ahead suits most small businesses. It is far enough to batch work and plan for festivals, but short enough that plans stay relevant. Keep a separate long list of big dates for the year, such as major festivals and your own seasonal peaks, so you can start preparing material for those earlier.
Is a paid planning tool better than a spreadsheet?
Not necessarily. Paid tools add previews, team comments and direct scheduling, which help larger teams. For one or two people, a shared spreadsheet does the same core job and costs nothing. Start with the spreadsheet, and switch only if you find yourself copying the same information into several places every week.
What if I fall behind and the calendar goes out of date?
Do not try to catch up on every missed post. Move the important ones forward, drop the rest, and restart the plan from the coming week. Then look at why it slipped, usually too many posts or formats that take too long, and plan a lighter month next time.
Should the same calendar cover Instagram and Facebook?
Yes, one calendar with a platform column works well. Many posts can go to both with small caption changes, and some will be platform-specific, such as a Facebook event or an Instagram reel. Keeping them together makes it easier to spot gaps and avoid posting the same thing twice in one day.
The spreadsheet above is yours to use as it is. When planning and producing the month is more than you have time for, our social media management work starts with exactly this kind of calendar, agreed with you before anything is posted.
Next in this series: Social Media Post Ideas for Business, by Type
