Skip to content
Podcast Episode Planner cover: a sample sheet with episodes planned, released and minutes of audio and a pie chart, beside the Dashboard and Episodes tabs

Podcast Episode Planner

Spreadsheet template for Google Sheets and Excel

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

Every slide (5)

Overview

The Podcast Episode Planner is for a host or small production team running a show on a weekly or fortnightly schedule. The Episodes tab lists each show in air order with its format, guest, record date, release date, stage and running time in minutes. The Guests tab tracks every invitation from first contact to recorded, with the next step written beside each name. The dashboard totals the audio, averages the episode length and breaks the minutes down by format.

Enter a release date as soon as an episode is booked, even if it is months away, so the season takes shape on the page. Log the minutes after the edit rather than the rough cut, since the final length is what listeners see. Revisit the Guests tab after every round of emails, and word the next step so it reads in a glance.

Useful for

  • Plan a season of interviews, solo shows and listener questions
  • Track which guests have agreed, recorded or declined
  • Check total audio minutes for a sponsor or media kit

What's included

  • 4 tabs: Dashboard, Episodes, Guests, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Episodes: a table
  • Guests: 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 Episodes 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 panel episode with several guests?

Pick Panel from the Format list, then enter every guest's name in the Guest cell with commas between them. Then add each person on the Guests tab with their own status, so you can see who has confirmed and who still needs a reminder.

Should I count the minutes before or after editing?

Use the length after editing, because that is what listeners hear. Leave the minutes at zero until the episode is finished, so the averages and the format breakdown only include shows that are ready or nearly so.

How do I track episodes that move to a new release date?

Change the release date on the Episodes tab and update the stage if the show is no longer Scheduled. Keep the earlier date written in Next step on the Guests tab and you will recall why the slot moved.

  • #content-calendar
  • #podcast-planner
  • #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…