Excel sheets are built visually so there is absolutely no sane way to parse them. Just the same thing as trying to restructure a pdf at the end of the day.
Yeah this is what Microsoft is trying to do with copilot.
But they couldn't figure it out either so it's limited to data formatted as table.
They’ve removed that limitation now, I think. That said, I still haven’t found any use-case for Copilot within an Excel workbook that works (probably because I’ve only ever asked it to do very difficult things since I don’t need it for easy stuff). So there’s that.