Last year I released
sql2xls, a free open-source tool which lets you throw a bunch of scripts into a folder, run them automatically against SQL Server and get the results back in a nicely-formatted Excel file, one tab per script.
A year later, I am happy to announce that the tool now runs cross-platform. You can compile and run it with .NET Core 3.1 LTS to run on Windows, macOS, and Linux. It uses the new
Microsoft.Data.SqlClientlibrary from NuGet, as well as the latest beta of
Read on for a few more tips and go check the project out.