Skip to main content

Audition & Cast Tracker in Community Theater Group

The Audition & Cast Tracker is a copy-ready spreadsheet for community theater group that tracks performers, roles, auditions, callbacks, casting. It opens unchanged in both Google Sheets and Excel, needs no add-ons or macros, and takes about 15 minutes to set up.

Last updated: August 2026

Excel workbook · opens in Google Sheets · 3 tabs · no sign-up

Try it before you download

Live preview of “Audition & Cast Tracker”

Change any white cell; grey cells recalculate the way they will in Excel or Google Sheets. Nothing you type leaves this page.

Loading preview…

Get this template

What’s inside “Audition & Cast Tracker”

Tabs: How to use · Auditions · CastingFormat: Excel (.xlsx) · opens in Google SheetsSetup: About 15 minutesColumns: 11

Columns (grey = calculated for you)

  • Performer
  • Contact
  • Role considered
  • Vocal (1-5)
  • Acting (1-5)
  • Dance (1-5)
  • Conflicts
  • Callback
  • Decision
  • Total score
  • Rank for role
  1. Open the Auditions tab and replace the sample rows with your own — one row per entry. Formulas fill in automatically for new rows.
  2. Score each audition on the same scale; Rank for role orders performers within the role they read for.
  3. Record conflicts up front; the schedule matters as much as the score in community theater.
  4. Using Google Sheets? Upload the file to Google Drive, then open it with Google Sheets (or File → Import in an open sheet). Formulas, dropdowns and highlights carry over.

The file opens locally on your device — nothing is uploaded, and you own the copy outright.

Audition & Cast Tracker

About this template

It is built for people who want results without another subscription: directors comparing auditioners. It is completely free — copy it and it is yours to keep. Because it is a plain spreadsheet, you own your data outright and can shape every column to how you actually work.

Review evidence

What to verify before choosing Audition & Cast Tracker

Use the review criteria below to decide whether this template fits your workflow.

Review criteria

  • +Audition scores per role
  • +Callback and decline tracking
  • +Cast list auto-view
  • +Conflict notes

Often worth considering when

  • +Directors comparing auditioners
  • +Anyone running fair callbacks

Pause before choosing when

  • -Online submission forms
  • -Self-scheduling auditions

About Community Theater Group

Why people consider this option

  • +Run auditions to closing night on shared sheets
  • +Keep rehearsal calls clear for volunteers
  • +See whether the show actually broke even

What to review before acting

  • -No ticketing integration
  • -Season subscriptions need box-office software

Trust FAQ

Questions people ask before copying a template

Does the Audition & Cast Tracker work in both Google Sheets and Excel?
Yes. It is built with standard functions and no macros, so it opens and works the same in Google Sheets or Microsoft Excel — on desktop or your phone.
Is the Audition & Cast Tracker really free?
Yes, it is completely free to copy and keep. There is no account, paywall, or paid tier.
What does the Audition & Cast Tracker track?
It tracks performers, roles, auditions, callbacks, casting, with totals and highlights calculated automatically as you type.

More Options in Community Theater Group