WebAPI data connection to Excel
Modify the WebAPI default formatter from JSON to XML to enable Excel data connection. From the Excel client, add XML data source by URL, and easily view WebAPI HTTP GET data in table format. Ideal for power users, pivot tables, charts, and reporting needs.