Content calendar template
Plan every blog post, video and newsletter from idea to published. Every piece in one list, drawn on a six-month timeline from start to publish day, colored by status, with late drafts in red.
Open in Google Sheets · Download for Excel (XLSX). Free to use, no sign-up needed.
| Title | Author | Status | Publish |
|---|---|---|---|
| How to plan a product launch | Ana | Published | 6 Oct |
| Ten customer onboarding emails that work | Sam | In review | 13 Oct |
| Our year in numbers | Ana | Drafting | 20 Oct |
| Project kickoff checklist | Lee | Brief | 27 Oct |
| Customer story: a small agency | Sam | Idea | 3 Nov |
| Holiday planning guide | Lee | Idea | 24 Nov |
A content calendar template gives every piece of content a date, an owner and a status, so publishing stops depending on someone remembering. This free template works in Google Sheets and Excel: list each blog post, video, newsletter or case study, move it from idea to published, and see at a glance what is late, what is coming and where the gaps are.
Below: what a content calendar is, what to put in one, how to use this template, how to build a content calendar step by step, real content calendar examples for different kinds of business, and the workflow that keeps it moving.
What is a content calendar?
A content calendar is a schedule of the content you plan to publish, with the details needed to get each piece made: what it is, who is writing it, when the draft is due, when it goes out, and where it is now. It turns a content strategy into dated, owned work.
Three terms get used interchangeably, but they are worth telling apart:
| Content calendar | Editorial calendar | Social media calendar | |
|---|---|---|---|
| Covers | Everything you publish: articles, videos, newsletters, guides | Usually the same; the term comes from publishing and journalism | Posts on each social platform |
| Planned by | Piece, with a publish date and a deadline | Issue or piece, often with a theme | Day and platform |
| Detail tracked | Owner, status, keyword, format, topic | Owner, status, angle, theme | Caption, asset, platform, time |
| Horizon | Weeks to months | Weeks to a year | Days to weeks |
Most small teams need one content calendar for what they make, and a social media calendar for how they share it.
Why use a content calendar
- Consistency. Publishing on a steady schedule is easier when the next four weeks are already planned.
- Fewer last-minute scrambles. Deadlines for drafts, reviews and design are set back from the publish date, so nothing lands on the final day.
- Clear ownership. Every piece has a named author, so nobody wonders who is writing it.
- Balance. You can see if you are publishing too much on one topic, or too little for one audience.
- Coordination. Launches, promotions, newsletters and social posts line up around the same dates.
- A record of what worked. Over time the calendar becomes a log you can compare with results.
What to include in a content calendar template
| Column | Why it matters |
|---|---|
| Publish date | The date everything else is planned back from |
| Title or working title | What the piece is; it can change before publishing |
| Topic or content pillar | Keeps the mix balanced across the themes you want to be known for |
| Format | Blog post, guide, video, newsletter, case study, template: each needs different work |
| Main keyword | For search content, the phrase the piece is written to rank for |
| Author or owner | One named person responsible for getting it done |
| Draft due date | Usually a week or more before publishing, leaving time for review and design |
| Status | Where it is now: Idea, Brief, Drafting, In review, Scheduled, Published |
| Link | Where the draft lives, then where it was published |
| Notes | The angle, sources, the call to action, or what to promote it with |
Some teams add the target audience, the funnel stage (awareness, consideration, decision), the channels it will be shared on, or a column for results after publishing. Start with the columns above and add only what you will actually fill in.
How to use this content calendar template
- Open your copy. Click Open in Google Sheets at the top of this page and choose Make a copy, or download the Excel version.
- Set your lists. On the Lists tab, enter your topics (content pillars) and the formats you publish. The dropdowns on the Content tab read from these lists.
- Replace the examples. On the Content tab, overwrite or delete the five example pieces.
- Add each piece as a row: title, topic, format, main keyword, author and status, then three dates: when work starts, when the draft is due and when it publishes.
- Move it along. Change the status as the piece progresses: Idea, Brief, Drafting, In review, Scheduled, Published. Each status has its own color.
- Read the timeline. To the right of the list, each piece is drawn across the days from start to publish: purple while it is being written, amber for review and design, and a dark mark on publish day. Published pieces turn green and late drafts red. It shows 26 weeks; type a date or a number of weeks at the top to look further out.
- Watch for red. A draft due date that has passed turns red until the piece reaches review, so stalled drafts stand out.
- Check the overview. The Overview tab counts pieces at each stage and how many are planned for each month of the year you choose, so empty weeks show up early.
Use Data > Create a filter to see one author's pieces, one topic or one month at a time.
How to create a content calendar
A template gives you the structure. These steps fill it with a plan worth following.
1. Start with goals and audience
Write down what content is for (more search traffic, more leads, better retention) and who it is for. Every piece on the calendar should serve one of those goals for that audience. Our guide to content marketing strategies covers this in depth.
2. Choose three to five content pillars
Pillars are the broad topics you want to be known for, connected to what you sell. Put them in the Topic list. A balanced calendar rotates through them rather than covering whatever comes to mind.
3. Set a cadence you can keep
Decide how often you will publish each format, then fill the calendar to that rhythm. It is better to publish one good piece every two weeks for a year than three a week for a month.
| Team | A realistic starting cadence |
|---|---|
| One person, alongside other work | One in-depth piece a month, a short newsletter every two weeks |
| Small team with a part-time writer | One piece a week, a newsletter every week or two |
| Dedicated content team | Two to five pieces a week, plus updates to older content |
4. Fill a backlog of ideas
Collect more ideas than you need: questions customers ask, keywords people search for, topics competitors cover badly, lessons from your own work, seasonal moments. Add them with the status Idea and no date yet. When it is time to plan the month, pick the strongest ones.
5. Plan back from the publish date
Once a piece has a publish date, set its earlier deadlines from it. Typical lead times:
| Format | Brief agreed | Draft due | Review and design |
|---|---|---|---|
| Blog post | 2 to 3 weeks before | 1 week before | In the last week |
| In-depth guide or report | 4 to 6 weeks before | 2 to 3 weeks before | The last 2 weeks |
| Newsletter | 1 week before | 2 to 3 days before | The day before |
| Video | 3 to 4 weeks before | Script 2 weeks before | Edit in the last week |
| Case study | 4 to 6 weeks before (customer approval takes time) | 2 weeks before | The last week |
6. Give every piece an owner and a status
One name per piece, even if several people help. Then keep statuses honest: a piece is only In review when a draft actually exists. The statuses are what make the calendar a tool rather than a wish list.
7. Review it every month
Once a month, look back (what was published, what slipped, what performed) and ahead (are the next four to six weeks filled, balanced across pillars, and lined up with launches and seasonal dates?). Move ideas into dated slots, and drop what no longer fits.
Content calendar examples
What a month on the calendar might look like for five different kinds of business. Use them as starting points; your goals and audience should shape the real thing.
A software company blog
| Week | Piece | Format | Goal |
|---|---|---|---|
| 1 | How to choose a project management tool | Guide | Search traffic from buyers comparing options |
| 2 | Five workflows teams automate first | Blog post | Search traffic and product interest |
| 3 | Customer story: how a 12-person agency plans its week | Case study | Trust for people close to buying |
| 4 | Monthly product update | Newsletter | Retention and feature adoption |
An online store
| Week | Piece | Format | Goal |
|---|---|---|---|
| 1 | Buying guide: which size is right for you | Guide | Fewer returns, more confident buyers |
| 2 | How to care for it so it lasts | Video | Retention and repeat purchases |
| 3 | Gift ideas under $50 | Blog post | Seasonal search traffic |
| 4 | New arrivals and a customer favorite | Newsletter | Sales from existing customers |
A local service business
| Week | Piece | Format | Goal |
|---|---|---|---|
| 1 | How much does it cost? A plain guide to our prices | Blog post | Answer the first question every customer asks |
| 2 | Before and after: a recent job | Social post and short video | Proof of quality |
| 3 | Five signs it is time to call a professional | Blog post | Local search traffic |
| 4 | Seasonal checklist for homeowners | Guide and newsletter | Repeat business |
An agency or consultancy
| Week | Piece | Format | Goal |
|---|---|---|---|
| 1 | What we learned running 30 campaigns this year | Article | Expertise and point of view |
| 2 | Free template: a client reporting dashboard | Template | Links, sign-ups and leads |
| 3 | Webinar: planning next quarter | Webinar | Leads and relationships |
| 4 | Client story with results | Case study | Trust for buyers |
A creator or newsletter-led business
| Week | Piece | Format | Goal |
|---|---|---|---|
| 1 | Weekly issue: one big idea | Newsletter | Subscriber loyalty |
| 2 | The same idea as a short video | Video | Reach and new subscribers |
| 3 | Reader questions answered | Newsletter | Engagement and replies |
| 4 | Behind the scenes and what is coming | Newsletter and social | Community |
A content calendar workflow that keeps things moving
| Status | What it means | Usually owned by |
|---|---|---|
| Idea | A topic worth considering, not yet committed to | Anyone |
| Brief | Agreed angle, audience, keyword, key points and call to action | Editor or content lead |
| Drafting | Being written | Author |
| In review | Draft done; being checked for accuracy, clarity and fit with the brief | Editor, plus a subject expert if needed |
| Scheduled | Approved, designed and set to publish | Editor or publisher |
| Published | Live; now being promoted and measured | Author and marketing |
Hand-offs are where content stalls: a finished draft waits days for review, or a published piece never gets promoted. Agree who picks up each status, and how they will know it is their turn.
Content calendar tips
- Plan four to six weeks ahead, with a looser list of ideas beyond that.
- Leave some room. Keep one slot a month open for timely topics.
- Put fixed dates in first: launches, events, holidays and seasonal moments.
- Update old content too. Add refreshes of your best older pieces to the calendar like new work.
- Plan the promotion with the piece. Note in the calendar where each piece will be shared.
- Keep it in one place that everyone can see, not in someone's private notes.
Common content calendar mistakes
- Filling the calendar with dates but no owners. A date without a name rarely happens.
- Too ambitious a cadence. A calendar that slips every week gets abandoned.
- Only topics you want to write about, rather than what your audience is looking for.
- No buffer between draft and publish, so review and design get squeezed or skipped.
- Never looking back. Without a monthly review, the calendar repeats what did not work.
Spreadsheet or project management tool?
A spreadsheet content calendar is a great start: it is free, flexible and easy to share. It struggles when several people work from it, because a spreadsheet cannot tell the editor a draft is ready, remind an author of a deadline, or keep the draft, the files and the conversation with the piece.
In Flow, a content calendar becomes a project. Each piece is a task with an owner, a due date and its own statuses (Brief, Drafting, In review, Scheduled, Published), shown as a board, a list, a calendar or a Gantt chart. Recurring tasks create the work that repeats, such as the weekly newsletter. Automations handle hand-offs, such as giving a draft to the editor when it moves to In review, or creating the promotion tasks when it is published. A form can collect content requests from the rest of the company straight into the calendar. Drafts live in Docs and images in Drive, next to the work.
Frequently asked questions
What should a content calendar include?
At minimum: a publish date, a title, the topic or content pillar, the format, an owner, a draft due date and a status. Search content also benefits from a main keyword, and a link and notes column keep everything in one place.
How do I create a content calendar in Google Sheets?
Start from a template like this one, or make columns for publish date, title, topic, format, author, draft due date and status. Use Data > Data validation to turn topic, format and status into dropdowns, and conditional formatting to color statuses and highlight late drafts.
How far ahead should a content calendar be planned?
Most teams plan four to six weeks of dated pieces, with a backlog of ideas beyond that and fixed dates such as launches and holidays marked for the year. Planning further ahead in detail tends to go stale.
What is the difference between a content calendar and an editorial calendar?
In practice they are usually the same thing: a schedule of content with owners, deadlines and statuses. "Editorial calendar" comes from publishing and is sometimes used for a higher-level plan of themes, while "content calendar" often means the detailed schedule of individual pieces.
How often should I publish content?
As often as you can while keeping quality high and the schedule steady. One substantial piece every week or two suits most small teams. Consistency over months matters more than volume in any one week.
Is this content calendar template free?
Yes. It is free to use with no sign-up. Open it in Google Sheets to make your own copy, or download it for Excel.
Should content and social media be on the same calendar?
It is usually easier to keep them separate but linked: the content calendar for what you create, and a social media calendar for when and where you share it. Our free calendar templates include a social media calendar built for this.
What are some content calendar examples?
A software company might publish a guide, a how-to post, a customer story and a product newsletter each month; an online store a buying guide, a care video, a seasonal gift guide and a new-arrivals email. This page shows example months for five kinds of business.