Google Sheets Duplicate Pivot Table: How to Copy One

Yes. In Google Sheets, the surest way to duplicate a pivot table and keep it editable is to duplicate the sheet that contains it: click the sheet tab’s menu arrow, choose Duplicate, then rename the copy. To make a second pivot on the same sheet, use Insert > Pivot table with the same source data and configure its fields.

What duplicating a pivot table actually means

A pivot table is a summary built from a source range, not just a formatted block of numbers. Its rows, columns, values, and filters determine how Sheets groups and calculates the source records. That distinction matters when you want a copy: duplicating the visible cells is not necessarily the same as duplicating the pivot table definition.

For example, a sales pivot might group orders by salesperson in rows, month in columns, and sum the order amounts in values. A true duplicate should preserve those choices so you can change a filter or add a field and still summarize the underlying records. A pasted set of displayed numbers, by contrast, may only be a snapshot.

Decide what you need before choosing a method:

A separate copy of a report sheet: duplicate the sheet. This is the most straightforward way to preserve the pivot and its surrounding layout.
A second pivot on the same sheet: insert a new pivot using the original data range, then set up its rows, columns, values, and filters.
A static snapshot: copy the displayed cells and paste values if you only need the current results, not an editable pivot.

Duplicate the sheet to preserve the existing pivot

When the pivot is already arranged the way you want, duplicating its sheet is usually the quickest option in Google Sheets in a web browser. The copied sheet keeps the existing pivot table and its placement, as well as other sheet content such as labels and formatting.

Find the sheet tab at the bottom of the spreadsheet.
Click the small menu arrow on that tab. If the tab is selected, you can also open its context menu.
Choose Duplicate. Sheets creates a copy of the sheet, typically named something like Copy of Pivot Report.
Rename the new tab and check that the pivot and any nearby report elements appear as expected.
Click inside the pivot table. The pivot table editor should open, letting you confirm that it remains a pivot rather than a block of ordinary cells.

This approach makes a whole-sheet copy, not just a pivot copy. If the original sheet contains notes, charts, or extra tables, those are copied too. Remove or update anything that should not appear in the second report. The duplicated pivot normally continues to use its original source range; duplicating the report sheet does not automatically create a new copy of the source data.

Create another pivot on the same sheet

If the two summaries need to sit beside each other or on one dashboard, create a separate pivot table rather than duplicating the whole sheet. Select the source data, choose Insert > Pivot table, and follow the dialog to choose the data range and where to put the result. Depending on the layout you want, choose a new sheet or an existing sheet and specify an empty starting cell.

In the pivot table editor, add the desired fields under Rows, Columns, Values, or Filters. For instance, keep Salesperson in Rows and Order amount in Values for one pivot, then make a second pivot that groups by Region and sums Order amount. Both can refer to the same records while answering different questions.

Leave enough clear space around an existing pivot before placing another one. Pivot results can grow when new categories appear in the source. If a second table is too close, the expanding output can collide with other content or produce an error. A separate sheet is often easier to manage when the pivot dimensions are unpredictable.

Copy and paste: when it works and what to check

You can try copying the pivot’s displayed range and pasting it elsewhere, but do not assume that the pasted result is a working duplicate. Copying a selection is a useful shortcut for moving content, yet the result you care about is whether the new location retains a pivot definition—not simply whether the numbers and formatting look identical.

Select the pivot output, copy it with Ctrl+C on Windows or ChromeOS (Command+C on Mac), click an empty destination cell, and paste with Ctrl+V (Command+V on Mac). Then click inside the pasted table. If the pivot table editor opens and shows the relevant fields, you can adjust the copied pivot. If it does not, treat the pasted block as ordinary cell content and create a real pivot using Insert > Pivot table instead.

Also make sure the destination area is empty. Pasting over cells can replace information, and a pivot table needs room to display its results. If you only need a one-time report image or fixed figures, a static copy may be appropriate; if you need interactive filtering or an automatically recalculated summary, preserve or create a pivot.

