Excel has Get & Transform, formerly known as Power Query, which can do similar things... if a custom query language [1] instead of SQL doesn't scare you away. I

Excel has Get & Transform, formerly known as Power Query, which can do similar things... if a custom query language [1] instead of SQL doesn't scare you away. I have used it a few times, it can definitely be useful. [1]: https://msdn.microsoft.com/en-us/library/mt270258.aspx https://msdn.microsoft.com/en-us/library/mt270258.aspx