Free Social Media Content Calendar Template

A free social media content calendar template to download (CSV for Google Sheets, Excel or Numbers), with every column explained and a sample week.

Ijlal Nasir · 7 min read

This free social media content calendar template is a spreadsheet you can download and open in Google Sheets, Excel or Numbers. It has one row per post per network, a column for every decision you make about a post, and a sample week filled in so you can see how it works.

Download the template (CSV) · Free, no sign-up.

What each column is for

ColumnWhat goes in it
Date and dayWhen it goes out. The day helps you spot gaps and bunching at a glance.
TimeIn your audience's time zone, not yours.
NetworkOne row per network, so each can have its own caption and size.
PillarThe theme it belongs to. Filter by it weekly to see which pillars have gone quiet.
FormatImage, carousel, video, text. Plan a mix.
Hook (first line)The line people see before "…more". Write it first; if it's weak, the post is.
CaptionThe full text, or a note on what it says.
VisualWhat the image or video is, and its size.
LinkWhere the post sends people, if anywhere.
StatusIdea, Draft, Ready, Scheduled, Published. Sort by it to see what's stuck.
Owner and notesWho's doing it, and anything they need.

A sample week

The template comes with this week filled in, for a made-up bakery, so you can see the pattern:

DayNetworkPillarFormatHook
MondayInstagram, LinkedInTipsCarousel, image5 ways to keep bread fresh for a week
WednesdayInstagram, FacebookProductImageThis week's special: rye and caraway
FridayTikTok, InstagramBehind the scenes, communityVideo, image6 a.m. at the bakery

How to use it

  1. Set your pillars. Three to five themes; our content pillar examples have ideas for 12 niches.
  2. Give each pillar a slot. Tips on Monday, product on Wednesday, people on Friday.
  3. Fill a month of topics, a week of posts. Topics are cheap; finished posts take time.
  4. Write the hook column first. See our hook examples.
  5. Check sizes and lengths. Our image size guide and caption length checker list each network's limits.
  6. Review weekly. Sort by status to see what's stuck, and by pillar to see what's missing.

From spreadsheet to scheduled

A spreadsheet plans the posts; someone still has to publish them. When copying rows into each app gets old, Postpane's content calendar does both: plan each post on a calendar, give each network its own caption, and it publishes at the time you set. Drag a post to another day to reschedule it.

Frequently asked questions

How do I open the template in Google Sheets?

Download the CSV, then in Google Sheets choose File, Import, Upload and pick the file. It opens with the columns and the sample week; delete the sample rows when you start.

Does it work in Excel or Numbers?

Yes. A CSV opens in Excel, Numbers and any spreadsheet app. Save it in that app's own format once you start editing, so formatting sticks.

How far ahead should I plan?

A month of topics and a week or two of finished posts is a sensible rhythm: far enough to stay ahead, close enough to react to news.

What's the difference between a content calendar and a scheduler?

A calendar is the plan: what goes out, where and when. A scheduler publishes it at that time. A spreadsheet does the first; a tool like Postpane does both on one calendar.

free social media content calendar templatesocial media content calendar templatecontent calendar template
Ijlal Nasir

Founder of Postpane. Writes about scheduling, posting across networks and keeping a small team consistent. Questions or corrections: hello@postpane.com