Social Media Content Calendar Template (Free, With a Weekly Example)
Quick answer: A social media content calendar is one shared sheet that shows what goes out, where, when, who owns it and whether it’s approved. Start with nine columns (date, platform, format, pillar, hook, CTA, owner, status, link), add a “repurpose to” column, plan one week at a time, and post only as often as you can keep up.
Key takeaways
- A spreadsheet is enough for most small businesses. Buy a scheduler later, when posting by hand becomes the bottleneck.
- There’s no universal “right” posting frequency. Pick a pace you can hold for a month, then test a change.
- The “repurpose to” column is the cheapest way to fill next month’s calendar from this month’s work.
Most social media content calendar template downloads look great on day one and get abandoned by week three. The sheet isn’t usually the problem. People add twenty columns, plan a whole quarter in one sitting, and then real life gets in the way. This guide gives you a template small enough to keep using, a filled-in week for a small business so you can see what good entries look like, and a 30-minute routine to keep it alive.
Tool features below are checked against each company’s own help pages, linked where they come up. Where we couldn’t confirm a detail, we left it out.
What a social media content calendar actually does
It answers four questions at a glance: what’s going out this week, on which account, who is making it, and is it ready. That’s it. If your calendar can’t answer those in ten seconds, it’s too complicated.
It also stops the “what do we post today?” panic, and the lopsided week where three promo posts land in a row because nobody saw the whole plan.
The social media content calendar template (copy this)
Copy the header row into Google Sheets, Excel or a Notion database. One row equals one post on one platform. If the same idea goes to Instagram and LinkedIn, that’s two rows, because the format and caption usually change.
| Date + time | Platform | Format | Pillar | Caption hook | CTA | Owner | Status | Link (with UTM) | Repurpose to |
|---|---|---|---|---|---|---|---|---|---|
| Mon 10:00 | Carousel | Teach | First line of the caption | Save this | Name | Idea | URL | LinkedIn post, Story | |
| Wed 12:30 | Photo | Behind the scenes | First line of the caption | Visit / call | Name | Draft | URL | Reel next month | |
| Fri 17:00 | TikTok | Short video | Proof | Opening line on screen | Comment | Name | Scheduled | URL | Instagram Reel |
What each column is for, and why it earns its place:
- Date + time: when it goes live, in one time zone that everyone on the team uses.
- Platform and format: keep these separate so you can filter “all Reels this month” or “everything on LinkedIn”.
- Pillar: the theme the post belongs to (more on pillars below). This column is how you spot a week that’s all selling.
- Caption hook: just the first line. Writing the hook first forces you to know what the post is about before you design anything.
- CTA: the one thing you want people to do. One per post.
- Owner: one name. “Team” means nobody.
- Status: Idea, Draft, Needs approval, Approved, Scheduled, Posted. Use a dropdown so the words stay consistent.
- Link: where the post sends people. Tag it so you can see the visits later (see the measuring section).
- Repurpose to: the column most templates skip. Note where this idea can go next, so a good post doesn’t die after 48 hours.
In Google Sheets, you can turn the Status, Platform and Pillar columns into dropdowns through Insert > Dropdown or Data > Data validation, and give each option its own color. Google’s help page on creating an in-cell dropdown list walks through it. Colored status chips make a stuck “Needs approval” row hard to miss.
Social media content calendar example: one week for a small bakery
Blank templates are easy to make and hard to fill. So here’s a made-up neighborhood bakery with two people doing social media on the side: the owner and one staff member. They post on Instagram and Facebook, plus one short video a week.
| Day | Platform | Format | Pillar | Caption hook | CTA | Owner | Status | Repurpose to |
|---|---|---|---|---|---|---|---|---|
| Mon | Carousel | Teach | “Why your sourdough comes out flat (3 likely reasons)” | Save for your next bake | Owner | Approved | Facebook post, Pinterest pin | |
| Tue | Photo | Offer | “Tuesday only: day-old loaves at half price” | Come in before 2 pm | Staff | Scheduled | None (time-bound) | |
| Wed | Story poll | Community | “Cinnamon roll or croissant?” | Vote | Staff | Draft | Next week’s special | |
| Thu | Instagram + Facebook | Reel | Behind the scenes | “4:30 am, first trays in” | Follow for more | Owner | Needs approval | TikTok, YouTube Shorts |
| Fri | Photo + text | Proof | A customer review, shared with permission | Order for the weekend | Owner | Idea | Website testimonials | |
| Sat | Story | Behind the scenes | “Last batch of the day” | Visit today | Staff | Idea | None |
Notice what’s missing: Sunday. A small team needs a day off, and a calendar that pretends otherwise is the one that gets dropped. Also notice that only one post out of six is a straight offer. The rest give people a reason to follow.
How to make a social media content calendar in six steps
1. Pick three or four content pillars
Pillars are the recurring themes your account is known for. For most small businesses, four cover it: teach (tips, how-tos), show (behind the scenes, process, team), prove (reviews, results, before and after) and sell (offers, launches). A local service might swap “teach” for “local guides”. An Etsy seller might add “new listings”.
Pillars do one job in the calendar: they make imbalance visible. If you filter the Pillar column and see eight “sell” rows out of ten, you know why engagement dipped. For hook ideas inside each pillar, our social media engagement post ideas and framework has ten formats you can slot straight in.
2. Choose platforms and a posting frequency you can keep
You’ll find plenty of “post X times a day” advice online. Ignore any number that doesn’t come with your own data. The right frequency depends on your platform, your audience and, honestly, how many hours you have. A pace you hold for three months beats a burst of daily posting followed by silence.
A simple way to test it: pick a pace, say three posts a week, and keep it for four weeks. Note reach and saves or clicks per post. Then change one thing (add a fourth post, or swap a photo for a short video) for the next four weeks and compare. Change one variable at a time, or you won’t know what caused the difference.
Start with one or two platforms where your customers already are. Our social media marketing guide for small businesses covers how to choose them.
3. Batch the work
Batching means doing one type of task in one sitting: all captions on Monday, all photos on Tuesday. Switching jobs for every single post is where the hours go. Sort the calendar by Format and the week’s Reels line up together, so you can film them in one go.
4. Set a simple approval workflow
If one person runs the account, skip this. If two or more people touch it, or a client signs off, you need a rule. A simple one: nothing moves from “Needs approval” to “Approved” without the approver’s name in a comment, and anything not approved by Thursday noon gets pushed to next week instead of rushed.
Some tools build this in. Buffer’s help center describes a flow where team members with approval-only access submit drafts and an owner approves them in an Approvals tab, though its page on managing and approving draft posts says approving drafts is only on its Team plan. A Status dropdown in a free spreadsheet does the same job for a small team.
5. Recycle evergreen posts
An evergreen post is one that’s still true in six months: a how-to, an FAQ answer, a process video. Most followers didn’t see it the first time, and the ones who did won’t mind a better version.
Add a tab called “Evergreen bank”. When a post does well, copy its row there. When you plan next month, pull two or three from the bank, refresh the hook and visual, and change the format if you can. That’s what the “repurpose to” column feeds: a carousel becomes a Reel, a Reel becomes a Story series, a long caption becomes a LinkedIn post. Don’t repost time-bound offers or anything with old prices.
6. Measure, then adjust the calendar
Add three result columns at the far right: reach, one engagement number that matters to you (saves, shares or comments), and link clicks. Fill them a week after each post goes live. Our guide to social media engagement metrics explains which numbers to trust and how to calculate a rate.
For website visits, tag every link. Google Analytics’ page on URL builders and campaign data says you should always use utm_source, utm_medium and utm_campaign when you add parameters. A simple pattern like utm_source=instagram, utm_medium=social, utm_campaign=november-bakes keeps reports readable.
Where to keep your calendar: Google Sheets, Notion, Trello or a scheduler
Every option below works. Pick the one your team already opens every day.
| Tool | Good for | Worth knowing |
|---|---|---|
| Google Sheets / Excel | Free, flexible, easy to share with a client | Sheets supports colored dropdowns for status and pillar columns |
| Notion | Teams that want a calendar view plus drafts in one place | A calendar view needs a Date property in the database |
| Trello | Visual boards where each post is a card moving through status lists | Atlassian says the board Calendar view is a Premium and Enterprise feature |
| Meta Business Suite | Scheduling Facebook and Instagram posts and stories from one place | Covers Meta’s own apps only |
| Buffer | Scheduling across several networks with a week or month calendar | Draft approvals need its Team plan |
Sources for the table: Notion’s calendar view help, Atlassian’s Trello calendar view page (no free Workspaces), Meta’s Meta Business Suite page plus its help guide to save, schedule or reschedule posts, and Buffer’s calendar feature guide, which covers dragging posts to a new time and filtering by tag.
Our take: keep the plan in a spreadsheet or Notion, and use a scheduler only for the publishing step. The plan holds ideas, notes and results. The scheduler just pushes the button. If you want to compare dedicated tools, we reviewed five social media planners for performance tracking.
The 30-minute weekly planning routine
This is the part that keeps a calendar alive. Book the same 30 minutes every week, ideally Thursday or Friday, so next week is ready before the weekend.
- Minutes 0–5, look back. Fill in the result columns for last week. Mark the best post with a star.
- Minutes 5–10, copy forward. Duplicate the starred post’s row into the Evergreen bank and fill its “repurpose to” cell.
- Minutes 10–20, fill next week. Add rows for each slot. Check the Pillar column: no more than one or two “sell” rows. Pull one item from the Evergreen bank.
- Minutes 20–25, write hooks and assign. One hook line and one owner per row. Leave full captions for the batching session.
- Minutes 25–30, flag blockers. Anything that needs a photo you don’t have, a client sign-off or a price check gets a note now, not on posting day.
Running over 30 minutes? Cut a post slot.
Mistakes that make people quit their calendar
- Planning a full quarter on day one. Plan a month of themes and one week of detail. News, stock and the weather will change the rest anyway.
- No space for live moments. Leave one open slot a week for something timely. A calendar is a plan, not a contract.
- Scheduling and forgetting. Scheduled posts still get comments. Someone has to be around to reply in the first hour or two.
Verdict: what to do next
Copy the template above into a free spreadsheet today. Pick three or four pillars, choose a posting pace you can hold for a month, and fill in next week only. Run the 30-minute routine every week for a month before you change anything or pay for a tool. If planning still eats your week after that, a scheduler or outside help starts to make sense, and our list of social media management services is a good place to compare options.
Next: fill your first week with hooks from our 10 social media engagement post ideas.
Frequently Asked Questions
What should a social media content calendar include?
At minimum: publish date and time, platform, format, content pillar, caption hook, call to action, owner, status and the link. Adding a “repurpose to” column and a few result columns turns it from a to-do list into something you learn from.
How far ahead should I plan social media content?
For a small business, plan themes a month ahead and full details one week ahead. Longer plans tend to go stale before they’re posted. Big launches and holidays are the exception, so pencil those in as soon as you know the dates.
Can I make a social media content calendar in Google Sheets or Excel?
Yes, and for most small teams it’s the best place to start. Paste the header row from this post, turn Status, Platform and Pillar into dropdowns, and freeze the top row. Add one tab per month and one for your evergreen bank.
Which tools can schedule posts from my calendar?
For Facebook and Instagram, Meta Business Suite lets you schedule posts and stories from Meta’s own dashboard. Third-party schedulers like Buffer cover more networks, but check each one’s current plans on its own site, since features such as approvals sit on paid tiers.
