Content calendar Excel - Free Template

1. Open the Instructions sheet first. It explains the editable planning fields, calculated columns, approval workflow and the role of each worksheet.
2. Go to Content Calendar and add one content item per row. Keep each Content ID unique, then enter the publish date, channel, content pillar, format, campaign, title, audience, location, owner and status.
3. Complete the workflow fields for CTA, Draft / Asset Link, Approval Status and Notes. Use the dropdowns rather than typing alternative spellings, so Dashboard summaries continue to match the source data.
4. Enter planned reach, actual reach, engagements, leads or conversions, planned budget and actual spend when those figures are available. Leave calculated columns alone.
5. Check the calculated Day, Engagement Rate, Variance and Performance Flag columns. For example, 1,320 engagements divided by 18,400 actual reach gives an engagement rate of approximately 7.17%.
6. Open Dashboard and set the reporting start and end dates in the reporting period controls. Select a channel in the owner lookup field if you need to view its default owner.
7. Review the management metrics, summaries and charts, then maintain the Lists sheet when your available channels, owners, formats, statuses or locations change.

Small marketing teams and agencies

A small business marketing manager can use the Content Calendar sheet to coordinate a week of LinkedIn, Instagram and Facebook activity without maintaining separate lists. For example, the sample rows schedule an article for LinkedIn on 05/10/2026, a carousel for Instagram on 06/10/2026 and a video for Facebook on 07/10/2026.

Each row gives the team more than a publishing date. The fields for Content Pillar, Format, Campaign, Content Title, Target Audience, UK Region / Location, Owner and CTA connect the editorial idea with its intended audience and action. A campaign such as Autumn Planning can therefore contain a checklist article aimed at SME directors and founders in London, rather than an unassigned headline in a separate document.

Owners working across several channels

Content leads can allocate work to named owners such as Amelia, Sophie, Harry, Oliver, Grace or Emily. The Lists sheet pairs channels with default owners, while the Dashboard channel lookup uses VLOOKUP to return the selected channel's owner. This is useful when a weekly meeting covers several channels but responsibility must remain visible.

The prepared calendar has rows 4 to 103 available for entries. A team publishing 12 items each month could use the same workbook for more than eight months before needing to extend the prepared range; that is a planning example, not a promise about future capacity. Keep one content item per row so filters and summaries can distinguish a campaign article from its supporting social post.

Regional and audience-led planning

The UK Region / Location field supports entries such as London, Manchester, Birmingham, Leeds and Bristol. A regional business could therefore separate a Manchester founder story from a London cash-flow article, while Target Audience records whether the intended reader is a local business owner, small business owner or SME director.

Use Approval Status alongside Status when several people review content. The available approval choices include Not Started, Awaiting Approval, Approved and Rejected, allowing a Friday planning review to identify items that are drafted but not ready for publication.

Input fields and controlled choices

Most planning and reporting fields sit on Content Calendar. You enter values such as Publish Date, Channel, Content Pillar, Format, Campaign, Owner, Status, Actual Reach, Engagements, Leads / Conversions, Planned Budget (£) and Actual Spend (£). Seven dropdown validations use the Lists sheet for Channel, Content Pillar, Format, Owner, Status, Approval Status and UK Region / Location.

This is a deliberate control: selecting LinkedIn from a list is safer than entering LinkedIn, Linkedin and Linked In as three separate labels. The Dashboard uses COUNTIF and SUMIF summaries, so inconsistent wording would split one channel across several results.

Calculated columns

Day copies the Publish Date when a Content ID and date are present. Engagement Rate uses Engagements divided by Actual Reach; if Actual Reach is zero, the formula avoids division by zero and returns 0 in the prepared calculation. For the sample LinkedIn item, 1,320 engagements divided by 18,400 actual reach equals about 7.17%.

