This is basically what Powerquery is, and it's been built into Excel for years. And it does other things too.