---
title: "Social Media Content Calendar Template and a 7-Step Plan"
description: "Free social media content calendar template for Google Sheets or Excel, plus 7 steps: pick themes, set posts a week, mark key dates, write and schedule."
url: "https://postnext.io/guides/how-to-create-a-social-media-content-calendar"
language: "en-GB"
---

# How to create a social media content calendar

Free social media content calendar template for Google Sheets or Excel, plus 7 steps: pick themes, set posts a week, mark key dates, write and schedule.

Human version: [https://postnext.io/guides/how-to-create-a-social-media-content-calendar](https://postnext.io/guides/how-to-create-a-social-media-content-calendar)

A month of posts planned by theme, written in batches and scheduled in one calendar.

[Start your 7-day free trial](https://postnext.io/signup?plan=free&source=guides-hero)

**Your checklist**7 steps · 60 minutes

0 of 7 done

1. Choose 3 to 5 themes
2. Set posts a week for each network
3. Mark the key dates
4. Give each posting day a theme and one idea
5. Write one week in one sitting
6. Tag each post with its theme
7. Schedule the week and look at the month

**You finish with**

A month calendar with a theme and an idea on every posting day, and the first week scheduled.

**Have ready**

- Your posting schedule: posts a week for each network
- The dates of this month's launches, sales and events
- Photos and videos you already have

To create a social media content calendar, choose 3 to 5 themes and decide how many posts each network gets a week. Mark the key dates of the month, then give each posting day a theme and one idea. Write the posts in weekly batches and schedule them, so the calendar shows what publishes each day.

## Your month calendar in 7 steps

1. 1
   **Choose 3 to 5 themes**
   Pick the topics you post about again and again, for example new products, behind the scenes, customers and tips. These are your [content pillars](https://postnext.io/learn/what-is-a-content-pillar).
   10 min
   **Done when:** You have 3 to 5 themes, one line each.
2. 2
   **Set posts a week for each network**
   Write how many posts each network gets a week. The [posting schedule guide](https://postnext.io/guides/social-media-posting-schedule) has a template for it.
   5 min
   **Done when:** Each network in the template has a number.
3. 3
   **Mark the key dates**
   Add the launches, sales, events, holidays and shipping deadlines of the month. Plan the posts for these dates before anything else.
   5 min
   **Done when:** Every key date of the month is in the template.
4. 4
   **Give each posting day a theme and one idea**
   Rotate the themes, so no theme takes a whole week unless a key date needs it. One line per idea is enough for now.
   15 min
   **Done when:** No posting day in the month is empty.
5. 5
   **Write one week in one sitting**
   Write the posts for one week and make their images and videos on the same day. Save each one as a draft. Drafts do not count against your monthly posts.
   PostNext: Calendar > Create post 30 min a week
   **Done when:** The Drafts tab holds a week of posts.
6. 6
   **Tag each post with its theme**
   Add a tag with the theme or campaign name. Then filter the calendar by tag to see if one theme takes too many days.
   PostNext: Calendar, tag filter5 min
   **Done when:** Every post has a theme tag.
7. 7
   **Schedule the week and look at the month**
   Schedule each draft. Open the Calendar view to see the whole month. Drag a post to a new date if two posts sit on the same day.
   PostNext: Calendar > Calendar view 10 min
   **Done when:** The month view shows this week's posts on their dates.

## Month calendar template

Copy the template, then fill one line per posting day. The themes and dates in it are examples.

**Content calendar: \[month\]**

```
Themes: 1 [New pieces]  2 [How we make it]  3 [Customers]  4 [Tips]
Posts a week: Instagram [3]  TikTok [2]  LinkedIn [1]
Key dates: [date] [sale]  [date] [launch]  [date] [holiday]

Week 1 ([dates])  Focus: [key date or theme]
  Mon  [Instagram]  Theme [1]  Idea: [one line]
  Wed  [TikTok]     Theme [2]  Idea: [one line]
  Fri  [Instagram]  Theme [3]  Idea: [one line]

Week 2 ([dates])  Focus: [ ]
  Mon  [ ]  Theme [ ]  Idea: [ ]
  Wed  [ ]  Theme [ ]  Idea: [ ]
  Fri  [ ]  Theme [ ]  Idea: [ ]

Week 3 ([dates])  Focus: [ ]
Week 4 ([dates])  Focus: [ ]

Write day for each week: [Monday]
Review day: [last Friday of the month]
```

## Content calendar template for Google Sheets or Excel

Copy the sheet and paste it into cell A1 of a new Google Sheet or Excel file. Each value lands in its own column. Add one row per post and change the Status as you go: Idea, Written, Scheduled.

**Content calendar template (spreadsheet)**

```
Date	Time	Channels	Format	Theme	Text	Media link	Status
[2026-12-01]	09:00	Instagram	Post	New pieces	[Your caption]	[https://link-to-your-image.jpg]	Idea
[2026-12-02]	19:00	TikTok	Video	How we make it	[Your caption]	[https://link-to-your-video.mp4]	Idea
[2026-12-03]	08:30	LinkedIn	Post	Customers	[Your post text]		Idea
[2026-12-04]	12:00	X	Post	Tips	[Your post text]		Idea
```

PostNext can import posts from a CSV file, up to 100 rows at a time. Each row holds the text, the channels, an optional date and one optional media link. A row with a date is scheduled, and a row without one becomes a draft. Before you import, delete the Format, Theme and Status columns, save the sheet as CSV and check the column names on the import screen.

## Themes by type of business

| Business | Theme 1 | Theme 2 | Theme 3 | Theme 4 |
| --- | --- | --- | --- | --- |
| Shop | New products | How we make it | Customer photos | Gift ideas |
| Cafe or restaurant | Today's menu | The kitchen at work | Regular guests | Events and opening hours |
| Studio or freelancer | Finished work | Before and after | Client stories | Tips from your job |
| Small agency | Client results | How we work | Team | Advice for your clients' field |

- New products Sea salt and lemon, in one candle. In the shop this Friday.
- How we make it One candle, start to finish, in 30 seconds. Pour, set, wick, label.
- Customers Ana sent us this photo of her jug on a summer table. Thank you, Ana.
- Gift ideas Gifts under $50, all made by hand. Swipe to see 5 ideas.
- Key date Last day to order for delivery before the holidays: 18 December.

The prices and numbers are examples. Use your own.

## An example week

| Day | Network | Theme | Post |
| --- | --- | --- | --- |
| Monday | Instagram | New products | Reel: the new candle, lit, by the sea |
| Tuesday | LinkedIn | How we make it | Why we pour 20 candles a week and not 200, with 3 photos |
| Wednesday | TikTok | How we make it | 30 seconds of pouring wax |
| Thursday | Instagram | Customers | Carousel of customer photos, shared with their consent |
| Friday | X, Threads, Bluesky | Gift ideas | The weekend gift list in one short post |

[**How to post to all social media at once***One post on X, Threads and Bluesky, with each network's limits.*](https://postnext.io/guides/how-to-post-to-all-social-media-at-once)

## Spreadsheet or scheduler

**Spreadsheet**

Good for ideas. It cannot publish a post. You copy each post into each network by hand.

**Scheduler**

Holds the finished posts and publishes them. In PostNext, the calendar has List, Grid and Calendar views, and tabs for Drafts, Approvals, Scheduled, Published and Failed.

**Both**

Plan ideas in a spreadsheet, then import up to 100 posts at once from a CSV file. Rows with a date are scheduled, rows without one become drafts.

On paid plans, a [content plan](https://postnext.io/planners) writes an AI posting plan for one channel over the dates you choose. It uses your [brand profile](https://postnext.io/features/brand-profile). Read every draft before it publishes.

[**AI content plans***A posting plan for one channel over the dates you pick, on paid plans.*](https://postnext.io/features/content-strategy)

## Mistakes to avoid

**Do**

- Plan the key dates first
- Keep 3 to 5 themes and rotate them
- Write a week at a time, a week ahead
- Leave one free slot a week for news

**Avoid**

- Planning more posts than you can make
- A whole month on one theme
- Writing the full month on day one, then changing half of it
- Customer photos without their consent

Updated 19 November 2026 by the PostNext team

[Next guide · 7 steps · 40 minutes **Social media plan template** One page: a goal with a number, 3 pillars, posts a week and who does what.](https://postnext.io/guides/social-media-plan-template)

## Common questions

**What should a content calendar include?**

For each post: the date and time, the network, the theme, the text and the image or video. Add key dates such as launches and sales.

**How far ahead should I plan?**

Plan the ideas a month ahead, and finish the posts one or two weeks ahead. News and trends can still publish on the same day.

**Should I use a spreadsheet or a tool?**

A spreadsheet works for ideas. A scheduler like PostNext holds the finished posts and publishes them at the right time. You can import a CSV of up to 100 posts.

**What is a content pillar?**

A theme you post about again and again, such as tips or behind the scenes. Most calendars use 3 to 5. [Read more](https://postnext.io/learn/what-is-a-content-pillar).

**Can I export the PostNext calendar?**

No. PostNext has no CSV, PDF or iCal export of the calendar. You can share a read-only preview link of a single post.

**Can my team approve posts before they publish?**

Yes, on the Teams plan. A teammate approves the post or asks for changes. Approved posts go back to drafts, ready to schedule.

## Do this week's posts in one sitting

Connect your channels, write each post once and PostNext publishes it at the time you pick.

[Start your 7-day free trial](https://postnext.io/signup?plan=free&source=guides-guide-close)

The trial asks for a card. Cancel before it ends and you pay nothing.
