Cold Cases, Hot Takes, and Color-Coded Spreadsheets: Inside the World of Amateur True Crime Investigators

Somewhere in a suburb outside Columbus, Ohio, a woman named Terri has seventeen browser tabs open. One is a county court records database. Another is a satellite map of a rural road in Indiana. A third is a Google Sheet she's been building for eight months—color-coded by suspect proximity, timestamped to the minute, cross-referenced with a separate tab tracking witness statements. She hasn't slept great lately. She doesn't particularly care.

"Once you start seeing the patterns," she says, "you can't unsee them."

Terri is not a detective. She's a dental office manager with two kids and a labrador mix named Biscuit. But she is part of a quietly enormous community of amateur cold case investigators who have turned the true crime obsession—the one that sold 40 million podcast downloads and made half the country briefly terrified of their neighbors—into something more systematic, more obsessive, and considerably more complicated.

How a Podcast Becomes a Spreadsheet

The pipeline from casual true crime listener to full-on data analyst is shorter than you'd think. It usually starts with a podcast. Maybe Crime Junkie, maybe My Favorite Murder, maybe one of the hundreds of regional shows covering hyperlocal cases that never made national news. You listen. You get curious. You Google. You fall into a Reddit thread. And then, almost without realizing it, you're three hours into a county property records search trying to figure out if a suspect owned land adjacent to where a body was found.

The true crime internet has always existed, but something shifted in the last few years. The tools got better. Public records became more searchable. Ancestry databases opened up genealogical angles that once required professional forensic genealogists. And crucially, the community got more organized—less "here's my wild theory" and more "here's my documented methodology."

Subreddits like r/UnresolvedMysteries have evolved from speculation forums into something closer to collaborative research hubs. Discord servers dedicated to specific cases maintain shared document folders. Some groups use Notion. Some use Airtable. Many, many of them use Google Sheets with a level of structural sophistication that would make a project manager weep with pride.

The Database Is the Point

What separates this new wave of armchair investigators from the true crime fans who just, you know, listen to podcasts and move on, is the documentation obsession. These are people who genuinely believe that if you organize the information correctly—if you map the relationships, log the timelines, flag the inconsistencies—something will surface that wasn't visible before.

And sometimes? It does.

In 2019, amateur investigators working the Golden State Killer case online were part of a broader genealogical effort that contributed—though the extent is debated—to identifying Joseph James DeAngelo. More recently, volunteer networks using public DNA databases and family tree research have helped crack cases that sat cold for decades. The Othram lab in Texas has worked alongside citizen researchers on multiple occasions. This isn't fringe stuff anymore.

Mark, a retired logistics coordinator in Tennessee who asked us not to use his last name, has been working the same unsolved disappearance case for three years. He built what he calls a "relationship matrix"—a spreadsheet tracking every named individual connected to the case, their known locations on key dates, their relationships to each other, and public records that either confirm or contradict official statements.

"I found a discrepancy in a property transfer record that puts someone in a different county than where they claimed to be," he says. "I sent it to the detective on the case. Never heard back. But I know it's in there."

Whether it actually matters? That's a harder question.

The Ethics Get Messy Fast

Here's where the rabbit hole gets genuinely uncomfortable.

For every Mark with a methodical, documented approach and the good sense to route findings through official channels, there are communities that have named wrong suspects publicly, harassed grieving families, and turned real tragedies into content. The JonBenét Ramsey case has been "solved" online roughly four hundred times. The Delphi murders—the 2017 killings of two teenage girls in Indiana—spawned such a chaotic online investigation that local law enforcement had to issue public statements asking amateur sleuths to back off.

The line between passionate civic engagement and digital mob behavior is thin, and it moves depending on who's doing the moving.

Terri knows this. She's thought about it a lot. Her personal rule is that she never posts theories that name living private individuals without documented public record support. She's seen what happens when that rule gets ignored—she watched a Facebook group she used to follow dogpile on a man who turned out to have a verified alibi. "It was awful," she says. "People were calling his employer. He had nothing to do with it."

The more serious amateur investigator communities have developed informal ethical codes: don't name suspects publicly without evidence, don't contact victims' families unless they've specifically invited outreach, route anything potentially significant to law enforcement rather than posting it for clout. Whether everyone follows these guidelines is another matter entirely.

The Weird Joy of Pattern Recognition

But here's the thing that's easy to miss when you're busy debating the ethics: for a lot of these people, the actual draw isn't solving the crime. It's the process.

The spreadsheet-building, the cross-referencing, the satisfying click of finding a public record that fills in a gap—that's the hobby. The unsolved case is almost secondary to the intellectual pleasure of organizing chaos into something legible.

"I'm a data person," says a woman in Arizona who goes by the handle CrimsonMaple on several cold case forums. "I work in healthcare administration. I build models. This is just... the same skill set applied to something that feels more meaningful than quarterly reports."

She's been working a 1980s Jane Doe case—an unidentified woman found in the desert whose case recently got a DNA profile uploaded to a public genealogy database. CrimsonMaple has built a family tree reconstruction going back four generations, trying to narrow the geographic region the woman might have come from. It's painstaking, voluntary, and completely unpaid.

"If I help identify her, great. But I'd be doing this anyway," she admits. "The puzzle is the point."

Fall In, But Watch Your Step

The amateur true crime investigator community is, like most rabbit holes worth falling into, a genuinely mixed bag. It contains rigorous researchers and conspiracy-adjacent chaos agents. It produces real leads and spectacular dead ends. It raises important questions about public records access, victim privacy, and the ethics of turning real human tragedies into collaborative hobby projects.

It also, undeniably, gets results sometimes. Cold cases have been cracked. Identities have been restored to Jane and John Does. Families have gotten answers.

Terri is still working her case. The spreadsheet is now on its fourth version. Biscuit has learned to sleep through the late-night typing.

"I don't know if anything I find will matter," she says. "But someone has to be paying attention. Might as well be me."

Hard to argue with that, honestly.