Skip to content
Editorial Calendar cover: a sample sheet with stories planned, published and words in progress and a column chart, beside the Dashboard and Stories tabs

Editorial Calendar

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
5
Difficulty
Beginner
Updated
November 13, 2026

Every slide (5)

Overview

The Editorial Calendar is built for a magazine, zine or newsletter that runs on a set issue schedule. The Stories tab lists each piece with its issue date, section, writer, target length, words so far and stage from Idea to Published. The Writers tab totals the stories and words for each person. The dashboard shows how many pieces are planned and how the words split across sections and stages.

Set the issue date before anything else, because the calendar flags any story that is past its date and not yet published. Update the words so far after each draft pass rather than at the end, so the progress figures stay honest. Keep one writer name spelled the same way on both tabs, and review the In progress count each week to see where an issue is thin.

Useful for

  • Map feature, news and opinion pieces onto each monthly issue
  • Check which writers are overloaded before assigning new stories
  • Track word counts against the page space each section gets

What's included

  • 4 tabs: Dashboard, Stories, Writers, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Stories: a table
  • Writers: a table
  • 2 charts that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Stories tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

How do I plan a story that has no date yet?

Add it with the stage set to Idea and leave the issue date blank for now. Fill in the date once the editor agrees the slot. Idea stories still count in the stage breakdown, so the dashboard shows how much of the pipeline is still unscheduled.

Can one writer have more than one story in an issue?

Yes. Each row is one piece, so a writer can appear as many times as needed. The Writers tab adds up their stories and words across the whole Stories list, so anyone carrying too much work stands out.

What happens when a story goes past its issue date?

The row turns red if the issue date has passed and the stage is not Published. Check the red rows at each planning meeting, then either move the issue date or change the stage so the calendar matches what is really happening.

  • #content-calendar
  • #editorial-calendar
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More content calendar templates

See all 8

Also in Marketing

All marketing templates
Get this template

Preparing your template…