Guides

How to build a social media content calendar (free template)

A free social media content calendar template you can paste into Google Sheets, Excel or Notion, plus a simple weekly system for filling it and keeping it going.

25 October 2026 · 7 min read

A content calendar is a plan of what you'll post, where and when. It sounds like admin, but it's the thing that turns "I should post more" into posts that actually go out. With one, you write in batches, spot gaps before they happen and stop staring at a blank composer at 9am.

This guide gives you a free template to copy, a simple system for filling it in an hour a week, and a sample week to start from.

What a content calendar needs (and what it doesn't)

Most templates have too many columns. Here's what earns its place:

Column Why it's there
Date and time When it goes out, in your audience's time zone
Network Where it goes: X, LinkedIn, Bluesky, Mastodon, TikTok, YouTube
Pillar Which of your three to five themes it belongs to
Format Text, image, thread, carousel, short video, long video
Hook The first line, the bit that decides whether anyone reads on
Post The text, or a link to the draft
Media The image or video file, or what still needs making
Link Where you want people to go, if anywhere
Status Idea, drafted, ready, scheduled, published
Result A note on how it did, filled in a week later

You can skip "Result" at first. Don't skip "Status": it's how you see at a glance what still needs doing.

The free template

Select the table below, copy it and paste it into cell A1 of a Google Sheet, an Excel or Numbers file, or a Notion table. The columns and sample rows come across as they are; replace the samples with your own week.

Date Time Network Pillar Format Hook Post Media Link Status Result
Mon 2 Nov 08:30 LinkedIn Lessons Text What we got wrong about onboarding Draft in doc None First comment Drafted
Mon 2 Nov 12:00 X Lessons Thread We cut onboarding from 9 steps to 3. Here's what we removed: Draft in doc Screenshot Last post Drafted
Tue 3 Nov 18:00 TikTok Behind the scenes Short video Packing 40 orders in 10 minutes Caption idea Video to film None Idea
Wed 4 Nov 12:00 Bluesky Tips Text One setting most people never change Draft in doc None None Ready
Thu 5 Nov 08:30 LinkedIn Customer stories Image How Sam saved 6 hours a week Draft in doc Photo Case study Ready
Fri 6 Nov 10:00 YouTube Tutorials Long video Setting up in 5 minutes Title and description Video edited Sign-up Scheduled

Add a second tab called Ideas with just two columns, idea and pillar. Every time something post-worthy happens, write it there. That list is what you'll draw on each week.

Step 1: pick three to five content pillars

Pillars are the recurring themes you post about. They keep your feed coherent and make the weekly planning much faster, because you're filling slots rather than inventing from scratch. Good starting pillars:

  • Lessons: what you've learned, mistakes, opinions.
  • Behind the scenes: how things are made, what your week looks like.
  • Tips and how-tos: useful, saveable advice.
  • Customer stories: results, quotes, before and after.
  • News: launches, updates, events. Keep this one small.

A healthy mix is mostly useful posts with a little promotion. If every post asks for something, people stop reading.

Step 2: decide your rhythm per network

Write down how often you'll post on each network, and keep it modest. Two networks done well beats five done badly. Our guide to how often to post has a starting range for each network; for most people it's something like two or three LinkedIn posts a week and one X or Bluesky post a day.

Then turn that into fixed slots: LinkedIn on Monday and Thursday at 8:30, X every weekday at noon. Fixed slots are what make the calendar quick to fill. Our best time to post tool suggests good windows in your time zone.

Step 3: fill a week in one sitting

Once a week, ideally the same day, spend an hour on this:

  1. Look at last week's results and note what did well.
  2. Pick ideas from your Ideas tab for each empty slot, mixing pillars.
  3. Write the hooks first. If you can't write a good first line, the idea isn't ready.
  4. Write the posts, starting with the longest version (usually LinkedIn) and cutting it down for X and Bluesky.
  5. List the media you need and make it, or mark it for later.
  6. Schedule everything that's ready.

Step 4: adapt each post per network

The same idea works on several networks, but the same words rarely do. LinkedIn wants short paragraphs and a story; X wants it in 280 characters or a thread; Bluesky allows 300; Mastodon 500 with hashtags people actually use. Our guide to cross-posting without it looking copy-pasted covers each network's habits, and the image sizes guide covers the media.

Step 5: schedule it and leave room for live posts

Fill about 80% of your slots in advance. Leave the rest for things that happen during the week: news, replies, a great customer message. A calendar that's 100% full makes you ignore good live moments.

From spreadsheet to scheduled posts

A spreadsheet is fine for planning, but you still have to copy every post into each network at the right time. A scheduling tool turns the calendar into the thing that posts. In Postbase:

  • The calendar is the plan. Click an open slot to write a post for that time, on as many networks as you like.
  • Write once, adjust per network. Each network has its own tab in the composer, with its limit checked as you type.
  • Drafts hold ideas. Save half-finished posts as drafts and come back to them in the weekly session.
  • Repeat evergreen posts. Set a post to repeat every week, two weeks or month.
  • Let AI fill gaps. Ask the agent for "two LinkedIn posts and three X posts from these notes" and it drafts them for you to check before they're scheduled.
Calendar
New post
21 – 27 Sep 2026Today
Mon
21
Tue
22
Wed
23
Thu
24
Fri
25
Sat
26
Sun
27
09:00
10:00
11:00
12:00
13:00
14:00
15:00
Manage channels
The Postbase calendar. Click an open slot to write a post for that time.

A sample week for a small business

Day LinkedIn X / Bluesky TikTok or Shorts
Monday Lesson from last week Short tip
Tuesday Behind the scenes photo Process video
Wednesday Question to followers
Thursday Customer story Customer quote
Friday Weekend offer or news Fun or trending video

That's two LinkedIn posts, five X or Bluesky posts and two short videos. It takes most people about an hour to plan and write, plus the filming.

Frequently asked questions

What should a social media content calendar include?

At minimum: the date and time, the network, the post text, any media, and a status (idea, drafted, ready, scheduled, published). Content pillars and a results column make it more useful over time.

Is there a free social media calendar template?

Yes. Copy the table in this guide into Google Sheets, Excel, Numbers or Notion. It has the columns most teams need and a sample week to edit.

How far ahead should I plan social media content?

Plan themes a month ahead and write posts a week ahead. Leave about 20% of your slots open for things that happen during the week.

How many content pillars should I have?

Three to five. Fewer feels repetitive, and more makes your feed feel unfocused and the planning slower.

Should I use a spreadsheet or a scheduling tool?

A spreadsheet works for planning. A scheduling tool saves the copying and pasting, posts on time, and shows the whole week across networks on one calendar. Many people plan in a sheet and schedule in a tool.

How long does it take to plan a week of social media?

About an hour for most small businesses and creators, once your pillars and slots are set. The first few weeks take longer.

Try Postbase free for 7 days

Every network, the MCP server and the API on every plan.

Start free trial

Related

Keep reading

Ready to get started?

Schedule to every network from one calendar, or let your AI agent do it.

Cancel anytime · or self-host for free

Postbase
21 – 27 Sep 2026TodayDayWeek
Wed23
09:00
10:00
11:00
12:00
13:00
14:00
15:00
16:00
09:00Fieldnote 2.4 is out
12:00New on the shelf: Kochere
14:15Cupping notes
16:30Studio tour
Manage channels