How to Convert Pivot Table to Data Table

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

A pivot table is a data summarization tool in spreadsheet software that allows you to quickly change the structure of the table by dragging and dropping field labels. The pivot table links to a larger table from which it gets its data. You may want to distribute the information in a pivot table to others without providing the underlying data table or the pivot table functionality. You can do this easily using only your mouse functions.


Step 1

Make sure your pivot table is updated with any changes made in the data table by clicking the "!" button (exclamation point button) on the pivot table toolbar.

Video of the Day

Step 2

Select the heading field values that you want the data table to display. These fields are just above the body of rectangular body of the pivot table, with the possible values appear in drop-down menus.


Step 3

Highlight with your mouse pointer the full area of the pivot table.

Step 4

Right-click your mouse (click the right button). A menu will pop up.

Step 5

Select "Copy."



Step 6

Select the cell where you want the data table to begin.

Step 7

Right-click your mouse while the pointer is over the selected cell.

Step 8

Select "Past Special." A panel will pop up.

Step 9

Select "Values" so that the spreadsheet pastes only the values. Click "OK."

Video of the Day