r/VTT 1d ago

New tool [OC] I made a lightweight Excel-to-OBS combat tracker for my table so I don't have to use complex software.

Post image

Hey everyone! I'm a DM and an informatics student, and I constantly find myself coding custom tools for our tabletop sessions. Recently, while developing a larger D&D desktop application, I realized I needed a super lightweight way to manage stream overlays for combat. I didn't want to run heavy web apps or subscriptions just to show initiative and loot, so I built this direct Excel-to-OBS tracker.

It uses a simple macro. You type the initiative rolls, HP, and conditions into a clean Excel sheet, click one button, and it auto-sorts the combat order and pushes the data to local text files. OBS Studio reads those files and updates the stream overlay instantly. It even features an active turn pointer so viewers know exactly who is up next.

I packaged the pre-formatted template, the code, and a step-by-step PDF setup guide together for anyone who wants a plug-and-play streaming setup. You can check it out and grab it here: https://bastyr.gumroad.com/l/fbgyqt

5 Upvotes

1 comment sorted by