PowerQueryNet allows you to run M formulas commonly used in Power BI and Excel (aka Get & Transform) from the Command Prompt or any .NET application.

Microsoft's spreadsheet program can do way more than you might realize. These are the hacks and tricks you need to know.