Why a spreadsheet falls apart once you're gigging regularly

Every working performer starts the same way. You book a couple of gigs, you open a spreadsheet, and you type in the date, the venue, and what you got paid. For a while, it’s perfect. It’s free, it’s yours, and it does exactly what you need.

Then you start gigging regularly — and the cracks show up in the same three places every time.

1. It can’t time a set

A spreadsheet stores numbers. It doesn’t understand them.

When you’re building a 30-minute set, you’re not looking up a fee — you’re doing live math. This bit runs about seven minutes, the opener’s a tight four, the closer needs its full six. Add it up, realize you’re two minutes over, swap something out, add it up again. Backstage. On your phone. Five minutes before you walk on.

And the numbers you’re adding up are wrong anyway, because that “five-minute bit” is really seven once the laughs land. A cell holds whatever you typed last; it doesn’t learn that your actual average runtime has crept up over your last ten shows.

2. It forgets what you did where

Here’s the moment that matters most, and the one a spreadsheet handles worst.

A client calls back. “We loved you last time — can you do our event again?” This is the easiest money in the business: no pitch, no audition, they already want you. But to nail it you need to know two things instantly — what did I perform for them, and what did I charge?

Repeat the same routine you did last time and you look like you’re phoning it in. Quote a lower fee than before and you’ve left money on the table. So you go digging: scroll the spreadsheet, cross- reference old texts, try to remember. The booking that should’ve taken five seconds takes an afternoon — and you still aren’t sure.

A spreadsheet can hold that history. It can’t connect it. The gig, the venue, the contact, the set list, and the fee live in separate cells that don’t know about each other.

3. It dies on your phone

Your business doesn’t happen at a desk. It happens in a green room, a parking lot, a hotel lobby ten minutes before load-in. That’s exactly where a spreadsheet is most useless — pinch-zooming across forty columns, accidentally editing a cell you meant to read, losing the row you were on.

The tool you actually need is the one that works one-handed, standing up, right before you go on.

The spreadsheet isn’t wrong — it’s just outgrown

None of this means the spreadsheet was a mistake. It’s a great first system. It gets you surprisingly far, and if you only gig occasionally it might be all you ever need.

But the moment your calendar fills up, the same booking starts happening over and over — repeat clients, repeat venues, the callback two years later. That’s the point where you stop needing a record of your gigs and start needing something that connects them: that times your set from your real history, flags when you’re about to repeat material at a venue, and tells you in five seconds what you did and charged last time.

That’s the itch that made us build TrouperList. If you’re not there yet, a spreadsheet is genuinely fine — and you can grab our free Working Performer’s Gig Tracker to start on the right foot. When you outgrow it, you’ll know.