Variance is calculated as Actual Spend less Planned Budget. The sample item has a planned budget of £450.00 and actual spend of £430.00, producing a variance of -£20.00. Performance Flag returns Awaiting data when Actual Reach is zero; otherwise it returns Strong when the engagement rate reaches 5% or more, or Review when it does not.

Dashboard checks

Dashboard reporting dates control the count of planned posts in the selected period. Other metrics use the prepared calendar range, including published posts, average engagement rate, planned reach, actual reach, total leads, planned budget, actual spend and approved content percentage.

Four charts draw on channel posts, status posts, channel actual reach and the calendar's planned and actual reach series. Use the reporting dates as a review control, but remember that the Instructions sheet states that charts use the full prepared calendar range.

One idea becomes several incomplete rows

A common workflow failure is creating a row with a title and date but leaving the owner, status, approval status and CTA blank. The item may appear in a publishing list, yet a reviewer cannot tell who is responsible, whether it has passed internal review or what action the audience should take.

For example, three rows for one campaign with only titles entered may count as three planned posts on the Dashboard, even though none has a usable asset link or confirmed approval. That inflates the apparent workload and makes a weekly review less reliable.

Labels drift and summaries fragment

Typing alternatives to the Lists values can undermine the summaries. If one person enters Insta instead of Instagram, or writes In review instead of In Review, COUNTIF may treat those records separately from the standard category. With 12 posts split between two spellings, the channel or status summary can show two smaller groups rather than one accurate total.

The technical judgement is clear: use the seven validated dropdown fields whenever they are available, and update Lists rather than inventing a new spelling in the calendar. Keep Content IDs unique as instructed; duplicated IDs make it harder to trace an asset, approval decision or performance result back to one item.

Performance figures are added at the wrong stage

Entering 0 for Actual Reach before a post has run is different from entering a measured zero after publication. The Engagement Rate formula protects against division by zero, but a zero reach value produces a rate of 0 and the Performance Flag remains Awaiting data. That distinction matters when a planned Facebook video has 9,000 planned reach but no actual reach yet.

Budget errors can also hide in sign conventions. If planned budget is £450.00 and actual spend is £430.00, the calculated variance is -£20.00. Entering actual spend as a negative number would reverse the meaning of the calculation, so record spend as a positive pound amount and let the workbook calculate the difference.

Use a fixed planning rhythm

Choose one regular planning slot for new rows and one reporting slot for results. A practical example is to plan the next four weeks on the first working day of a month, then update reach, engagements, leads, budget and spend during a Friday review. Four weekly reviews create four opportunities to correct an owner, approval status or missing asset link before the next publishing cycle.

Start each meeting on Content Calendar, not Dashboard. The source row contains the operational detail: a post such as CC-2026-001 has a date, LinkedIn channel, Autumn Planning campaign, CTA, asset link and performance inputs. Once those fields are reliable, the Dashboard becomes a useful summary rather than a substitute for missing information.

Keep the lists and review rules stable

• Maintain the Lists sheet when you add a channel, owner, format, status or location, and use the existing wording in calendar entries.
• Set reporting dates before reviewing monthly figures, while remembering that the charts use the full prepared calendar range.
• Enter actual performance after publication rather than guessing it from planned reach.
• Use Approval Status for the internal review step and Status for the item's production or publication stage.

Copying old rows may be convenient, but do not carry forward the previous Content ID, asset link, approval status or performance figures without checking them. A stronger routine is to create a new unique ID, confirm the date and campaign, then review each controlled field from its dropdown.

Know when the workbook is no longer enough

This workbook suits a prepared range of 100 calendar rows and a team that can maintain one source sheet. Consider a dedicated content management or marketing platform when many people need simultaneous workflow permissions, automated publishing, audit history, recurring approvals or substantially more than 100 prepared entries.

Until that point, the fixed routine is simple: plan rows, validate ownership and approval, add performance figures, check the calculated outputs and review the Dashboard. That sequence turns a static calendar into a repeatable editorial control.