Skip to content

Free template

Content calendar template

A spreadsheet for one person posting on two or three platforms. Plan the week, keep every idea in one place, and record how each post did, so next month you know what to repeat.

Using Google Sheets? Upload the .xlsx to Google Drive and open it with Sheets. No sign-up, no email.

Week of Jan 11, 4 posts planned

Example data

Last week: 4 posted.Best: Instagram carousel at 7.3% by reach.

  1. Mon 11

    Carousel

    Bakery rebrand: what changed after launch

    ScheduledClient results
  2. Tue 12

    Carousel

    5 signs your brand has outgrown its logo

    ReadyTeach
  3. Wed 13

  4. Thu 14

    Story

    Two February project slots open

    DraftingOffer
  5. Fri 15

    Short video

    Why I present 2 concepts, not 5

    IdeaProcess

Inside the file

Three sheets, one habit.

Ideas go into the ideas bank as soon as you have them. Once a week the best ones move into the calendar. Your pillars keep the mix honest. Open each sheet below to see exactly what you download.

content-calendar-template.xlsx

One row per post: when, where, what, and how it did.

Content calendar template, Calendar sheet: One row per post: when, where, what, and how it did.
DateDayFills in from the datePlatformFormatPillarFrom your Pillars sheetTopic or hookCaption or script notesCall to actionAsset linkStatusPost linkReachInteractionsLikes, comments, shares, savesEngagement rateInteractions ÷ reach
Jan 4, 2027MonLinkedInText postTeachThe one brief question that saved a rebrandStory of the kickoff call, the question, what changed in the briefAsk: what do you ask first?Posted3,1201414.5%
Jan 5, 2027TueInstagramCarouselProcessLogo from sketch to final in 8 slidesOne slide per stage, a sentence on each decisionSave for your next projectPosted5,4804027.3%
Jan 7, 2027ThuInstagramReelBehind the scenesA real Monday in a one-person studioTime-lapse, three on-screen notes, no voiceoverFollow for the Friday onePosted9,1503884.2%
Jan 8, 2027FriTikTokShort videoTeach3 font pairings clients always approveHook in the first second: show the pairings, then whyComment your favoritePosted12,6007315.8%
Jan 11, 2027MonLinkedInCarouselClient resultsBakery rebrand: what changed after launchBefore and after, with the client's quote on the last slideDM 'audit' for a brand checkScheduled
Jan 12, 2027TueInstagramCarouselTeach5 signs your brand has outgrown its logoOne sign per slide, a fix in the captionShare with a founder friendReady
Jan 14, 2027ThuInstagramStoryOfferTwo February project slots openPoll first, then the booking link stickerBook a call (link)Drafting
Jan 15, 2027FriTikTokShort videoProcessWhy I present 2 concepts, not 5Talking head, one reason per cutFollow for more processIdea
Example rows from a made-up freelance designer. Overwrite them with yours.Purple values are formulasSwipe the sheet sideways to see every column.

Plan

When and where it goes out.

Date and day
The day fills in from the date, so you see gaps in the week at a glance.
Platform
A dropdown: Instagram, TikTok, LinkedIn, YouTube and four more.
Format
Reel, carousel, story, text post: the format decides how long it takes to make.
Pillar
Fed by your Pillars sheet, so every post belongs to a theme you chose.

Write

What it says before you open the app.

Topic or hook
The first line or the first second. If it is weak here, it is weak on the feed.
Caption or script notes
Enough to write it later without starting from zero.
Call to action
What you want people to do: save, comment, book, follow.
Asset link
Where the image, video or design file lives.

Track

How it did, so next month starts from evidence.

Status
Idea, drafting, ready, scheduled, posted, each with its own color.
Post link
The live post, for when you want to reuse or repost it.
Reach and interactions
Copied from your analytics a few days after posting.
Engagement rate
Interactions divided by reach, calculated for you. For other formulas, use the engagement rate calculator.

How to use it

Twenty minutes on a Monday.

  1. Write your 3 to 5 content pillars on the Pillars sheet. They fill the Pillar dropdown on the calendar.

  2. Keep every idea on the Ideas bank sheet the moment you have it: a comment, a question from a client, a post that did well.

  3. Each week, move the best ideas into the Calendar: a date, a platform, a format and a status.

  4. After posting, add the link, reach and interactions. The engagement rate fills itself in, so next month you know what to repeat.

Want a full walkthrough with examples? Read how to create a social media content calendar or browse weekly and monthly calendar examples.

Free template

Content plan template

The calendar says when each post goes out. The plan says what the month is for: one to three goals you can check, a theme for each week with one post that has to land, and how many posts each pillar gets. Plan the month here, then fill the calendar from it.

Using Google Sheets? Upload the .xlsx to Google Drive and open it with Sheets. No sign-up, no email.

content-plan-template.xlsx

One theme a week and the one post that has to land.

Content plan template, Weekly themes sheet: One theme a week and the one post that has to land.
WeekStartsThemeKey postSupporting postsPlatformsPostsLaunch or offer
1Jan 4, 2027New year brand check5 signs your brand has outgrown its logo (carousel)Kickoff question story, a Monday in the studioInstagram, LinkedIn4
2Jan 11, 2027Before and afterBakery rebrand: what changed after launchSketch to final, why I present 2 conceptsInstagram, LinkedIn, TikTok4February slots open
3Jan 18, 2027Pricing in the openWhat a $500 and a $5,000 logo includeThe kickoff email, a poll on budgetsInstagram, LinkedIn4
4Jan 25, 2027Booking FebruaryClient story with a booking linkFAQ carousel, a last-call storyInstagram, LinkedIn, TikTok4Last 2 slots
Example rows from a made-up freelance designer. Overwrite them with yours.Purple values are formulasSwipe the sheet sideways to see every column.

Step by step, with a worked month: how to make a social media content plan. Choosing your themes first? See content pillar examples.

FAQ

Questions about content calendars.

Is this content calendar template free?

Yes. Download the Excel file or the CSV and use it as you like. There is no sign-up and no email form.

How do I use the template in Google Sheets?

Upload the .xlsx file to Google Drive, then open it with Google Sheets, or open a blank sheet and use File, then Import. Check the dropdowns after the import; if one is missing, add it again with Data, then Data validation.

What should a social media content calendar include?

For each post: the date, the platform, the format, the content pillar, the topic or hook, caption notes, the call to action and a status. Add the results after posting (reach and interactions), because a calendar that records results tells you what to post next.

What is the difference between a content plan and a content calendar?

A content plan works at the level of the month: the goals, a theme for each week and how many posts each pillar gets. A content calendar works at the level of the post: what goes out on which day, where and in which format. Make the plan first, then fill the calendar from it. Both templates are on this page.

How far ahead should I plan my content?

For one person, a month of themes and one to two weeks of posts is a common rhythm. It keeps the week ready without locking you out of timely posts. Batch the writing on one day and leave one open slot a week for something that comes up.

Can I use it in Notion or Airtable?

Yes. Download the CSV and import it into a Notion database or an Airtable base. The columns come in as fields; set Platform, Format and Status as select fields to get the dropdowns back.

Your next post is one question away.

Alpine Reach finds posts that beat their creator’s usual results, turns them into ideas for your brand and drafts them in your voice.

7 days free, then $49.90 a month