Free spreadsheet template
Content Calendar Spreadsheet Template
Download a free content calendar CSV template for publishing dates, channels, statuses, owners, keywords, and URLs.
This free CSV is designed for lightweight editorial planning in Excel or Google Sheets.
This is a lightweight CSV starter, not a finished Excel workbook. Add formulas after import if your spreadsheet app does not preserve formula cells.
If your browser previews the CSV instead of downloading it, right-click the link and save the CSV file.
Template preview
| Publish Date | Channel | Title | Status | Owner | Keyword | URL | Notes | Publish Check |
|---|---|---|---|---|---|---|---|---|
| 2026-07-15 | Blog | SUMIFS by Month Guide | Draft | Alex | sumifs by month | Needs screenshots | =IF(D2="Published",IF(G2<>"","Complete","Add URL"),IF(D2="Scheduled","Ready","In progress")) | |
| 2026-07-18 | Excel Lookup Tips | Scheduled | Jamie | xlookup examples | /examples/xlookup-multiple-criteria/ | Repurpose from guide | =IF(D3="Published",IF(G3<>"","Complete","Add URL"),IF(D3="Scheduled","Ready","In progress")) | |
| 2026-07-21 | Newsletter | Monthly Spreadsheet Tools | Draft | Priya | spreadsheet tools | Add template link | =IF(D4="Published",IF(G4<>"","Complete","Add URL"),IF(D4="Scheduled","Ready","In progress")) | |
| 2026-07-23 | Video | QUERY Date Range Walkthrough | Published | Alex | query date range | /examples/google-sheets-query-date-range/ | Add chapter links | =IF(D5="Published",IF(G5<>"","Complete","Add URL"),IF(D5="Scheduled","Ready","In progress")) |
| 2026-07-26 | Video | FILTER Formula Demo | Scheduled | Priya | filter formula | /google-sheets/filter-formula-builder/ | Record final voiceover | =IF(D6="Published",IF(G6<>"","Complete","Add URL"),IF(D6="Scheduled","Ready","In progress")) |
| 2026-07-28 | Blog | Duplicate Cleanup Checklist | Published | Jamie | find duplicates | /examples/find-duplicates-in-excel/ | Refresh examples | =IF(D7="Published",IF(G7<>"","Complete","Add URL"),IF(D7="Scheduled","Ready","In progress")) |
| 2026-07-30 | Newsletter | Inventory Tracker Template | Draft | Alex | inventory tracker | Draft email | =IF(D8="Published",IF(G8<>"","Complete","Add URL"),IF(D8="Scheduled","Ready","In progress")) | |
| 2026-08-01 | Blog | INDEX MATCH Guide | Blocked | Jamie | index match | Needs formula review | =IF(D9="Published",IF(G9<>"","Complete","Add URL"),IF(D9="Scheduled","Ready","In progress")) | |
| 2026-08-03 | Video | COUNTIFS Builder Demo | Scheduled | Alex | countifs formula | /excel/countifs-formula-builder/ | Prepare sample sheet | =IF(D10="Published",IF(G10<>"","Complete","Add URL"),IF(D10="Scheduled","Ready","In progress")) |
| 2026-08-05 | Date Formula Tips | Published | Priya | date formulas | /excel/date-difference-formula-builder/ | Repurpose examples | =IF(D11="Published",IF(G11<>"","Complete","Add URL"),IF(D11="Scheduled","Ready","In progress")) | |
| 2026-08-06 | Blog | Excel Serial Date Guide | Draft | Jamie | excel serial date | Add screenshots | =IF(D12="Published",IF(G12<>"","Complete","Add URL"),IF(D12="Scheduled","Ready","In progress")) | |
| 2026-08-08 | Newsletter | Formula Tools Roundup | Blocked | Alex | formula tools | Waiting on links | =IF(D13="Published",IF(G13<>"","Complete","Add URL"),IF(D13="Scheduled","Ready","In progress")) |
Field guide
| Column | Purpose | Example value |
|---|---|---|
| Publish Date | Planned publish or send date | 2026-07-15 |
| Channel | Blog, newsletter, social, or another channel | Blog |
| Status | Draft, scheduled, published, or blocked | Draft |
| Owner | Person responsible for the item | Alex |
| Keyword | Target topic or search phrase | sumifs by month |
| Publish Check | Formula check for published URLs and scheduled readiness | =IF(D2="Published",IF(G2<>"","Complete","Add URL"),IF(D2="Scheduled","Ready","In progress")) |
After import, add these formulas
=COUNTIF(D2:D13,"Draft")Enter this summary formula outside the table.
Returns with the included sample rows: 4.
=COUNTIF(E2:E13,"Alex")Enter this summary formula outside the table.
Returns with the included sample rows: 5.
=COUNTIF(I2:I13,"Ready")Enter this summary formula outside the table after I2:I13 contains Publish Check formulas.
Returns with the included sample rows: 3.
=FILTER(A2:I13,D2:D13="Draft")Enter this view formula outside the table.
Returns with the included sample rows: 4 returned rows.
How to use it
- Open the CSV in Excel, then use Save As and choose .xlsx; or in Google Sheets use File > Import > Upload and insert a new sheet.
- Verify that I2:I13 contains the Publish Check formulas after import, then fill down I2 if needed.
- Use COUNTIF summary formulas for Draft, Alex, and Ready counts, and use FILTER(A2:I13,D2:D13="Draft") for the draft row view.
Related spreadsheet formulas
FAQ
Is this a content SaaS?
No. It is only a static CSV template with related spreadsheet formulas.
Can I add more channels?
Yes. Add rows or edit the Channel values after importing the CSV.