---
title: "How To Create A Pivot Table In Google Sheets"
h1: "How To Create A Pivot Table In Google Sheets"
description: "Learn how to create a pivot table in Google Sheets with our step-by-step guide. Simplify data analysis and enhance your spreadsheet skills today!"
route: "/learn/how-to-create-a-pivot-table-in-google-sheets"
canonical: "https://www.layerpath.com/learn/how-to-create-a-pivot-table-in-google-sheets"
---

# How To Create A Pivot Table In Google Sheets

Follow these steps to create a pivot table in Google Sheets. These instructions will guide you through the process of selecting your data range, setting up the pivot table, and customizing it to suit your needs.

### Interactive Layerpath tour

Canonical tour: https://share.layerpath.com/e/cm8rfc1gp008xji0cntsag25q/tour

Tour id: cm8rfc1gp008xji0cntsag25q

1. Open **Google Sheets** and select your data range.
2. Click on **Insert** in the top menu.
3. Choose **Pivot table** from the dropdown.
4. Select whether to place the pivot table in a **new sheet** or an **existing sheet**.
5. Click **Create** to generate the pivot table.
6. Use the **Pivot table editor** on the right to add **Rows, Columns, Values, and Filters**.
7. Customize and analyze your data as needed.