Hi, I have experienced a customer who used Excel Template, but I do not recommend this practice.
They use VBA to get Odata data to Excel sheet from NAV, then uses Power Query to organize the data, and finally uses VBA again to display it on the Template. It turns out to be very inefficient.
PS: If you use BC, Excel Template may be supported in BC20 next year.

Hope this will help.
Thanks
ZHU