Try the sheet here, on the example
The sheet is open below with sample numbers. Change any white cell and watch the results update, or press the blank-copy button to type your own data from scratch. Nothing you type leaves your browser.
Example from the sheet
| Month shown | 46327 | As of | 46342 | Change the month and date on Settings. | |
|---|---|---|---|---|---|
| Posts planned this month | 32 | ||||
| Published | 15 | ||||
| Approved or scheduled | 8 | ||||
| Still in progress | 9 | ||||
| Ideas without a date | 1 | ||||
| Reach (published this month) | 49,900 | ||||
| Engagements (published) | 4,219 | ||||
| Engagement rate | 8.5% | ||||
| Posts that need attention | 6 | ||||
| Platform | Posts | Published | Reach | Engagements | Engagement rate |
| 13 | 6 | 17,600 | 1,515 | 8.6% | |
| 8 | 4 | 7,200 | 568 | 7.9% | |
| TikTok | 6 | 3 | 21,000 | 1,890 | 9.0% |
| 5 | 2 | 4,100 | 246 | 6.0% | |
| YouTube | 0 | 0 | 0 | 0 | 0.0% |
| X | 0 | 0 | 0 | 0 | 0.0% |
| 0 | 0 | 0 | 0 | 0.0% | |
| Newsletter | 0 | 0 | 0 | 0 | 0.0% |
Example from the “Summary” tab, with the numbers and formulas that are in the file.
What is inside
- Summary: Posts planned, published, approved or scheduled and still in progress for the month, ideas without a date, reach, engagements and engagement rate, a Needs attention table, and tables by platform, status and content pillar. Four charts: posts by platform, content pillar mix, engagement rate by platform and posts per week.
- Calendar: The month as a Monday-to-Sunday grid. Each day shows up to three posts as platform and title, with (done) on published ones and (idea) on ideas; a busier day shows how many more are on the Posts sheet. Today is highlighted and days outside the month are greyed.
- Posts: The planner: one row per post, with dropdowns for platform, content type, pillar, owner and status. It adds the week start, the day, days to go, the engagement rate and a Flag column. Room for 1,000 posts.
- Frequency: Posts per platform for each of the six weeks on the calendar, next to your weekly target for the platform. A week below target turns yellow and a column counts the weeks under target.
- Settings: Business name, the month to show, the "as of" date, the approve-soon window, and your lists: platforms with a weekly target, content types, content pillars, team members and the fixed status list.
The file opens on a start tab (“Start here”) that explains how to use it.
What makes it different
Most free content calendars are a table of dates with blank cells. This one separates planning from viewing: you type each post once on Posts, and the month grid, the weekly counts and the summary all update from it. It also tells you what needs doing: overdue posts, missing captions, posts to approve soon and published posts with no results. The sample is a coffee roaster planning November 2026 across Instagram, Facebook, TikTok and LinkedIn, so every sheet has something to show before you replace it with your own.
How do I make a social media content calendar in Excel?
Start with the lists, not the dates. Decide which platforms you will post on and how many posts a week each should get, then three to six content pillars: the recurring topics you will talk about, such as education, product, behind the scenes, customer stories and promotions. Type them on the Settings sheet; they become the dropdowns on the Posts sheet.
Then add one row per post on Posts, in any order. Give each a date, platform, pillar, title and status; write the caption when you get to it. The Calendar sheet shows the month from those rows, so you plan in the list and review in the grid.
How many posts a week should I plan for each platform?
There is no single right number, and guides that give one are rough guidance. Pick a rate you can keep up for months, enter it as the weekly target for each platform in Settings, and let the Frequency sheet show where you fall short. In the sample, Instagram has a target of 4 posts a week and TikTok 2, and any week below its target turns yellow.
Review the targets every few weeks against the results on Summary. If a platform keeps missing its target, the target is probably too high for your team; if it keeps hitting it with good results, you can raise it.
How do I know which posts are late or not ready?
The Flag column on Posts checks every row against the "as of" date on Settings. In the sample, dated 2026-11-16, six posts need attention: the Instagram reel "Gift sets are here" was due on 2026-11-13 and is still In review (Overdue), the Instagram photo "Gift sets: hero shot" is Approved but has no caption (No caption), the TikTok reel "Latte art fails" is Published without results (Add results), and three Drafting or In review posts due within the next three days are marked Approve soon.
The Needs attention table on Summary counts each kind, so you can open Posts, filter the Flag column and work through them. The approve-soon window is a setting; change it if your approvals take longer than three days. For paid posts, the ads performance tracker follows spend and results.
How to use it
- On the Settings sheet type the month to show, the "as of" date (today), your platforms with a weekly posting target, your content types, content pillars and team members.
- On the Posts sheet add one row per post: date, time, platform, content type, pillar, title, caption, hashtags, link to the asset, owner and status. Posts you have not dated yet can stay as Ideas.
- Move each post along the status list as it progresses: Idea, Drafting, In review, Approved, Scheduled, Published.
- Open Calendar to see the month as a grid. Every post appears on its day with its platform; a day with more than three posts shows how many more there are.
- After a post is published, type its reach, engagements and clicks. The engagement rate is calculated for you.
- Check the Flag column on Posts and the Needs attention table on Summary: overdue posts, missing captions, posts to approve soon and published posts without results.
- Open Frequency to see posts per platform per week against your target, and Summary for the month totals and charts.
Before you start:
- Capacity: 1,000 posts, 8 platforms, 10 content types, 6 content pillars and 10 team members.
- The Calendar, Summary and Frequency sheets show the month typed on Settings. Change it to look at another month; the calendar weeks start on Monday.
- Cancelled posts stay on the Posts sheet but do not appear on the Calendar or in the counts.
- The status names drive the flags and counts, so use the list as it is. The platform, type, pillar and owner lists can be renamed.
- A post is Overdue when its date is before the "as of" date and it is not Published or Cancelled. "Approve soon" means an Idea, Drafting or In review post due within the number of days set on Settings.
- Engagements means likes, comments, shares and saves added together, whatever your platform reports.
- The weekly targets are compared with every week the calendar shows, including the part of a week that falls outside the month.
Still running this on Excel?
This sheet suits a start and a limited amount of data. If your way of working grows, or you need more than one person working on it at the same time, Softwiro can build you a program that fits the way you work.
| In this sheet | In Custom Software from Softwiro |
|---|---|
| One file that one person edits at a time, and copies reach you on WhatsApp. | A program with a login for each user and permissions you define, and everyone sees the same data. |
| You type everything and check the numbers by hand. | We design the screens around your work steps, so each person records only what concerns them. |
| Columns and formulas are fixed as the sheet was designed. | We build what you need: reports, alerts and screens your way. |
| Backups and security are your own responsibility. | The program runs on a secured server with regular backups. |
Frequently asked questions
Is this content calendar template really free?
Yes. Download it, use it for your own accounts or your clients and change anything you like. You do not need to sign up to open the file.
Does it work in Google Sheets and LibreOffice?
Yes. It uses ordinary formulas such as COUNTIFS, SUMIFS, INDEX and MATCH, so it works in Excel 2016 and later, LibreOffice and Google Sheets. Upload the file to Google Drive and open it with Sheets.
How many posts can it hold?
1,000 posts, 8 platforms, 10 content types, 6 content pillars and 10 team members. The Calendar shows up to three posts on each day, and a busier day shows how many more are on the Posts sheet.
Can I plan more than one month?
Yes. The Posts sheet holds posts for any dates. The Calendar, Frequency and Summary show the month you type on Settings, so change it to move to the next month. The calendar weeks start on Monday.
Does it post for me?
No. It is a planner. You still publish from the platform or a scheduling tool, then mark the post Published and add its results here.
Is the template free?
Yes, with no sign-up and no email address. Use it, edit it and share it as you like.
Does it work in Google Sheets and on mobile?
The sheet uses formulas supported by Excel 2016 and later, Google Sheets and LibreOffice, so you can upload it to Google Drive and open it with Google Sheets on a computer or a phone.
What is the difference between the white and the gray cells?
You type in the white cells; the gray cells are calculated automatically. Don't type in a gray cell, or you will erase its formula.
Can I use the sheet from an AI assistant?
Yes. Add our MCP server (URL https://softwiro.com/api/mcp, no key needed) to your assistant and ask it to do the calculation in this template. The numbers come from the sheet's own formulas, and we do not store your data. The steps and a ready-made prompt are in this article: https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html
All the templates in this group: Excel templates for paid ads: budget, performance and reports
More free templates for: Marketing and advertising
More free templates
- Ad Performance Tracker for Excel (ROAS, CPA)
- A/B Test Log Template for Excel (Experiment Tracker)
- Breakeven ROAS Calculator for Excel
- Class Schedule Maker for Excel
- GPA Calculator for Excel (Weighted and Unweighted, by Term)
- Lesson Plan Template for Excel with Curriculum Tracker
- Donation Tracker Spreadsheet for Nonprofits (Excel)
- Expiry Date Tracker for Excel (Inventory)
- HOA Dues Tracking Spreadsheet for Excel
- HOA Budget Template for Excel
- Car Rental Booking Tracker for Excel