Social Media Content Calendar Template
A social media content calendar template with a row for every post: date, network, format, caption, asset, owner and status. Pick the month, your networks and the days you post, and download a CSV that opens in Google Sheets and Excel.
- Format
- Opens in Google Sheets and Excel
- Privacy
- Built in your browser, nothing uploaded
Set up your social media content calendar
| Date | Day | Time | Network | Content pillar | Format | Topic | Caption | Asset link | Link | Owner | Status | Approved by | Notes |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2026-11-02 | Monday | ||||||||||||
| 2026-11-02 | Monday | ||||||||||||
| 2026-11-02 | Monday | ||||||||||||
| 2026-11-04 | Wednesday | ||||||||||||
| 2026-11-04 | Wednesday | ||||||||||||
| 2026-11-04 | Wednesday | ||||||||||||
| 2026-11-06 | Friday | ||||||||||||
| 2026-11-06 | Friday | ||||||||||||
| 2026-11-06 | Friday | ||||||||||||
| 2026-11-09 | Monday | ||||||||||||
| 2026-11-09 | Monday | ||||||||||||
| 2026-11-09 | Monday |
What goes in each column
The download has these columns in this order. Date, day and network are filled in from your choices; the rest are yours.
| Column | What goes in it | Example |
|---|---|---|
| Date | The day the post goes out, written as a date so the sheet can sort and filter it. | Filled in for you |
| Day | The weekday, so gaps and crowded days stand out at a glance. | Filled in for you |
| Time | When it publishes, in the time zone the account posts for. | 12:30 |
| Network | One network per row, so each version of a post has its own caption, format and status. | Filled in for you |
| Content pillar | The theme the post belongs to. Filter by it to check the month is balanced. | How-to |
| Format | What the network will show: an image, carousel, Reel, Story, video, text post, pin or article. | Carousel |
| Topic | The idea in a few words, written before the caption so the month can be reviewed quickly. | Three ways to wear one linen shirt |
| Caption | The final copy for this network, with its hashtags and mentions. | One shirt, three looks. Which is yours? |
| Asset link | A link to the image, video or design file, so nobody hunts through folders on the day. | Link to the design file |
| Link | Where the post sends people, with tracking parameters if you use them. | Product page address |
| Owner | The person writing and preparing the post. | Sam |
| Status | Idea, Drafting, In review, Approved, Scheduled or Published. Filter by it every morning. | In review |
| Approved by | Who signed the post off, for posts that need approval. | Alex, client |
| Notes | Anything the next person needs: a change request, a holiday, a product launch. | Swap the photo if new stock arrives |
How to use the content calendar template
Plan the month in one sitting, then work through it a row at a time.
- 1
Pick the month, networks and days
Choose the days you post on and the networks you post to. The template writes a row for every post, already dated and labelled with its network, so the month’s workload is visible before you write a word.
- 2
Open it in Google Sheets or Excel
In Google Sheets, choose File, then Import, and upload the CSV. In Excel, open the file directly. Freeze the top row and turn on filters so you can sort by date, network or status.
- 3
Fill in topics before captions
Write the topic and content pillar for every row first. Reviewing the month as a list of ideas is faster than reviewing finished captions, and it shows when one theme crowds out the rest.
- 4
Update the status every day
Move each row from Idea to Published as the work happens. Anything still in review two days before its date needs a nudge, and anything without an asset link needs a designer.
What a social media content calendar needs
A content calendar answers three questions for everyone who touches a post: what is going out, where, and who is responsible for it. Date, day, time and network say when and where. Pillar, format, topic, caption, asset and link say what. Owner, status and approval say who, and how far along it is.
Plan one row per post per network rather than one row per idea. The same announcement usually needs a square image and a short caption on Instagram, a longer post on LinkedIn and a vertical video on TikTok. Separate rows give each version its own caption, format and status, so a delay on one network does not hold up the others.
Content pillars keep the month balanced. Pick three to five themes your audience cares about, tag every row with one, and filter by pillar before you start writing. If most rows are product announcements, swap a few for how-to or behind the scenes posts before anything is drafted.
Agencies should keep one calendar per client. A shared sheet with a client column is harder to filter and harder to share safely, because sharing it with one client shares every client’s plans.
When the sheet gets busy, plan on a calendar that publishes
Posty keeps the same plan on a calendar that publishes. Posts sit on month, week and day views, drag to a new date to reschedule and go out to 10 networks without copying captions anywhere. Write a post once and adjust the caption for each network, and keep undated drafts in a backlog beside the calendar.
- Month, week and day views, with drag and drop rescheduling
- The same caption everywhere, or one written for each network
- Undated drafts wait in an unscheduled backlog
- Campaign colours and a campaign filter on the calendar
- Required approval before posts are scheduled, on Growth and Accelerate
Content calendar softwareScheduling for multiple clientsCompare plans and pricing
Mon
Tue
Wed
Thu
Fri
Questions about the social media content calendar template
- Does the content calendar template work in Google Sheets and Excel?
- Yes. The download is a CSV file, which both open, and so does Apple Numbers. In Google Sheets, choose File, then Import, then Upload. In Excel, open the file directly. Dates arrive as real dates, so sorting and filtering work straight away.
- How many posts a week should a content calendar plan?
- Start with a pace you can keep for a whole month. The template starts on Monday, Wednesday and Friday because three days a week leaves time to make each post properly, and you can tick any days you like. A calendar that runs dry in week two helps nobody.
- How do I plan content calendars for several clients?
- Download one file per client and name it after them. Separate files mean you can share a calendar for approval without showing anyone another client’s plans. Posty gives each client their own workspace for the same reason.
- Can I import this calendar into Posty?
- No. Posty does not import spreadsheets. Teams moving over usually finish the month they are in from the sheet and plan the next month on Posty’s calendar, where each post is written once and adjusted per network.
- Do I need an account to download the calendar?
- No account, nothing to pay. The file is built in your browser, and nothing you pick or type is sent to Posty.
More templates
Each one is built in your browser from your choices. See every template
- Content approval checklistWhat the writer checks before submitting, what reviewers sign off and the last look before scheduling, with checks for each network you post to.DOCX
- Social media campaign briefObjective, audience, message, deliverables for each network, timeline, budget and sign-off, agreed before any work starts.DOCX
- Monthly social media reportA metrics sheet that works out month on month change for each network, and a written report for the summary, top posts and next month’s plan.CSV
Plan next month on a calendar that publishes
Create a workspace, connect your networks and plan next month on a calendar that publishes each post for you.