Est. 2025

Practical writing on work, money, home and life

Better Writing SkillsBetter Writing Skills.

Where good writers get read

A Simple Content Calendar for Small Teams

A one-spreadsheet content calendar for a team of three: a rhythm worked out from hours, nine columns, stage deadlines and short regular reviews.

Wall planner covered with colourful sticky notes

You’re one of three people on the marketing team at a local accounting firm. The blog gets a post when somebody remembers, the newsletter goes out late twice a quarter, and every Friday someone asks what’s being published next week and nobody knows. A content calendar fixes that with a shared page, a few rules and a short weekly check. This guide covers how to build one for a small team: the rhythm to choose, the columns to track, how to plan backwards from the publish date, and how to keep it alive after the first month.

What a content calendar is for

A content calendar is a planning tool, not a publishing tool. Michigan State University’s communications office explains in its guide to editorial calendars that the calendar helps you plan posts on all your platforms and track the progress of content through production. It also helps you combine posts with your unit’s other content so you can repurpose material efficiently.

That list shows what the calendar needs to hold: not only publish dates, but the in-house deadlines behind them. MSU’s list of items to include covers events, production dates (in-house deadlines for creating content), publications and mailings, website updates, email campaigns and social content. A calendar with only publish dates tells you what is late once it is already late.

Cost doesn’t need to be a barrier. The same MSU page says you could use a shared Outlook or Google calendar, or build the calendar in an Excel spreadsheet. For a team of three, a single spreadsheet is the sensible starting point.

Choose a rhythm the team can keep

Publishing frequency should come from capacity, not ambition. Work it out from hours.

Example (illustrative figures): three people each have 4 hours a week for content, giving 12 hours. A typical article takes 2 hours to outline and research, 3 hours to draft, 1.5 hours to edit, 1 hour to get approval and format, and 0.5 hours to publish and share. That adds up to 8 hours. So 12 hours supports one article a week with 4 hours left over for the newsletter, repurposing, or the unexpected. Promising two articles a week would need 16 hours and would collapse by week three.

Write the rhythm at the top of the calendar (“one article a week, one newsletter a month”) so everyone can see what has been agreed. When the rhythm slips, change the number, not the effort. Kent State University’s communications team notes in its piece on content planning that units may plan once a day or once a month depending on team size and available content. There is no correct frequency, only one the team can sustain.

The columns every content calendar needs

Keep the sheet narrow. Every extra column is something someone has to update. These nine cover most small-team needs.

ColumnWhat goes in itWhy it matters
Working titleA plain description of the topicHeadlines can change, ideas shouldn’t get lost
ThemeOne of three or four agreed topicsKeeps the mix balanced
ReaderWho it is for, in a few wordsStops generic topics sneaking in
OwnerOne named personShared ownership means no ownership
StatusIdea, outlined, drafting, editing, approved, scheduled, publishedShows bottlenecks at a glance
Draft dueA dateThe deadline that protects the publish date
Publish dateA dateThe fixed point
ChannelBlog, newsletter, social, otherLets one idea feed several channels
LinkThe draft, then the live URLOne place to find everything

Plan backwards from the publish date

Start from the day the piece goes live and count back. Putting each stage in the calendar as its own date moves deadlines out of people’s heads. MSU’s guidance on production dates makes the same point: the in-house deadlines belong on the calendar.

StageDays before publishWho
Outline agreed14Owner and editor
First draft in10Owner
Edit finished6Editor
Approval3Whoever signs off
Formatted and scheduled1Owner
Published and shared0Owner

Adjust the gaps to your team’s pace. The point is that approval has a date before the publish date. When approvals regularly arrive late, move that line earlier, not the publish date later.

Use two layers: themes and a bank of ideas

The GovTech article 3 Methods for Meeting Government Social Media Goals (2017) describes two approaches to calendars. One is a general theme calendar that identifies the months, days and weeks of important content. The other is a more involved calendar with a bank of actual posts to pull from. Small teams can use both.

Layer one: themes by month

Choose three or four themes that match what your audience cares about, and give each a rough share of your slots. The accounting firm might use tax deadlines, small-business bookkeeping, hiring and payroll, and client questions. Put the seasonal pieces in first, since deadlines in your field won’t move.

Layer two: a bank of ideas

Keep a second tab where anyone can add an idea in one line. Each month, move the best three or four into the main calendar and give them an owner. The bank makes empty weeks easy to fill without a scramble.

Reserve a slot for the unexpected

Plan one slot a month for something that comes up: a news item, a client question, a change in the law. Leaving it open stops the plan from breaking the first time something changes. The Kent State piece also makes a point in the other direction, saying the calendar is a good reminder to reschedule a post that could undermine upcoming crisis communications.

Keep the calendar alive with short, regular reviews

Most calendars die because nobody opens them. The GovTech article says that with either calendar method it is important to meet with your team and review it regularly. MSU suggests thinking of the editorial calendar as a living document and building update time into your workflow, whether that’s weekly, monthly or quarterly.

For a three-person team, two fixed habits work:

  • A 15-minute weekly check. Look at what is due in the next two weeks, move anything stuck, and confirm owners.
  • A monthly review of 30 to 45 minutes. Look at what was published, what slipped, which ideas to promote from the bank, and what to change in the rhythm.

A calendar earns its place by what it shows you early, not by how neat it looks.

Reuse and refresh what already works

New content doesn’t always mean new pages. Add a recurring row each quarter for updating your best-performing pieces, and use the calendar to record when each page was last reviewed. GOV.UK’s guidance on managing existing content says to monitor your content regularly to check it is useful and findable, and to fix issues such as broken links, typos or factual errors. It also describes review dates that editors set, which show when content is overdue for a check.

When you refresh a post, change the content, not just the date. Google’s guidance on helpful, people-first content includes the question of whether you are changing the date of pages to make them seem fresh when the content has not substantially changed. Record what you updated in a comment on the row’s Link cell so the change is real and visible.

Mistakes that kill a content calendar

Too many columns. A fifteen-column sheet gets abandoned. Start with the nine above.

No owner. A row marked “marketing” gets done by nobody.

Planning three months of detail. Plan themes three months ahead and detail two to four weeks ahead. Detailed plans for later months are usually rewritten.

Treating the calendar as a promise. It is a plan. When a piece slips, change the date in the sheet that day, so the sheet stays true.

Ignoring other teams’ dates. Add product launches, events and holidays at the start. Kent State describes its calendar as a way of noting events the organisation wants to highlight.

A starter checklist

  • Rhythm written at the top, calculated from real hours
  • Three or four themes agreed
  • Nine columns set up, with one named owner per row
  • Each piece has dates for outline, draft, edit, approval and publish
  • Fixed dates added: events, launches, seasonal deadlines, holidays
  • A second tab for ideas, with a one-line limit per idea
  • One open slot a month for something unplanned
  • A 15-minute weekly check and a monthly review in everyone’s diary
  • A quarterly row to refresh the best-performing pieces

The takeaway

A content calendar for a small team can be one spreadsheet, a rhythm worked out from real hours and a handful of columns. Put every stage deadline on it, keep a bank of ideas for gaps, and hold a short review each week and a longer one each month. Update it the day plans change, and refresh old pieces on purpose rather than starting from nothing.

Editorial Team Avatar

About the author

The Sunday Letter

One useful read, every Sunday.

A short note from the editors with the week’s most practical article. No hype, no daily blasts.

Sign-ups are handled through our contact page for now.