When you execute your query the results appear in the grid. You can click on the Excel button to get those results into Excel. The spreadsheet is saved in C:\Users\%username%\AppData\Local\Temp
How can you change the default file location?
The default cannot be changed initially. However, once you define the path to use for saving the excel file, ADS should use that path when saving subsequent excel files.