Why film and TV productions still run on spreadsheets - and what to do instead

Here's a scene almost every production coordinator and 1st AD has lived through.

It's 6am. The crew is assembling on location. Someone's phone buzzes - a WhatsApp message from a cast member. "Just checking - are we still at the church first or has that moved?" You sent the updated schedule yesterday. The version with the church moved to day two. But they're looking at the PDF from three days ago, which is sitting in their downloads folder next to schedule_v4_REVISED_FINAL and schedule_v4_REVISED_FINAL_2.

Nothing is technically broken. The schedule exists. It's just that nobody - including you - is completely sure which version is the right one.

This is the spreadsheet problem. And it's been the spreadsheet problem for thirty years.

How spreadsheets became the industry standard

Let's be honest about something first: spreadsheets didn't win by accident. They won because they actually work - up to a point.

Excel and Google Sheets are genuinely good tools. They're flexible. They're free (or nearly free). Every department head on every production already knows how to use them. You can build a shooting schedule in a spreadsheet in an afternoon without any training, any setup, or any monthly subscription. For a two-day short film or a small corporate shoot, that's completely fine.

The problem isn't that spreadsheets exist. It's that they became the default for productions where they've long since stopped being the right tool - and nobody built a convincing alternative for long enough that the industry just kept going.

If you look at what was available for professional scheduling software for most of the last decade, you start to understand why. Movie Magic Scheduling - the closest thing the industry had to a standard - costs hundreds of pounds per licence, requires installation, and was designed around the workflows of large US studio productions. EP Scheduling is similar. StudioBinder is genuinely good but US-centric, priced in dollars, and bundles scheduling in with a dozen other features most productions don't need.

So what did the coordinators and line producers running independent features and mid-budget TV do? They stayed in Excel. Because the alternative was paying a lot of money for software that felt like it wasn't really built for them.

What spreadsheets are actually good at

Before we get into where they fall apart, credit where it's due.

Spreadsheets are universally accessible. Every single person on your crew can open one. No account required. No app to download. No "I can't see it" from the actor who doesn't do tech.

They're completely flexible. You can structure them however the production needs. No software forcing you into its opinion of what a schedule should look like.

They're free. At micro-budget level, this matters more than anything else on this list.

And they're fast to set up for simple productions. A two-day short film doesn't need dedicated scheduling software. A spreadsheet is fine.

That last point is important. Not every production is in the wrong tool. A lot of them genuinely are at the right scale for a spreadsheet. The ones that aren't - and they know who they are - tend to keep using spreadsheets anyway, because switching feels harder than tolerating the pain.

Where they fall apart

The spreadsheet starts to break at the point where more than two or three people need to use it. That's when the version problem kicks in.

The version problem works like this. The schedule lives in a file. The file gets updated and emailed out. People save it locally. The schedule changes - because schedules always change - and now there are two versions. Then three. The coordinator knows which one is current. The 1st AD probably does. The heads of department might. The runner definitely doesn't.

Production people have developed entire naming conventions to manage this. v1, v2, REVISED, FINAL, FINAL_REVISED, FINAL_v2, actual_final. It's funny until it's your production and someone turns up to the wrong location because they had last week's PDF.

Beyond versioning, there are a few other specific ways spreadsheets cause real problems:

Different departments need different views - and you have to make them manually

The 1st AD needs the full stripboard. The location manager needs to know which locations are shooting when. The costume department needs to know when each actor is on set. The transport coordinator needs company moves. In a spreadsheet, these are all separate documents, manually maintained, manually updated every time the schedule changes. Which it will. Constantly.

You can't see a conflict until it bites you

Spreadsheets don't flag when you've accidentally double-booked an actor, scheduled a company move that doesn't allow enough time, or stacked too many demanding scenes on a Friday afternoon. They just show you the data. Spotting the problem is your job, done manually, under pressure.

Real-time changes are a communications exercise

