This is the biggest downside of the spreadsheet... there isn't any nice way to copy badges across, or import updates to the master copy... I include the patch notes so that people can replay the changes manually, which seems like the easiest option most of the time, but when named ranges change, etc... it can break things... it's a real pain.
The good news is, I've been working on a dedicated tool to replace the spreadsheet which won't have any of those problems. I'll hopefully have it ready for testing in a couple of days... though I've only managed to add 500 or so badges to it so far... It also includes all the badge text and icons, so collating all the badge data is taking me foreeeever.
Initially it's just a single-page app, storing everything in local storage, but I'd like to move it to a full cloud-backed site in the near future... but I've burned through most of my holiday time just getting this far 😛