How a Simple Spreadsheet Saved My Car Restoration Project

Anyone who has brought home a rusty, incomplete classic car knows the feeling. You have a vision, a garage, and a whole lot of boxes of parts labeled with masking tape. My project was a 1968 Mustang coupe I’d bought on a whim, a ‘barn find’ that was more barn than car. The initial excitement lasted about a week, until I opened the third cardboard box and realized I had no idea what half the bolts inside were for, or if the correct steering column was even in my possession. The project stalled before it even got on jack stands. I was buried in a physical puzzle with no picture on the box, and my notebook scribbles weren’t cutting it. I needed a system.

For a long time, I resisted the digital approach. I liked paper. I liked greasy fingerprints on a parts catalog. But my chaos was losing the battle. I started looking for a dedicated way to log parts, track progress, and manage the mountain of tasks. That’s when I found the system I use now at arssm.org. It wasn’t marketed as a car guy’s savior, which is probably why it worked. It was just a structured, accessible way to record information. I adapted it, and it changed everything.

I created a single sheet for the entire car. The first column was for the component: ‘Driver Side Door,’ ‘289 Engine Assembly,’ ‘Front Brake Lines.’ The next columns were for status. I used simple codes: ‘M’ for missing, ‘P’ for present but needs work, ‘R’ for restored, ‘N’ for new part needed. Suddenly, the overwhelming whole became a list of smaller, manageable problems. I discovered I had both front fenders, but one was from a different year. The ‘M’ next to ‘Original Air Cleaner’ saved me from buying a duplicate at a swap meet. This wasn’t just inventory; it was a strategic map.

From parts log to project manager

The real magic happened when I started using the notes field for each part. Instead of ‘fix door,’ an entry grew. ‘Window regulator binds. Source replacement springs (Part #C8ZZ-542…). Sand interior panel, primer spot on lower rust. Match paint code R-3.’ Each line was a tiny victory waiting to happen. On a rainy Saturday, I couldn’t work in the garage, but I could open my sheet. I’d scan for any task labeled ‘order part’ and spend an hour tracking down those springs. The project kept moving, even when I wasn’t turning a wrench. It killed the paralysis of not knowing where to start. I could pick a fifteen-minute task or a three-hour one, all clearly listed.

A fellow restorer came over once, lamenting his own stalled Camaro project. I showed him my screen. He pointed at my entry for the rear axle. ‘You have “clean and inspect bearings” and “new seal kit” as separate items?’ ‘Yes,’ I said. ‘That way, cleaning the bearings is a task I can do tonight after work. Ordering the seal kit is a two-minute phone call tomorrow.’ He got quiet. ‘I just have “rebuild rear end” written down,’ he said. ‘It feels like a mountain.’ That’s exactly it. The system breaks mountains into gravel you can move one shovel at a time.

The unexpected benefit: a story of the car

As months passed, the sheet became more than a tracker. It became the car’s biography. The notes field for the cylinder head read: ‘March 12: Heads back from machine shop. Valve job done. Note: Exhaust valve on #3 was cracked. Shop sourced a used one.’ That’s a piece of history. Future owners, or even future me fixing a problem, will have that data. When I finally installed the new-old-stock fuel sending unit, I noted the vendor and the date. This chronicle of the restoration became as valuable to me as the physical car. It documented the journey, the setbacks, and the solutions.

My system, built on that adaptable foundation, works because it’s simple and mine. I don’t use half the features a dedicated project management tool might offer. I need a list I can update from my phone in the garage and review from my laptop at the kitchen table. It keeps me honest and focused. The Mustang is now a running, driving car. It’s not perfect, but it’s mine, and I know every single part of its story because I wrote it down as I went.

If your project is languishing in a sea of disorganization, consider moving beyond the notepad. The goal isn’t complex software; it’s a clear, consistent, and accessible record. To get started, you only need a few basic categories. Focus on what actually matters for getting work done.

  • Component or Assembly: Be specific. Not “engine,” but “carburetor,” “valve covers,” “spark plug wires.”
  • Condition Status: Use a simple, consistent code you’ll remember. M/P/R/N worked for me.
  • Action Needed: The next concrete step. “Measure bolt length,” “Call Jeff for gasket,” “Degrease.”
  • Notes & History: The story log. Where parts came from, odd measurements, supplier contacts.
  • Priority: A simple 1-3 scale. Is this blocking the next major step, or is it a final detail?

The act of logging a part as ‘restored’ provides a small, concrete hit of accomplishment. That feeling fuels the next task. My spreadsheet didn’t tighten a single bolt, but it showed me exactly which bolt to tighten next. For a hobbyist buried in parts, that direction is everything.