Well this is really a job for a 20-30 line script. Python, perl whatever...
Don't know what your skill level with that sort of thing is, but even as a coding noob it may take less time to figure out how to write a python script than to do it all by hand. (And pick up an awesome skill for future problems like this at the same time)
(An experienced scripter could probably do it in 5 minutes if here is anyone like that in the company)