How to Export Pivot Table Data to Excel

Techwalla may earn compensation through affiliate links in this story. Learn more about our affiliate and product review process here.
Image Credit: Siri Stafford/Digital Vision/Getty Images

Microsoft Excel provides a wide range of features for manipulating and analyzing data. Traditional line, bar or pie charts simply plot points or tally data to visualize using a standard graphing template. Pivot tables are more versatile. These allow the user to focus on one or more particular fields of a spreadsheet and create a new type of spreadsheet table that displays all the other data in relationship to these chosen fields. While this is powerful in its own right, the pivot tables offer the additional ability to then export individual field results from the table into a new Excel spreadsheet.

Advertisement

Step 1

Load the Excel pivot table spreadsheet.

Video of the Day

Step 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.

Advertisement

Step 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.

Advertisement

Step 4

Click on the pivot table spreadsheet tab to return to the pivot table.

Advertisement

Step 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.

Video of the Day

Advertisement

Advertisement

references