Microsoft Excel can be used to access Traffic Server data using its "Get External Data" capability (see Excel's help to find out more).

The following downloads are provided to assist in experimenting with this capability:

traffic.iqy, is a query file. Download the file. In Excel select Data->Get External Data->Run Saved Query. Specify traffic.iqy as the query to run, and you will be prompted for the different query parameters (or you can link them to cells in your spreadsheet).

tmquery.xls, is a basic query workbook for obtaining tabular results. Experiment with different query parameters and chart the results.

tmapps.xls, demonstrates how queries can be used to create mini applications.