In SL 2015, the quick query tool allows you to send data directly to an Excel pivot table.
1.In SL open the query you want to export to an Excel pivot table.
2. Click on the grid to Excel button on the top of the query window.
3. Click on the drop down and choose pivot table.
5. Confirm the worksheet name and the top left cell is correct, and click Create.
6. This will open your SL quick query in Excel in a pivot table design for you to modify as needed.