I still needed an answer to this old question for a query from multiple tables and I came up with a good one. As others have stated, you can try the Export option under "Query results operations". As another other people noted, that does not always work and it may just give you all the rows from one table. That option did not work in my case. I also wanted something simpler than writing code to insert the results into a new table and then exporting that.
I found two easy ways to do this.
Method 1: Copy and paste
Check the "Show all" box above the results, highlight all the results, copy, and paste into a spreadsheet. That worked for me in Excel. However, the results preview truncates cell values that are too long. Therefore, this may not work for you if your cell values are long and you need the complete values.
Method 2: Create view
Under "Query results operations", there is an option to "Create view". Created views will appear below the database Tables in a new "Views" category. Views are basically persistent tables that show custom query results. Click "Create view", enter a name for the view and Go. Now you successfully use the Export option under "Query results operations" while in the View.