Guides

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.

Dan Koe··7 min read

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.

ColumnWhat you write in itExample
DateThe day and time it goes outTuesday, 9:00 AM
PlatformWhere it goesLinkedIn
TopicWhich of your two or three main topics it isPricing
IdeaThe point of the post, in one sentenceRaise prices before demand
FormatShort post, carousel, video, newsletterCarousel
StatusIdea, drafted, scheduled, postedDrafted

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.

DayWhat goes out
MondayThe long piece. A newsletter, an article, or a video.
TuesdayA short post with the main idea from the long piece
WednesdayA carousel that walks through its steps
ThursdayA short post with one story or example from it
FridayA short video or clip of the strongest point
SaturdayA question to your audience on the same topic
SundayPlan 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

ToolGood forCost
A spreadsheetStarting today with no setupFree
A scheduler like BufferPosting on time without logging in to each platformFree for 3 channels, then $6 a channel a month
EdenThe calendar, the research, and the scheduler in one placeFree 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.