When the schedule changes on a live production - and it changes every day - the coordinator has to update the spreadsheet, export it, and distribute it. Via email. Or WhatsApp. Or both. And then manage the replies from people who are still looking at the old one. This is not an edge case. This is the job, every day, on every production running on a spreadsheet.

The access problem cuts both ways

Most productions want the whole crew to have access to the schedule. The director, the DoP, every department head, the runners. But in a spreadsheet, giving everyone access means giving everyone the ability to accidentally change something. So you either lock it (annoying) or distribute PDFs (which immediately become out of date) or give access and hope nobody touches it.

Why dedicated tools haven't replaced them

Given how well-understood these problems are - every coordinator knows the version hell, every 1st AD has dealt with crew turning up to the wrong location - why hasn't the industry moved on?

A few reasons, and they're all legitimate.

The established tools are expensive. Movie Magic Scheduling has a substantial per-seat licence cost. For a production with a tight budget, that's a real barrier. And if you're going to pay, you need everyone who needs access to have a seat - which makes the total cost add up fast.

The established tools have a steep learning curve. Movie Magic in particular is genuinely powerful software. It's also not something you pick up in an afternoon. For productions that don't have a dedicated production manager who already knows it, the training overhead is a deterrent.

Most tools were built for the US market. The workflows, terminology, default settings, and pricing are all oriented around how American productions operate. For productions everywhere else, using these tools means working around assumptions that don't quite fit.

And then there's the free tier problem. Traditionally, dedicated scheduling software required everyone who needed to view or edit the schedule to have a paid account. That made "the whole crew can see the live schedule" effectively impossible without a large budget for licences. So productions went back to distributing PDFs and living with the version problem.

This is the gap that's stayed open for years. Professional productions needed something between "free spreadsheet that causes chaos" and "expensive enterprise software built for a different market."

What's actually changed

A few things have shifted recently that make the "stay in Excel" calculation less obviously correct.

First, a new generation of scheduling tools has appeared that are genuinely easier to use and more affordably priced. Not dumbed-down - still capable of handling complex multi-location, multi-unit productions - but without the five-figure licence costs or the weeks of training.

Second - and this is the one that changes the maths significantly - some of these tools have adopted a free viewer model. The team building and maintaining the schedule pays for the tool. Everyone else - department heads, cast, runners - can view the live schedule for free, on any device, without an account. That solves the access problem without solving it via PDFs. The schedule is live, it's always the current version, and anyone who needs it can see it.

Third, cloud-based tools mean the schedule isn't a file anymore. It's a URL. Change the schedule and everyone who's looking at it sees the updated version immediately. The version problem doesn't go away entirely - you still need good change management - but "which file is current" stops being a question.

What to look for if you're switching

If your production is at the scale where spreadsheet scheduling is causing real problems, here's what actually matters when evaluating alternatives:

Free viewer access. Can the whole crew see the live schedule without a paid seat? If not, you're back to distributing PDFs.

Real-time updates. Does a change you make appear immediately for everyone? Or does it require an export and a resend?

Flexible structure. Can it handle how your specific production is structured, or does it force you into someone else's template?

Pricing model. Is it per-seat (expensive at scale) or per-project/flat rate? Multi-currency if you're not paying in USD?

Learning curve. Can a production coordinator get up to speed in a day, or does it require dedicated training?

Mobile access. Crew access the schedule on their phones on set. Does it work well on mobile?

The honest answer is that no tool is perfect for every production. A 200-day studio feature with multiple units running simultaneously has different needs to an 18-day independent drama. The question isn't "what's the best scheduling software" in the abstract - it's what solves the specific problems your production is having.

For most productions, those problems are version control, crew access, and the time it takes to manually maintain separate documents for different departments. A tool that solves those three things - even if it doesn't do everything - is worth the switch.

Spreadsheets will be around for a long time. They're genuinely good at a lot of things, and for smaller productions they'll remain the right choice. But the argument for staying in Excel on a complex professional production is getting weaker. The tools that were supposed to replace them are finally catching up - and in some cases, overtaking them.

The version problem is solvable. It's just a question of when it becomes more painful to live with than to fix.