Finding the files isn't too bad: Use File::Find and then use Spreadsheet::ParseExcel in your wanted function. You can modify the files with Spreadsheet::WriteExcel. Deleting a column won't be any trouble (I think); but the standardizing things probably will be.