Tracking 7th Sea 1st Edition Without the Paperwork
The 7th Sea RPG by John Wick Presents is a system built around heroics, Compasses, and a handful of tracking meters that tend to pile up fast during play. The core books—Leviathan, Castles, and the Screen & Play—are dense. Running a session at my table meant constantly juggling which Heroic each character had spent, whether their Compass was tipping, and how many points of Resolve or Fortune they had left. It was exhausting. Someone online pointed me toward a spreadsheet someone had built to automate much of this tracking, and I've been using it ever since. There isn't an official product from the publisher called exactly that. What exists are community-created spreadsheets—some in Microsoft Excel format, some in Google Sheets, a few hybrid versions. The most reliable ones I've found circulate through the 7th Sea RPG subreddit and a couple of dedicated Discord servers. I don't host a direct link because these files change frequently as people modify them, and a broken link does more harm than good. Search for "7th Sea 1e character sheet excel" or "7th Sea heroics tracker spreadsheet" and you'll land on a few solid options within five minutes. My go-to is a single workbook with separate tabs for each character. The main tab tracks attributes, Skills, and Talents in structured rows. There's a dedicated Combat tab that handles Initiative, Defense bonuses, and damage tracking with formulas that auto-sum when you enter numbers. The Heroics tab is where the real value sits—it tracks your pool of Heroic Points and automatically deducts them as you spend, which saves roughly twenty minutes of table time per session compared to erasing pencil marks.
One issue I hit early on: the original Heroics formula didn't account for the fact that certain Boons and Feats can refund Heroic Points under specific conditions. I spent two sessions with my characters running negative Heroic Point totals because I kept forgetting to manually add them back. The fix was straightforward—I added a separate column labeled "Refunds" and created a formula that subtracts the Refunds column from the Spent column to get the true remaining total. If you grab a downloaded sheet and notice values going below zero, check whether there's a refund tracking field. Most updated versions include it now. The Compass tracking is where these sheets really earn their keep. Each hero has a Compass that shifts between six emotional poles, and the spreadsheet calculates where you sit numerically based on actions you log. Enter the right kind of scene as a tag, and your Compass value updates automatically. Without automation, I was spending about ten minutes per session recalculating Compass positions by hand. With it, I just type the scene type and move on. Here's something most beginners miss: the Excel version doesn't enforce the narrative compels that the system is built around. A digital sheet will happily let you spend a Heroic Point and never remind you that you just triggered a Fate Compel on your Compass. The first time I ran a full campaign on the spreadsheet, my players complained that the scenes felt less tense because nobody was getting pushed into emotional decisions. The workaround is simple—I print a single physical sheet for each player that shows just their Compass track and Heroic reserve, and I use that as a secondary reference during scenes. The Excel handles the math; the paper handles the feel.
Another edge case worth noting: if you're running a large party of more than five characters, the standard spreadsheet template starts to lag. I tried loading eight full character tabs into one workbook and the recalculation time jumped from nearly instantaneous to about eight seconds per action. It sounds minor until you're in the middle of a combat round and four people are entering damage values in sequence. The fix is to split the workbook into two files—one for the PCs and one for NPCs or side characters. Alternatively, switch to Google Sheets, which handles larger datasets better because it recalculates incrementally rather than rebuilding the entire sheet every time. The spreadsheet approach also breaks down if you're using house rules or third-party sourcebooks that introduce new attribute types or custom Compass interpretations. I ran into this when I imported material from a community supplement that added a seventh Compass pole for a particular nation-specific faction. The existing sheet had no column for it, and the formula chain for Compass positioning didn't know how to handle a value outside the normal range. I ended up building a custom tab from scratch using the original sheet's formula logic as a reference. If you're planning to run anything outside the core books, expect to spend an afternoon modifying or rebuilding the sheet rather than just downloading and printing. For most tables running the standard Le Ronde campaign with five or six players, a well-set-up Excel sheet will cut your session prep time from roughly two hours down to about forty minutes. Character creation goes from an evening-long ordeal to maybe ninety minutes if you have the template already filled out. That's the real value—not the novelty of a digital sheet, but the hours you get back over a full campaign run.
Get the Full Details
One final caveat: Excel and Google Sheets are only as reliable as your own discipline. The sheet will track numbers accurately, but it won't stop you from misreading a rule or miscounting a skill bonus. I've seen people blame the spreadsheet for incorrect totals when the error was entirely on their end. Double-check your inputs before committing to them, especially in combat where a single wrong digit in the Defense column can cascade through an entire encounter's outcome.
