Question: how to export pivot table data to excel?
Answer: Generate the Pivot Table with the data that you would like to export.
Select the Download > Microsoft Excel option when exporting data from the pivot tables.
Once that option is selected, it will generate the file and save it to your computer.
Open the Microsoft Excel file.