How to Export Pivot Table Data to Excel

1. Load the Excel pivot table spreadsheet.
2. View the table and decide which components of the pivot data you wish to export to a new Excel spreadsheet. The pivot table divides the spreadsheet data into multiple categories, based on the table's formatting. However, the table does not show the original data, only the summation information. You may wish to export all the original spreadsheet data rows that correspond to a particular number that appears on the pivot table.
3. Double-click on the chosen numerical result in the pivot table. A new spreadsheet is immediately created and all the corresponding data from the original data source is exported from the pivot table field into the new spreadsheet.
4. Click on the pivot table spreadsheet tab to return to the pivot table.
5. Double-click on any other table row's numerical result to create an additional, separate data export into another new Excel spreadsheet. Repeat this process as needed until all the separate pivot data you require is exported. Excel conveniently places each export into a new separate spreadsheet to keep the data sets independent of each other for further analysis.