It was a straightforward request for information and if not already available in the manner requested in the FOI, tables could easily have been constructed from the source spreadsheet and then copied and pasted in a response.
Given the size of the file, it should have been obvious it contained a lot of data not relevant to the FOI request, even if some of the data or tabs were hidden.
Someone should have either checked or asked someone else with access to check the contents.