Content Calendar Template: A Free Spreadsheet With a Filled Example

Publish date Channel Format Working title Pillar Source asset Goal metric Owner Status Draft due Live link Result

One filled row from the Sample tab (the example below; its days are assumptions):

What a content calendar is and how it differs from a social or editorial calendar

A content calendar is the one list of everything you plan to publish: one row per piece per channel, each with a date, an owner and a status. One person keeps it current, usually whoever runs marketing. Everyone who drafts, edits or publishes a piece works from the same sheet. The same rows can show as a Kanban board grouped by Status or as a timeline sorted by Publish date, and the data does not change.

People use three names for related sheets. The difference is what one row holds.

The American Marketing Association publishes its own version, a spreadsheet-based planner for organizing and scheduling content across multiple channels¹. A content calendar can hold the editorial and social rows too. For a small team, that means one sheet to keep current instead of three.

The template has 12 columns in three groups

Basics say what goes out and where. Strategy says why the row exists and who is responsible. Tracking shows where the row stands and what it earned.

Three column rules make the sheet usable after month one.

Give each channel its own row. A clip posted to both Instagram and YouTube Shorts takes two rows, because each platform reports its own results. Name one person as owner per row. «Marketing» is a department, and a department cannot miss a deadline. Track one goal metric per row, so the Result cell holds a single number you can line up against other rows.

The Status column is a drop-down list with five stages. A row moves one stage at a time, and a filter on Status shows what is blocked. To rebuild the list in Google Sheets, select the column and open Data validation from the Data menu². Dropdown in the Insert menu does the same job.

How to set up your content calendar in 7 steps

Each step has one outcome. Do them in order, because steps 4 to 6 read from steps 1 to 3.

1. Pick your pillars. Write 3–4 recurring topics in the Pillars & goals tab, each tied to something your buyers complain about or doubt. Outcome: every future row has a pillar to point to.
2. Name your source asset. This is the piece you already make every week: an episode, a long article, a product update. Outcome: you know what the rest of the week is cut from.
3. List your channels. Keep only the channels you can feed every week. Outcome: a short list for the Channel column.
4. Set the rhythm. Fill one week: the source asset on its day, then each clip, post or email cut from it on the days after. Copy the pattern across the month. Outcome: four weeks of dated rows.
5. Assign owners and draft dates. Put one name on each row and a Draft due date that leaves a day for review. Outcome: nobody learns about a post on publish day.
6. Fill the goal metric. Pick one metric per row that you can read after publishing: clicks for a blog post, replies for an email, sign-ups for anything with a link. Outcome: the Result column has a defined number to collect.
7. Review once a month and cut. Delete any column nobody filled since the last review. Rows still in «Drafting» on review day go back to Ideas. Outcome: the sheet stays as small as the work you do.

How we turn an idea check into calendar pillars

Our free idea check returns complaint themes, risks, competitors, unit economics and whether any demand data exists for the market. The calendar reads those fields with six rules.

1. Pillars come from evidence. Make one pillar per complaint theme the check found, ranked by complaint count. Add one pillar per risk the check rates impact 3. A pillar with no line in the check is cut.
2. One source asset sets the rhythm. Plan the week around the piece you already make. Every other row names its source asset.
3. The goal column is priced by the check’s unit economics (formulas below).
4. No demand source means the calendar is the demand test. When the check has no demand data, every row links to one sign-up page, and the Result column logs sign-ups.
5. Spread channels. When the check names a platform risk, no single channel carries all distribution.
6. Review monthly. Delete a column nobody filled since the last review. Rows still in «Drafting» on review day go back to Ideas.

The formulas behind rule 3 are three lines. Lifetime value (LTV) = price × purchases per month × margin × lifetime months. LTV/CAC = LTV ÷ customer acquisition cost (CAC). Payback in months = CAC ÷ (price × purchases per month × margin). A paid post is worth running while its cost per paying customer stays under the CAC the model allows. If one sign-up in ten pays (assumption), the ceiling per sign-up is CAC ÷ 10. We add no constants of our own: the unit-economics inputs come from the check, and the check marks them as a category estimate.

Example launch calendar for a sermon-podcast repurposing service

This section fills every column for one idea. The idea, an example by our method, is an «AI content repurposing service for church sermon podcasts in Dallas–Fort Worth: pastors paying monthly to turn each Sunday episode into clips, blogs and newsletters»^ex. The check returned the verdict «Possible, with caveats»^ex with a score of 60^ex, built from 17 search queries^ex and 23 sources^ex (example by our method). The check produced no calendar. The rows below are the founder’s own launch calendar for marketing the service to pastors, built from the check’s fields with the six rules.

Variants for blog, social, newsletter and podcast calendars

The 12 columns cover a mixed calendar. A single-channel calendar adds the fields that channel needs and drops the ones it does not.

Every variant keeps the Pillar, Owner, Status and Result columns, so you can compare a blog month with a newsletter month. A social calendar uses the same five Status stages, and Scheduled means the post is queued on the platform.

Spreadsheet or app, and other free templates

A spreadsheet lets you filter rows, add drop-down lists and share the sheet, and the same file opens in Excel or Google Sheets. An app adds saved views (board, calendar, timeline), automations and assignments with notifications. Choose a sheet if one to three people (assumption) edit the calendar and you want a file you own. Choose an app if you already plan other work in that app and want status changes to notify people.

Common content calendar mistakes

Start with the Pillars & goals tab

Fill the Pillars & goals tab before any dated row, because every row points to a pillar and its goal metric. The .xlsx comes with a free sign-up, or you can copy the 12 columns from the table above. To take the pillars from evidence, check your idea and copy the complaint themes and the impact-3 risks from the report.

FAQ

Sources

1. ama.org, 03/27/2026
2. support.google.com, 02/20/2026
3. smartsheet.com, 06/07/2016
4. hootsuite.com, 05/20/2025
5. notion.com, 10/30/2020
6. canva.com, 11/10/2025
7. semrush.com, 02/11/2026
8. support.google.com, 03/26/2026