How I overhauled our office filing system with spreadsheets and stubbornness

One Monday in April, I got a paper cut on my finger while opening a cabinet drawer. It was the third one. That week alone. That's when I decided I couldn't put up with this paper filing system dating back to the 1990s any longer.

Our Hamburg office had a scene I faced every day: four rows of filing cabinets stacked floor to ceiling, handwritten labels stuck on every folder, and colleagues relying on memory to answer the question, "Where's that document?" When someone went on holiday, finding a specific document was practically impossible.

What I tried first

The first thing I did was transfer the existing folder structure directly into digital form. I created folders by cabinet number in Windows Explorer and dropped the scanned files in. I gave up after a week. The existing structure itself wasn't logical. Inside a folder labelled "Kunden A-F," there'd be a 2008 supplier contract. Someone must have had a system for organising things, but it existed only in the head of a person who had long since left the company.

Next, I tried free document management software. I installed it, watched the demo, designed a tagging system — and then my colleague Stefan said, "Another new programme? Can't you just send it by email?" That's when reality hit. Nobody was willing to learn new software.

The spreadsheet compromise

Where I ended up going back to was Google Sheets. A tool everyone already knew how to use. Nothing fancy, but it was the path of least resistance.

The key was creating one master sheet. The column layout was simple: document type / date / relevant department / cabinet location / digital file link. I added VLOOKUP and data validation so that when you selected a document type, the corresponding cabinet location would appear automatically.

The real turning point was conditional formatting. Scanned documents showed up green; unfinished ones, red. When I put this up on the screen during a team meeting, everyone saw that red covered more than 80% of the screen. It wasn't numbers — it was colour that moved people. Starting that week, two colleagues voluntarily joined the scanning effort.

Moments that required stubbornness

It wasn't all smooth sailing. My boss said, "The existing system has worked fine for decades." I showed him my records indicating it took an average of 12 minutes to find a single document the previous month. I had timed and noted every document search over a two-week period. Only then did I get the go-ahead: "Give it a try."

Six months on, two of the four rows of cabinets are empty. Not every document has been digitised. Pre-2015 documents with no retention obligation are still on paper. It's not perfect. But now it takes less than two minutes on average to find a document, and work doesn't grind to a halt when someone goes on holiday.

If I've learned one thing, it's that convincing your colleagues is far harder than finding a better tool. And sometimes the simplest tool is the only one that actually works. I don't get paper cuts anymore.