How to Convert Pivot Table to Data Table

By Paul Dohrman

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.

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

Tips & Warnings

  • To help with formatting, you could highlight the columns that the pivot table is in, select "Copy," and paste the pivot table’s formatting into the area you want the data table before then copying and pasting the data.