The Ghost in the Spreadsheet: A Memory of My Grandfather's Ledger
I remember the smell of his office most of all. It was a mixture of old paper, pencil shavings, and the faint, metallic scent of a space heater working overtime against the upstate New York chill. My grandfather was an accountant, a man who believed in the sanctity of the ledger. His world was one of perfect, handwritten rows and columns, a physical testament to order and accountability.
After he passed, the task of clearing out his office fell to me. There, in a bottom drawer of his heavy oak desk, I found them: decades of his work ledgers, bound in green canvas. I opened one from the 1970s. The pages were crisp, the ink slightly faded to a warm brown. Each entry was a tiny monument to a transaction, a payment received, a bill settled. But it was the margins that held my attention. In his tight, precise script, he had noted the weather on the day of a large deposit (“Blizzard—client paid in full, trudged through snow”), a brief comment on a client’s character (“Reliable. Brought his son to work.”), and next to a particularly lean week, a single word: “Persevere.”
This wasn’t just data; it was a narrative. It was a human story woven into the grid of debits and credits. The numbers told you what happened, but the marginalia told you how it felt.
The Perfect, Empty Cell
Years later, as I worked on a project migrating public records into an open data portal, my grandfather’s ledger came back to me. We were taking beautifully messy, human-created documents—municipal reports, meeting minutes, planning documents—and distilling them into pristine, machine-readable CSV files. The process was a success by every metric we had. The data was clean, accessible, and queryable. It was, in a word, perfect.
But staring at those flawless rows in a spreadsheet, I felt a strange sense of loss. We had successfully exorcised the ghost from the machine. The weather reports, the hurried notes in the margin, the coffee ring on the corner of a page that connected it to a specific time and place—all of it was gone. We had preserved the fact, but not the context. We had the ‘what’ in a state of impeccable clarity, but we had orphaned it from the ‘why’ and the ‘who’. In our quest for perfect, structured openness, we had created a digital artifact that felt, somehow, less complete than my grandfather’s handwritten books.
This isn’t an argument against open data or digitization. It is a plea for a more holistic form of preservation. As we work to make public records readable and accessible to machines, we must also find ways to preserve their human-readable soul. Perhaps it means archiving a scanned copy of the original document alongside the parsed data. Maybe it means developing systems to capture and retain metadata that feels frivolous—the scribbles, the stamps, the very texture of the original.
Because data doesn’t exist in a vacuum. It is created by people, for people, in a specific time and place. My grandfather’s ledger taught me that the true value of a record often lives not in the cell itself, but in the empty space around it. Our challenge is to find a way to keep that ghost in the spreadsheet, to honor the full story, not just the summarized fact.
Notes & further reading
A few pages I came back to while writing this: