Decide what the month is for before you fill a single day. One to three goals you can check, a theme for each week with the one post that has to land, and a pillar mix that adds up to the posts you can make.
The Google Sheets copy goes to your own Drive with every dropdown, color and formula working. No sign-up, no email.
January16 posts, 4 weeks
Example data
Inquiries by DM or email
3→to6
Accounts reached
12,400→to15,000
Saves per carousel
38→to50
Week 1Jan 4
New year brand check
Key post: 5 signs your brand has outgrown its logo (carousel)
4 posts
Week 2Jan 11
Before and after
Key post: Bakery rebrand: what changed after launch
February slots open
4 posts
Week 3Jan 18
Pricing in the open
Key post: What a $500 and a $5,000 logo include
4 posts
Week 4Jan 25
Booking February
Key post: Client story with a booking link
Last 2 slots
4 posts
Pillar mix
Process5
Client results3
Teach5
Behind the scenes1
Offer2
Inside the file
Four sheets, one month.
Weekly themes holds the plan itself. Goals says what the posts are for, Pillar mix says how many each theme gets, and Review is ten minutes at the end of the month before you plan the next one. Open each sheet below to see exactly what you download.
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.
A
B
C
D
E
F
G
H
1
Week
Starts
Theme
Key post
Supporting posts
Platforms
Posts
Launch or offer
2
1
Jan 4, 2027
New year brand check
5 signs your brand has outgrown its logo (carousel)
Kickoff question story, a Monday in the studio
Instagram, LinkedIn
4
3
2
Jan 11, 2027
Before and after
Bakery rebrand: what changed after launch
Sketch to final, why I present 2 concepts
Instagram, LinkedIn, TikTok
4
February slots open
4
3
Jan 18, 2027
Pricing in the open
What a $500 and a $5,000 logo include
The kickoff email, a poll on budgets
Instagram, LinkedIn
4
5
4
Jan 25, 2027
Booking February
Client story with a booking link
FAQ carousel, a last-call story
Instagram, LinkedIn, TikTok
4
Last 2 slots
6
7
8
Example rows from a made-up freelance designer. Overwrite them with yours.Purple values are formulasSwipe the sheet sideways to see every column.
How to use it
Plan the month in one sitting.
1
Pick one to three goals for the month on the Goals sheet, each with a number you can find in your analytics.
2
Type how many posts you can make this month on Pillar mix. It splits them across your pillars.
3
Give each week a theme and one key post on Weekly themes. The rest of the week supports it.
4
At the end of the month, fill in the Review sheet before you plan the next one.
Next: the calendar
Each week’s key post and supporting posts become rows in the content calendar template, with a date, a platform, a format and a status.
A spreadsheet for deciding what a month of posts is for before you schedule any of them. This one has four sheets: the month's goals with a start number and a target, a theme and one key post for each week, how many posts each content pillar gets, and a short review to fill in at the end of the month.
What should a social media content plan include?
One to three goals you can check in your analytics, the themes for each week, the one post each week that has to land, the platforms and how many posts you can actually make, any launch or offer that month, and a review of what worked. Dates and captions for each post belong in the content calendar.
How many posts should I plan for a month?
Plan the number you can make every month without skipping weeks, not the number you hope for. Type it on the Pillar mix sheet and the template splits it across your pillars by the share you give each one, so the posts always add up to the total.
How do I use the content plan in Google Sheets?
Click Copy to Google Sheets, sign in to Google if asked, and choose Make a copy. The copy goes to your own Drive with the four sheets, the pillar formulas and the goal change column working. The Excel file has the same sheets and also opens in Numbers and LibreOffice.
Can I import the plan into Notion or Airtable?
Yes, the Weekly themes sheet. Download the CSV and import it: in Notion, go to Settings, then Import, then CSV, or type /csv on a page. Each week becomes a row named after its theme, with the week, start date, key post, supporting posts, platforms, post count and offer as properties.
Do I need a content plan and a content calendar?
They answer different questions. The plan decides what the month is for and runs once a month. The calendar decides what goes out on which day and runs every week. Make the plan first, then move each week's key post and supporting posts into the free content calendar template.