Guide
How to Run Loot in WoW Classic Without a Spreadsheet
Every Classic guild starts with a spreadsheet. It works fine for the first month. Then someone pastes into the wrong cell, the formulas break, and the officer who built it is the only person who can fix it. There's a better way.
The spreadsheet era of WoW loot management lasted about 20 years. For most of that time, there was genuinely nothing better. Google Sheets was free, everyone could access it, and if you were willing to learn INDEX MATCH and conditional formatting, you could build something that mostly worked.
Mostly. The spreadsheet worked until it didn't, and when it broke, it broke at the worst possible time: right before a raid, right after a contested drop, or right when the officer who built it decided to take a break from the game.
Why Spreadsheets Break
This isn't about spreadsheets being bad software. They're great at what they do. The problem is that loot management isn't what they do. A spreadsheet is a general-purpose grid. Loot management is a specific workflow with specific rules, and bending a grid to fit that workflow creates problems that compound over time.
Single point of failure
The officer who builds the spreadsheet understands it. Nobody else does. The formulas reference other sheets, the macros are undocumented, and the conditional formatting logic was written at 2 AM after a six-hour prog night. When that officer takes a break, the spreadsheet becomes read-only. When they quit, it becomes a museum exhibit.
This is the officer burnout problem in miniature. The tool concentrates knowledge in one person, which concentrates work in one person, which concentrates risk in one person.
No validation
A spreadsheet will let a raider rank a cloth item on their warrior. It will let someone paste 60 items into a 50-item list. It will let an officer type "Thuderfury" instead of "Thunderfury" and break the VLOOKUP chain. Every manual entry is a chance for human error, and in a 25-person guild updating lists every week, those errors stack up.
No history
When a raider says "I had that item ranked #3 last week," can you prove them wrong? Probably not. Google Sheets has version history, but good luck finding the exact cell change from four days ago across 25 tabs. The spreadsheet captures the current state. It doesn't capture the decisions that led to it.
Attendance is a separate problem
Most loot spreadsheets track loot but not attendance. Attendance lives in a different sheet, or a Discord bot, or the raid leader's head. Connecting attendance to loot priority means manual data entry every week. As we covered in why attendance tracking matters more than loot rules, your loot system is only as good as your attendance data. If the two live in different tools, one of them is always out of date.
Scales badly
A 10-person spreadsheet is manageable. A 25-person spreadsheet with 50 items each, attendance records, point calculations, and historical loot data is a part-time job. The officer maintaining it spends more time fighting the tool than making loot decisions. That's backwards.
What Replaced the Spreadsheet
The spreadsheet didn't get replaced by one thing. It got replaced by a combination of purpose-built tools, each handling a piece of the puzzle better than a grid of cells ever could.
In-game addons
Addons like Gargul handle the in-raid workflow: distributing loot, running soft reserves, tracking who got what during the run. They're good at the moment-to-moment logistics of loot distribution. What they don't do is the strategic layer: who should get priority, how attendance factors in, what each raider wants.
Discord bots
Some guilds use Discord bots for loot wishlists and attendance tracking. These work as a basic input layer but create data silos. Your attendance is in one bot, your loot lists are in another, and your scores are still in a spreadsheet connecting the two. You've added complexity without removing it.
Purpose-built loot management tools
This is where the real shift happened. Tools designed specifically for WoW guild loot management don't try to be general-purpose. They understand item classifications, class restrictions, attendance windows, scoring formulas, and the actual workflow of running loot in a raid guild. The spreadsheet was a workaround. A purpose-built tool is the solution.
What a Spreadsheet-Free Loot System Looks Like
Here's the workflow when you stop fighting a spreadsheet and use a tool that was designed for the job:
Raiders manage their own lists
Instead of an officer collecting wishlists via DMs and pasting them into a sheet, raiders log in and rank items themselves. The tool shows them what's available for their class, prevents invalid selections, and saves automatically. The officer's job goes from "data entry" to "review and approve."
Attendance is automatic
Instead of manually tracking who was at each raid, attendance imports from your raid addon or gets marked in a few clicks. The tool calculates attendance percentages, handles excused absences, and factors the result into loot scores without anyone touching a formula.
Scores calculate themselves
Item ranking, attendance, seniority bonuses, trial penalties, role modifiers. All computed automatically based on the rules your guild sets. When an item drops, you check the score board. The winner is clear. No spreadsheet formula debugging required.
Loot decisions happen during the raid
With a priority list system, most loot resolves automatically. The officer opens the item, sees the ranked candidates with scores, and awards it. Edge cases get a quick council discussion. Either way, it's a 30-second process, not a 5-minute spreadsheet lookup.
History is built in
Every loot award, every list change, every attendance record is logged with a timestamp and who did it. When a raider asks "why didn't I get that item?" the answer is one click away: a score comparison showing exactly how the numbers broke down.
The Migration Isn't as Hard as You Think
The biggest barrier to ditching the spreadsheet is the migration. "We have six months of data in this sheet." Fair. But here's the thing: most of that data doesn't matter going forward. You need current rankings and recent attendance. Historical loot data is nice but not critical.
A practical migration looks like this:
- Week 1: Set up the tool. Import your raid schedule and roster. Officers configure scoring rules to match (or improve on) your current system.
- Week 2: Raiders submit their loot lists in the new system. Run loot from the new tool while keeping the spreadsheet as a backup. Compare results.
- Week 3:If the numbers match and nobody is confused, retire the spreadsheet. If something's off, adjust the settings and run another parallel week.
Most guilds are fully migrated within two raid resets. The spreadsheet sits untouched in the Discord pins as a historical artifact.
The Bottom Line
Spreadsheets were the best option for a long time. They aren't anymore. The problems they create, concentrated knowledge, manual errors, attendance disconnects, scaling pain, are all solved by tools built for this specific job. The guilds still using spreadsheets in 2026 aren't doing it because the spreadsheet is better. They're doing it because switching feels hard. It's not.
LootList+ handles loot lists, attendance tracking, score calculations, and loot history in one place. Raiders submit their own lists, attendance imports in clicks, and loot decisions happen in seconds during the raid. Set it up before your next tier and stop being the guild that runs loot from a spreadsheet.
