The Ghost in the Spreadsheet: A Eulogy for a Single Cell
I was looking for a date. Not a romantic one, but a bureaucratic one: the precise day a specific municipal policy was enacted. The official record was a PDF scan of a meeting minutes document, a blurry photocopy of a typewritten page, uploaded to a city server sometime in the early 2000s. The link, predictably, was dead. A quick trip to the Wayback Machine brought the page back, a digital Lazarus, and I downloaded the file.
But the date wasn’t there. Or rather, it was, but it was wrong. The minutes referenced an amendment from a prior meeting, one that wasn’t included in the scan. I was at a dead end. Then I remembered. Years ago, a friend who worked in that very department had sent me a different file. It wasn’t a PDF; it was a spreadsheet. A massive, sprawling, multi-tabbed Excel file that was their internal, living record of ordinance changes. It was a mess of inconsistent formatting, merged cells, and cryptic acronyms, but it was the raw data, the source.
I found the old email, dug through my backups, and there it was. I opened it, navigated to the correct tab, and found the row. And there it was: the date, sitting in cell G147. Next to it, in cell H147, was a note. It was a single sentence, typed by a clerk whose name was listed in the ‘last modified’ metadata. The note simply read: “Councilman Jacobs insisted, against advice.”
That single cell, H147, contained more truth than the entire official PDF. It was a whisper of process, a human fingerprint on the dry data. It was the ‘why’ hiding beside the ‘when’. That spreadsheet wasn’t meant for the public. It was a working document, a digital workshop where the sausage was made. Its preservation was an accident, a byproduct of an email attachment. The official record was designed to be permanent and, in its sterile perfection, was less informative.
This is the profound, often overlooked value of preserving not just the final, polished public record, but the messy, intermediate data that leads to its creation. That spreadsheet is now gone. The software it was built in is obsolete, the email server it traveled on has been decommissioned, and the clerk who typed that note has long since retired. My copy is a relic. The cell is a ghost.
We talk about preserving the web, the big, sprawling public internet. But we must also champion the preservation of these intimate, accidental archives—the spreadsheets, the draft documents, the internal wikis. They are the marginalia of governance, the subtext of our civic life. They hold the human hesitations, the quiet objections, and the small insistences that shape our world. We need to save the final performance, yes, but we must also fight to save the rehearsal.
Notes & further reading
A few pages I came back to while writing this:
- Huntsville, AL
- The Memory of Static: On the Longevity of Unchanging Pages
- Little Rock, AR
- The Cathedral, the Bridge, and the Digital Repository: Preservation Lessons from Structural Engineering
- Gilbert, AZ
- The Accidental Archives: A History of Public Records That Were Never Meant to Be
- Peoria, AZ
- Scottsdale, AZ
- Surprise, AZ
- Tucson, AZ
- Elk Grove, CA
- Fullerton, CA
- Pasadena, CA