How to create a social media content calendar

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

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.

    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 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 post30 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 view10 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

BusinessTheme 1Theme 2Theme 3Theme 4
ShopNew productsHow we make itCustomer photosGift ideas
Cafe or restaurantToday's menuThe kitchen at workRegular guestsEvents and opening hours
Studio or freelancerFinished workBefore and afterClient storiesTips from your job
Small agencyClient resultsHow we workTeamAdvice for your clients' field
  • New productsSea salt and lemon, in one candle. In the shop this Friday.
  • How we make itOne candle, start to finish, in 30 seconds. Pour, set, wick, label.
  • CustomersAna sent us this photo of her jug on a summer table. Thank you, Ana.
  • Gift ideasGifts under $50, all made by hand. Swipe to see 5 ideas.
  • Key dateLast day to order for delivery before the holidays: 18 December.

The prices and numbers are examples. Use your own.

An example week

DayNetworkThemePost
MondayInstagramNew productsReel: the new candle, lit, by the sea
TuesdayLinkedInHow we make itWhy we pour 20 candles a week and not 200, with 3 photos
WednesdayTikTokHow we make it30 seconds of pouring wax
ThursdayInstagramCustomersCarousel of customer photos, shared with their consent
FridayX, Threads, BlueskyGift ideasThe weekend gift list in one short post
How to post to all social media at onceOne post on X, Threads and Bluesky, with each network's limits.

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 writes an AI posting plan for one channel over the dates you choose. It uses your brand profile. Read every draft before it publishes.

AI content plansA posting plan for one channel over the dates you pick, on paid plans.

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  by the PostNext team

Next guide · 7 steps · 40 minutesSocial media plan templateOne page: a goal with a number, 3 pillars, posts a week and who does what.

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.

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.

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