How-To Guide

What should a social media content calendar template include? Free template

A free social media content calendar template with the 20 columns that matter, from format and reference post to status and live link, plus a filled week.

7 min read

By the Superdirector editorial team. Templates and platform help pages read November 6, 2026.

At a glance

What should a social media content calendar template include? Free template

One row per post, with columns for when and where it goes out (date, platform, account, format), what it says (hook, copy or slide outline, call to action, asset link), who owns it and its status, and what happened after (the live link and 7-day results). Add one column most templates leave out: the reference post, a proven post you are modelling the slot on, with a note on why it worked. That column turns a list of dates into a plan, and the live-link column shows which scheduled posts actually went out.

  • Plan columns: date, day, platform, account, format, pillar or goal.
  • Make columns: reference post, why it worked, your hook, copy or slide outline, CTA, asset link, owner.
  • Ship and learn columns: status, where it is scheduled, live URL, 7-day views, saves and shares, notes.

What a content calendar template is for

A social media content calendar is a table with one row per post. The free templates that rank for this question agree on the basics. HubSpot's lists content type, post title, link, a snippet of copy, an image link and the publish date. Buffer's guide asks each entry to carry its date, platform, caption, media and current status. That is enough to remember what you planned. It is not enough to tell you whether a post is likely to work, or whether it actually went out.

Emplifi's calendar guide lists eight fields and puts the line well: a calendar that captures only the first two, what is published and where, is a content list, not a calendar. The template below adds two things a founder running social alone needs: a reference post for each slot, and a live link that proves the post was published.

The columns a content calendar template needs

Twenty columns, in the order you fill them. Skip any you do not need, but keep reference post, status and live URL.

GroupColumnWhat goes in it
PlanDate and dayThe publish date. The day column makes gaps obvious.
PlanPlatform and accountInstagram, X, TikTok, LinkedIn; the handle if you run more than one.
PlanFormatCarousel (with slide count), single image, Reel, X post, X thread (with post count).
PlanPillar or goalTeach, show the product, opinion, behind the scenes, social proof.
MakeReference post URLA post in your niche that did far better than its account usually does.
MakeWhy the reference workedIts hook pattern and structure, in a few words: question hook, five-slide list, before and after.
MakeYour hookYour first line or first slide, written out.
MakeCopy or slide outlineCaption, or one line per slide.
MakeCTAOne ask: save, reply, follow, visit.
MakeAsset linkWhere the finished images or video live.
MakeOwnerWho makes and approves it, even if that is always you.
ShipStatusIdea, drafting, approved, scheduled, live or missed.
ShipScheduled inInstagram app, Meta Business Suite, a scheduler, or by hand.
ShipLive URLThe published post's link. A row is done only when this is filled.
Learn7-day viewsViews or impressions a week after posting.
Learn7-day saves or bookmarksThe signal that people want to keep it.
Learn7-day sharesThe signal that people passed it on.
LearnNotesPermissions, product tags, anything you changed by hand.

The reference-post column is the one that changes how you plan. Instead of asking what to post on Thursday, you ask which proven format you will remake on Thursday, and you write down why it worked before you write a word of your own. If you need a way to find those posts, our guide on finding viral content in your niche scores each post against its own account's usual views.

Copy the free template

Download the content calendar template (CSV). It has all twenty columns and the example week below. In Google Sheets choose File, then Import, and upload the file; Excel and Numbers open it directly. No form, no sign-up.

  1. Delete the example rows, or keep them on a second tab as a guide.
  2. Freeze the first row and the date column so they stay visible as you scroll.
  3. Add a drop-down on Status (in Sheets: Data, then Data validation) with the six values below.
  4. Add two more tabs: an idea bank for posts you might remake, and a notes tab for permissions and logins you must not lose.

A filled week for a small brand

Here is one week for an invented two-person candle brand posting three times on Instagram and twice on X. The brand, the handles and the reference posts are examples, not real accounts.

DayPlatform and formatReference patternHookStatus
MonInstagram carousel, 7 slidesQuestion hook, one tip per slide, save promptWhy your candle tunnels (and the 1-hour fix)Scheduled
TueX postContrarian one-liner with numbersMost burn times on labels are measured in a lab you do not live in.Approved
ThuInstagram carousel, 5 slidesBefore and after, five-slide list5 rooms and the one scent that worked in eachDrafting
FriX thread, 4 postsA mistake story that ends with the lessonWe poured 400 candles before noticing the wick was wrong.Idea
SatInstagram single imageNone: a customer photo, shared with permissionWhat a customer sent us this weekLive (link filled)

