Question: how to export data from pivot table?
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.