How the source range affects a duplicate

A duplicate pivot can look independent while still reading the same source records as the original. That is useful when both reports should reflect one data set. Changes made inside the included source range can affect the pivot’s results, but new rows added beyond a fixed range may not be included automatically. Check the range shown in the pivot table editor if newer records are missing.

For a different source, edit the data range in the pivot table editor or build a new pivot with the correct range. Before doing so, check that the source has a header row, consistent column names, and compatible data in each column. A date column containing a mixture of real dates and text, for example, may group or sort unexpectedly.

If you are making monthly reports, consider how the source is maintained. A range that ends at row 500 will not cover records later added below row 500. You can use a broader range when appropriate, but including large amounts of unused data may make the workbook harder to inspect. Verify the selected range after adding records rather than assuming a copied pivot has expanded its source.

Common problems and practical fixes

The duplicate shows the same totals as the original. That is expected when both pivots use the same source and settings. Change a row, column, filter, or value field in the second pivot to create a different view.
The copied area will not open the pivot editor. It may be a pasted snapshot rather than an editable pivot. Use Insert > Pivot table to build a new one from the source data.
The pivot is missing recent rows. Inspect its source range in the editor and extend it to include those records. Also check whether the new data is actually in the intended source sheet.
The new pivot cannot expand. Clear nearby cells or move the pivot to a less crowded location. Pivot output can change size as categories are added or removed.
Fields or totals look wrong. Check the source headers and data types, then review the field placement and the summary calculation in Values. A numeric field may need a different summary than a count, for example.
The duplicated report contains unwanted material. Duplicating a sheet copies the entire sheet. Remove unrelated content from the copy, or create a new pivot on a clean sheet instead.

Duplicating a pivot versus duplicating a sheet

These methods solve different problems. Duplicating a sheet is best when preserving the full report layout is important. It takes fewer setup steps and keeps the pivot configuration together with the surrounding sheet, but it also copies everything else on that tab. It is a good option for making a second version of a report, provided you know whether both reports should continue using the same source.

Creating a new pivot is better when you want a second analysis in a specific location or a clean report with only selected content. It takes longer because you must choose the fields and calculations again, but that setup makes the difference between the two summaries explicit. Copying and pasting is most suitable for moving or capturing visible output; verify the pasted result before relying on it as an editable pivot.

Google Sheets and Excel both offer pivot tables, but their interfaces and copy behavior are not identical. These steps are for Google Sheets in a browser: use its sheet-tab menu and Insert > Pivot table command. Do not assume that Excel ribbon commands or workbook behavior apply to a Google Sheets file.

Frequently Asked Questions

Can I duplicate a pivot table in Google Sheets without duplicating the whole sheet?
Yes. Create a second pivot with Insert > Pivot table and use the same source range. Set its fields in the pivot table editor. This gives you a separate summary without copying every other item on the original sheet.

Does duplicating a sheet duplicate its source data too?
It duplicates the sheet you selected, not necessarily the separate sheet that contains the pivot’s source records. The pivot in the copied report can continue to reference the original data range. Check the editor if you need the copy to use different records.

Will a duplicated pivot update when the source changes?
A pivot based on the same source can reflect changes within that source range. New records outside a fixed range may be excluded, so inspect the range when new rows are added. A pasted snapshot does not function like a connected pivot.

Can I put two pivot tables on one sheet?
Yes. Insert another pivot and choose an empty destination area on the existing sheet. Leave room for both tables to expand, or put one on a separate sheet to avoid overlap.

Why did copying the pivot give me only numbers?
The pasted selection may be ordinary cell content rather than an editable pivot table. Click within the pasted result to see whether the pivot table editor opens. If it does not, insert and configure a new pivot from the source range.

Can I make the duplicate use different data?
Yes. Change the data range in the pivot table editor or insert a new pivot and select the alternate source. Confirm that the new range has suitable headers and that the fields you want to summarize are present.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.