Content calendar template

A social media content calendar template with only the columns that help a post ship.

A calendar is a work surface, not a museum of every field your marketing team has ever heard of.

If a column does not help someone create, review or publish the post, it probably belongs somewhere else.

Why this exists

Content calendars usually fail from column bloat or false precision.

Some calendars track twenty details nobody updates. Others assign a date to an idea that has no caption, no media and no owner, creating the appearance of a plan.

A usable calendar should tell you what is going out, why it exists, what is still missing and who needs to move it.

Copy-paste template

One row per post. Eight fields.

Date | Platform | Format | Purpose | Caption/Hook | Media | Status | Owner
-----|----------|--------|---------|--------------|-------|--------|------
     |          |        |         |              |       | Idea   |
     |          |        |         |              |       | Draft  |
     |          |        |         |              |       | Review |
     |          |        |         |              |       | Approved |
     |          |        |         |              |       | Scheduled |
Filled example

Example: one small-business week.

Mon | Instagram | Single image | Explain | What monthly bookkeeping actually covers | /assets/bookkeeping.jpg | Approved | Ada
Wed | LinkedIn | Text | Reassure | The admin mistake I see before every deadline | — | Draft | Ada
Fri | Instagram | Carousel | Invite | 5 things to bring to your first bookkeeping call | /assets/first-call/ | Review | Sam
How to use it

Make the template earn its place.

01

Start with purpose, not date.

Choose why the post exists before assigning it a slot. A date should organise a real decision, not create one.

02

Use status honestly.

Idea, Draft, Review, Approved and Scheduled should mean different things. If everything is 'planned,' the calendar cannot show where work is stuck.

03

Link the real asset.

Do not rely on filenames people have to hunt down later. The Media field should point to the final file, folder or content record.

Keep it lean

A template dies when every possible field becomes mandatory.

  • Hashtags do not need a permanent column if you rarely use them.
  • Do not predict engagement in the calendar.
  • Keep long campaign notes in a linked brief.
  • If Owner is always one person, remove the column.
Questions
Should I plan a week or a month in the calendar?

Use the horizon your business can keep truthful. A month view can show campaigns while the detailed production plan may still be weekly.

What statuses should a social media calendar use?

A simple sequence is Idea, Draft, Review, Approved, Scheduled and Published. Remove any state your team cannot explain.

Why include Purpose?

It stops the calendar becoming a row of formats and dates. The purpose tells you what each post contributes to the week.

From template to workflow

When the spreadsheet starts doing too much, let the content carry its own state.