Three things to notice. Four of the five slots start from a proven pattern. Only one row is done, because only one has a live link. And Thursday's carousel has a note: it needs a product tag, and Instagram says product tagging, collaborative posts, sponsored posts and fundraisers do not work with scheduled content, so that one gets posted by hand. Our 30-day calendar example extends the same brand to a full month.

Use status values that show what really went out

Sprout Social's guide uses draft, in review, approved, scheduled and published. For one person, six values cover it:

  • Idea: a slot with a reference post and maybe a working hook; nothing made yet.
  • Drafting: hook and outline written, assets in progress.
  • Approved: ready, waiting to be scheduled. If someone else signs off, this is their step.
  • Scheduled: queued in a tool, with the tool named in the next column.
  • Live: published, with the live URL filled in.
  • Missed: the date passed and nothing went out. Keep the row; the pattern of misses tells you your real pace.

Scheduled is not live. Connections expire, a file fails a format check, a scheduled post needs a feature the scheduler cannot add. The live-URL column is how you catch that in a weekly two-minute check instead of a month later.

Add the fields each platform needs

Sprout makes a fair point here: each network needs its own planning fields, not one shared set. Add these as notes or extra columns only for the platforms you use:

PlatformExtra fields worth trackingWhy
Instagram carouselSlide count, cover slide, alt text, product tagsInstagram's publishing API allows up to 20 images or videos per carousel and crops every slide to the first one.
Instagram ReelCover frame, audio source, trial reel yes or noLicensed or original audio matters for brand accounts.
XSingle post or thread, post count, link in reply or notThreads need every post written before you schedule.
TikTokConcept, hook, sound direction, publishing ownerSprout lists these, plus creator notes, for TikTok.
Any AI-made postAI label needed yes or noInstagram's API has an is_ai_generated field for self-disclosure; label where a platform requires it.

Know when a spreadsheet stops being enough

Emplifi's rule of thumb is that a spreadsheet calendar works for a small or mid-market team on four to six channels with two or three approvers, and starts to break with several editors, outside reviewers or a lot of manual reporting. For a founder the signs are simpler: you post by hand every day, you keep forgetting to fill the live-URL column, or you spend longer copying captions into apps than writing them. That is the point to move the same columns into a scheduler. Our comparison of the best social media schedulers for a small business covers which ones handle carousels and X threads.

Superdirector, the product behind this site, fills a calendar like this one in its own Calendar. Tell it which accounts, competitors, keywords and hashtags to follow on Instagram, TikTok, YouTube and X. It spots the posts taking off and rebuilds each one with the same hook and structure as a carousel or X post in your brand, so every slot starts from a reference post. On Growth it then publishes the Instagram carousels and single X text posts, 3, 5 or 7 a week, once you approve the first one or switch on Auto-post, and you remain the publisher. AI video and full autopilot are coming soon.

More on planning and posting

Frequently asked questions

What should a social media content calendar template include? Free template

A useful template has one row per post and columns for date, platform, account, format, pillar or goal, hook, copy or slide outline, call to action, asset link, owner, status, where it is scheduled, the live URL and results after seven days. Add a reference-post column for the proven post each slot is modelled on. Our free CSV has all twenty columns and a filled example week.

Is there a free social media content calendar template for Google Sheets?

Yes. Our template is a plain CSV, so it opens in Google Sheets (File, Import), Excel or Numbers with no form or sign-up. HubSpot, Smartsheet and Buffer also offer free calendar templates.

Is a content calendar the same as a social media calendar?

A content calendar covers everything you publish, including blog posts and email. A social media calendar is the social layer of it: posts, formats and platforms, usually one row per post. Most small brands only need the social one until they publish elsewhere every week.

How far ahead should a small brand plan its social calendar?

Two to four weeks is enough for most founders. Buffer suggests blocking 30 minutes to map the next two weeks, and Instagram's own scheduler lets a public account schedule posts up to 30 days ahead without a subscription.

How many posts a week should the calendar plan?

Plan a pace you can keep for months. Three posts a week on your main platform is a common sustainable starting point, and Buffer recommends a steady cadence over random bursts. Add more only after the first three are reliably going out.

Why add a reference post column?

It forces each slot to start from a post that already worked for a similar audience, so you note the hook and structure before you write. You keep the structure and make new content in your brand; you do not repost or copy the original.

Related practical guides

Fill next week's five rows

Download the CSV, pick five reference posts from your niche, and write a hook for each before you make anything.