5 Ways to Track NPCs, Locations, and Lore Across Sessions

Why NPC Tracking Is the DM's Biggest Headache

When your players return to Waterdeep after 12 sessions and ask about the blacksmith they befriended in session 2, you'd better have an answer. The problem is that by session 12, you've introduced dozens of NPCs, scattered them across multiple locations, tangled them into overlapping factions, and given at least three of them names that start with "G."

You're not alone. Community discussions on D&D Beyond and EN World show this is one of the most common DM struggles. A guideline from Yawning Portal suggests planning 1-3 key NPCs per campaign and 0-3 per story arc — but in practice, the number spirals fast. Players befriend random tavern keepers, adopt goblin prisoners, and form alliances with NPCs you improvised on the spot. A 20-30 session campaign can easily accumulate 50-100 named NPCs, plus locations, factions, and plot threads.

The average campaign lasts 6 months to 2 years, with roughly 42% of groups playing less than weekly (per Sly Flourish's survey of 6,600+ DMs). That's a lot of gaps where details fade. The right D&D NPC tracker can turn campaign chaos into a searchable, organized knowledge base. Here are five methods, ranked from simplest to most automated.

Method 1: The Simple Spreadsheet

If you're already comfortable with Google Sheets or Excel, a spreadsheet is the fastest way to start tracking NPCs — no learning curve, no subscription, no fuss. A popular format uses a "Dramatis Personae" tab with these core columns:

The columns that save you mid-session are "Last Appeared" and "Notes." "Last Appeared" tells you if an NPC is fresh in player memory or half-forgotten. "Notes" captures the messy details — unresolved problems, secrets, quirks — that make an NPC feel alive. Add separate tabs for Locations (name, region, key NPCs, last visited, status) and Factions (goals, allies, enemies, party relationship) and cross-reference by name.

Strengths: Zero cost, 10-minute setup, searchable with Ctrl+F, works on any device, shareable with players.
Weaknesses: Manual entry only, no linking between entities, gets unwieldy past 80+ NPCs, no visual maps.
Best for: DMs who want lightweight and no-frills, and don't mind 5-10 minutes of updates after each session.

Method 2: The Notion Database

If a spreadsheet feels too flat, Notion's relational databases let your NPCs, locations, and factions actually link to each other. Click an NPC and see their location, faction, and every session they appeared in — no cross-referencing tabs required.

Purpose-built templates make setup fast. The Lore Keeper 5e template provides interconnected databases for NPCs, locations, treasures, and adventures — all linked through Notion relation fields. Sly Flourish's Lazy DM template takes a leaner approach with tagged cards for NPCs, villains, items, and locations. Both are available free or cheap on the Notion Marketplace.

Each NPC gets a page with properties — Name, Race, Location (linked), Faction (linked), Status, Disposition, Description, Motivations, Secrets, and Connected NPCs. The magic is in those linked fields: click "Waterdeep, Castle Ward" and you land on the location page showing every NPC in that area and every session that took place there. It's a mini-wiki that builds over time.

Strengths: Relational power, multiple views (table/board/gallery), free tier sufficient for most campaigns, shareable with players.
Weaknesses: Learning curve if you're new to Notion, still fully manual, tempting to over-engineer with too many fields.
Best for: DMs who enjoy organizing and want interconnected data — especially for campaigns with complex faction politics.

Method 3: Physical Index Cards

Sometimes the best technology is no technology at all. Index cards have been a DM staple since the hobby began, and they've lasted for good reason. One card per NPC — name on the front with a quick sketch and location, personality and plot hooks on the back. Sort by location in a box or binder, and when the party arrives somewhere new, pull that location's stack.

This approach shows up repeatedly in advice on D&D Beyond and RolePlayingTips.com. Research on handwriting vs. typing suggests that physically writing engages deeper cognitive processing, which explains why so many DMs swear by the tactile method for remembering NPCs.

Organize by location (dividers for each area), by faction, or by status — active, retired, and yes, dead. You'll need a "dead" section eventually.

Strengths: Instant access at the table, no batteries or subscriptions, kinesthetic memory boost, tangible visual overview.
Weaknesses: Not searchable, not shareable between sessions, physically limited at 100+ NPCs, coffee spills.
Best for: In-person games with a manageable cast (under 50-60 active NPCs) and DMs who prefer tactile tools.

Method 4: Dedicated Wiki Tools

When your campaign outgrows a spreadsheet, dedicated worldbuilding wikis were built for exactly this problem. Platforms like World Anvil, Kanka, and LegendKeeper give you purpose-built templates for NPCs, locations, organizations, items, and events — all interconnected and designed for the way DMs actually think about their worlds.

World Anvil is the largest platform — 25+ templates, interactive maps, timelines, and a massive community. Article-centric and ideal for deep worldbuilders. Free tier is generous; premium starts around $5/month.

Kanka offers a cleaner, more intuitive interface. Modular entity system for characters, locations, organizations, and more, with fast setup. Kanka emphasizes you can have your first NPC entered within minutes.

LegendKeeper takes a workspace approach — interactive maps, freeform whiteboards, real-time multiplayer editing. According to their own comparison, the strengths are an uncluttered interface and single price point. Great for collaborative parties.

Strengths: Purpose-built TTRPG templates, deep linking, interactive maps, DM/player permission controls, timelines.
Weaknesses: Learning curve (especially World Anvil), still manual entry, subscriptions for best features, can become a time sink.
Best for: Long campaigns (6+ months) with complex worlds and a love of worldbuilding. If you're interested in building a full campaign wiki, these tools are the standard.

Method 5: Automated Tracking Tools

What if you didn't have to write any of it down? Automated tools flip the workflow: instead of manually entering NPCs after each session, they listen to your session and extract the lore for you. Record your session, and the tool transcribes the audio, identifies NPCs and locations, and adds them to a searchable wiki — automatically.

Kazkar is a Discord bot that joins your voice channel, records the session with speaker identification, and auto-generates a lore wiki with NPCs, locations, factions, and session chronicles. Free for 10 hours of recording. SessionKeeper offers recording via mobile app and Discord, with AI summaries and a campaign wiki — good for in-person groups. Archivist provides the most features — recording, transcription, an AI chatbot for campaign Q&A, timelines, and trading cards. Plans start at $10/month.

The pipeline works like this: Record audio, transcribe with speaker ID, AI extracts NPC names and locations, entities get added to a wiki linked to the session, and returning NPCs get updated rather than duplicated. The result is a living wiki that grows every time you play. When a player asks "Who was that blacksmith?" you search and find Gareth Ironhand — complete with session number, what he said, and his missing daughter.

Strengths: Zero manual effort, nothing gets lost, cumulative across sessions, searchable, also provides session recaps.
Weaknesses: Requires comfort with recording, audio quality affects accuracy, newer technology still maturing, online-first.
Best for: Discord groups wanting comprehensive tracking with no manual work — especially improv-heavy campaigns where NPCs emerge organically. If you struggle with remembering what happened last session, automated tools solve both problems at once.

NPC Entry Template: What to Track

Regardless of method, tracking the right information is what makes the system useful. Too little and the entry is worthless; too much and you'll abandon it. Here's the sweet spot.

Essential fields (every NPC)

Optional but valuable

Pro Tips: Keeping It Manageable

The best tracking system is the one you actually use. A few tips from DMs who've done this for years:

Track NPCs at three tiers. Tier 1 (5-10 major NPCs): full entries with all fields — your BBEGs, key allies, recurring characters. Tier 2 (15-30 supporting): essential fields only — shopkeepers, quest givers, faction contacts. Tier 3 (unlimited minor): just a name and one-liner. Only promote to Tier 2 if players latch on.

Update after sessions, not during. Don't break focus mid-game. Spend 5-10 minutes after each session adding new NPCs and updating existing ones. This fits naturally into the Lazy DM's documentation guide workflow.

Let players help. Share the tracker (hide secrets) and let players add entries. Some DMs rotate a "lore keeper" role each session — distributes the work and gives players ownership of the world.

Prune every 10 sessions. Archive NPCs the party hasn't seen in a long time. Dead characters, resolved quest givers, and one-off encounters move to an archive section. Keep your active list focused.

Name carefully. If you have NPCs named Gareth, Garrett, and Garek, you're creating confusion for everyone. Use distinct starting letters and vary syllable count.

FAQ

How many NPCs should I track in a D&D campaign?

Plan for 1-3 key NPCs per campaign arc, plus 0-3 per story arc. A 20-30 session campaign typically accumulates 30-100+ named NPCs, but only 10-20 need detailed entries. The rest can be one-liners. Community discussions on D&D Beyond emphasize keeping your "important" count low.

What's the best free D&D NPC tracker?

Google Sheets for simplicity, Notion for structure, Kanka for a dedicated TTRPG tool. All have generous free tiers. If your group plays on Discord, Kazkar's free tier offers 10 hours of recording with automatic NPC extraction — no manual entry needed.

Should I let my players see the NPC tracker?

Yes, with boundaries. Share the tracker but hide secrets, motivations, and DM-only notes. Tools like World Anvil and Kanka have built-in permission systems. In a spreadsheet, keep a hidden "DM Notes" column.

How do I track NPC relationships and connections?

Depends on your tool. Spreadsheets: add a "Connected NPCs" column. Notion: use relation fields for clickable links. Wiki tools: built-in relationship mapping. Automated tools: connections are built from session recordings when NPCs are mentioned together.

What if I'm already 20 sessions in and haven't been tracking?

Start now with what you remember, then fill gaps as NPCs reappear. You don't need to retroactively document every NPC from every past session. Create entries for whoever the party is interacting with now, add major plot NPCs from memory, and build from there. The best time to start was session 1. The second-best time is now.

Keeping your campaign's cast organized isn't glamorous — but it's what separates a good campaign from a great one. Pick a system, stick with it, and your players will notice the difference the next time you rattle off a forgotten NPC's name, occupation, and unresolved quest hook from eight sessions ago. That's what makes a world feel real.