An Excel add-in that converts selected cells to Kusto datatable syntax.
This add-in is not published to the Office Add-ins Store, so it won't appear when you browse for add-ins in Excel. Instead, you'll need to "sideload" it manually using a trusted catalog. This is a one-time setup process that takes just a few minutes. You do not need to run a local server because the files are hosted at microsoft.github.io/excel-to-kusto-datatable.
Once sideloaded, the add-in works exactly like any other Excel add-in. It appears in the ribbon, persists across sessions, and can be used whenever you need it.
These instructions are for Windows, but if you have trouble or need other platforms (including Office on the web), see the official Microsoft documentation on Sideloading Office Add-ins.
- Download the manifest.xml to your machine in a folder like c:\ExcelAddins
- From Windows Explorer, right click on the ExcelAddins folder and select Give Access To →
Specific People to create a network share for yourself. Note the network share path (e.g.,
\\localhost\ExcelAddins) - In Excel: File → Options → Trust Center → Trust Center Settings
- Go to Trusted Add-in Catalogs → Add the network share path (e.g.,
\\localhost\ExcelAddins) and check the box for "Show in Menu" - Restart Excel
- Go to Home → Add-ins → Advanced → Select the add-in
- Verify that the add-in button appears in the Data tab under the Kusto group
- Select cells in Excel. To combine non-adjacent columns, hold Ctrl on Windows or Command on Mac while selecting ranges that cover the same rows.
- Click the "To Datatable" button in the Data tab
- The task pane opens with the Kusto datatable output
- Copy the output to clipboard and paste into a Kusto query
Non-adjacent selections are combined from left to right and must have matching start and end rows. This feature requires ExcelApi 1.9. Older Excel versions can continue to convert one contiguous range.
See Contributing for more information.
This project may contain trademarks or logos for projects, products, or services. Authorized use of Microsoft trademarks or logos is subject to and must follow Microsoft's Trademark & Brand Guidelines. Use of Microsoft trademarks or logos in modified versions of this project must not cause confusion or imply Microsoft sponsorship. Any use of third-party trademarks or logos are subject to those third-party's policies.