How to make a social media content calendar (with a weekly template)
How to make a social media content calendar in five steps, with the six columns to track, a weekly template you can copy, and the tools to run it.
A social media content calendar is a table with one row per post. Each row says what you will post, where, and when. You need six columns to start. The date, the platform, the topic, the idea, the format, and the status. Fill it once a week from one long piece of content, and you stop deciding what to post every morning.
Full disclosure. We make Eden, which has a content planner and a scheduler. A spreadsheet works too, and we show both.
What goes in a content calendar
One row is one post. These six columns are enough.
| Column | What you write in it | Example |
|---|---|---|
| Date | The day and time it goes out | Tuesday, 9:00 AM |
| Platform | Where it goes | |
| Topic | Which of your two or three main topics it is | Pricing |
| Idea | The point of the post, in one sentence | Raise prices before demand |
| Format | Short post, carousel, video, newsletter | Carousel |
| Status | Idea, drafted, scheduled, posted | Drafted |
Add more columns later if you need them. A link to the draft, who owns it, and how the post did are the three most people add.
A weekly template you can copy
You don't need new content for every platform. One good long piece a week, broken down, fills the whole calendar.
| Day | What goes out |
|---|---|
| Monday | The long piece. A newsletter, an article, or a video. |
| Tuesday | A short post with the main idea from the long piece |
| Wednesday | A carousel that walks through its steps |
| Thursday | A short post with one story or example from it |
| Friday | A short video or clip of the strongest point |
| Saturday | A question to your audience on the same topic |
| Sunday | Plan next week. Thirty minutes. |
Post the same short posts on every platform you use. Most people only follow you in one place.
Start with fewer days if seven is too many. Three posts a week that you keep up beats seven for one week and none the next.
How to fill it in, step by step
1. Pick two or three main topics
Choose the topics you could talk about for six months. These go in the Topic column, and every post belongs to one of them.
Broad topics are easier to keep up than tiny ones. "Money for freelancers" gives you more to say than "invoice templates."
2. Study what is already working
Before you fill a single row, look at what your audience already responds to.
Find posts on your topics that did far better than the creator's average post. Save 20 to 30 of them. Under each one, write a few reasons it worked. See how to find what content works in your niche.
3. Write the long piece first
Pick one idea for the week and write it long. This is where your thinking happens. Everything else that week comes from it.
4. Break it into short posts
Pull out the main idea, the steps, one story, and the strongest line. Each one is a row. Change the format for each platform and keep the idea the same. More on this in one idea, six platforms.
5. Schedule the week in one sitting
Put a date and time on every row and schedule them all at once. A post with a date gets posted. A post in a notes app waits.
Then watch what happens. When a short post does far better than the rest, that is a signal. Turn it into next week's long piece.
Tools to run your calendar
| Tool | Good for | Cost |
|---|---|---|
| A spreadsheet | Starting today with no setup | Free |
| A scheduler like Buffer | Posting on time without logging in to each platform | Free for 3 channels, then $6 a channel a month |
| Eden | The calendar, the research, and the scheduler in one place | Free to start, scheduling from $29 a month |
A spreadsheet is the right first tool. Its limit is that it only holds the plan. You still copy each post into each platform by hand, and the sheet does not know if a post went out.
How to do it on Eden
Eden's content planner is a table with the calendar built in.
- Start from a template. Make a new table and pick Content planner. Each row is one idea with its status, date, files, and posts. Switch to Calendar to plan by day. See plan your content in a table.
- Find ideas first. Discover shows posts that did far better than the creator's average post, across seven platforms. Save the ones you like to a board.
- Schedule from the row. Write the post from its row and schedule it to X, LinkedIn, Threads, Instagram, TikTok, Facebook Pages, YouTube Shorts, or Substack. See scheduling.
- Rows update on their own. Once a post is scheduled, its row moves to Scheduled and takes the post's date. Once it goes out, the row moves to Posted.
Scheduling starts on the Starter plan at $29 a month. See every plan on the pricing page.
Rather have AI fill it in? ChatGPT can build the whole calendar in Eden for you.
Where Eden falls short. It has no shared social inbox and no white-label client reports. If you only need to queue posts you have already written, Buffer's free plan is enough.
Frequently asked questions
What should a social media content calendar include?
Six columns. The date, the platform, the topic, the idea, the format, and the status. Add a link to the draft and a results column once you have a few weeks of posts.
How far ahead should I plan?
One week is enough to start. Planning a month ahead works once you have a routine, but leave room to react to what your audience responds to.
How often should I post?
As often as you can keep up for six months. Three steady posts a week is a better start than a daily plan you drop in week two.
Can I use a spreadsheet as a content calendar?
Yes. A spreadsheet with the six columns above works well. You will still post each one by hand or copy it into a scheduler.
What is the difference between a content calendar and a content strategy?
The strategy decides who you talk to, your main topics, and where you post. The calendar puts dates on it. Build the strategy first. See a content strategy for a small business.
Ready to plan your week? Start Eden free and open the Content planner template.