Question: how to export data from a pivot table?
Answer: Open the Pivot Table that you would like to export.
Select Export button in the toolbar.
Select one of the five export format options: ... 
In the export settings window that opens, set the required options and then click Export button at the bottom to export.