# how to create a pivot table in google sheets

Viewport: 1910x922 @1.125x

Playback: autoplay=false durationMs=3000 navBar=false arrows=true callouts=true browserBar=false browserTheme=light

1. [Intro] How to Create a Pivot Table in Google Sheets
   - body: 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.
   - voiceover: This guide will take you through the step-by-step process of creating a pivot table in Google Sheets. A pivot table helps you analyze and summarize large datasets efficiently.
   - audio: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8rfc1gp008xji0cntsag25q/cm8rgczba000a0cle3yr94p90.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
1. step_01 [image] - Open Google Sheets.
   - source type: IMAGE
   - description: Open Google Sheets
   - target: (486, 380), rect: top=165.7777862548828 left=46 width=1640 height=604
   - hotspots: 1
     - hotspot_01 (486, 380), rect: top=165.7777862548828 left=46 width=1640 height=604
   - dimensions: 1910x922 @1.125x
   - layout: 1 (full)
   - voiceover: Start by launching Google Sheets in your web browser. You can either open an existing spreadsheet or create a new one.
   - audio: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8rfc1gp008xji0cntsag25q/cm8rgd53u000c0cle1ujees4n.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8rfc1gp008xji0cntsag25q/cm8rfc67q000003hutnmaheft.png
2. step_02 [image] - Select Your Data – Highlight the dataset you want to analyze.
   - source type: IMAGE
   - description: Select the Data
   - target: (235.89625128308046, 268.28284330446564), rect: top=26 left=0 width=1697.77783203125 height=79
   - hotspots: 1
     - hotspot_01 (235.89625128308046, 268.28284330446564), rect: top=26 left=0 width=1697.77783203125 height=79
   - dimensions: 1910x922 @1.125x
   - layout: 1 (full)
   - voiceover: Highlight the dataset you want to analyze. Click and drag your mouse over the cells to ensure all relevant data is selected.
   - audio: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8rfc1gp008xji0cntsag25q/cm8rgd54c000d0cle5tjr6y9n.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8rfc1gp008xji0cntsag25q/cm8rfcg73000903hu7y0h6rbz.png
3. step_03 [image] - Click on Insert in the top menu.
   - source type: IMAGE
   - description: Navigate to the 'Data' menu
   - target: (194.24252196555418, 78.86642938841067), rect: top=34 left=179.6527862548828 width=53.63888931274414 height=23.55555534362793
   - hotspots: 1
     - hotspot_01 (194.24252196555418, 78.86642938841067), rect: top=34 left=179.6527862548828 width=53.63888931274414 height=23.55555534362793
   - dimensions: 1910x922 @1.125x
   - layout: 1 (full)
   - voiceover: Go to the top menu and click on the 'Insert' option to open a dropdown menu.
   - audio: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8rfc1gp008xji0cntsag25q/cm8rgd54v000e0cle732y5rc2.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8rfc1gp008xji0cntsag25q/cm8rfchpo000a03huhipcqaiy.png
4. step_04 [image] - In the dropdown menu click on Pivot table.
   - source type: IMAGE
   - description: Choose 'Pivot table'
   - target: (405, 300), rect: top=296.6666564941406 left=218.5416717529297 width=267 height=20
   - hotspots: 1
     - hotspot_01 (405, 300), rect: top=296.6666564941406 left=218.5416717529297 width=267 height=20
   - dimensions: 1910x922 @1.125x
   - layout: 1 (full)
   - voiceover: From the dropdown menu, select 'Pivot table' to initiate the process of creating a pivot table.
   - audio: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8rfc1gp008xji0cntsag25q/cm8rgd55f000f0cle7vdk92s0.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8rfc1gp008xji0cntsag25q/cm8rfcj75000b03huwm61evgf.png
5. step_05 [image] - Select "New sheet" (recommended) or "Existing sheet" and click Create.
   - source type: IMAGE
   - description: Confirm Data Range
   - target: (836.0349797613047, 414.37610263656086), rect: top=441.5555725097656 left=692.888916015625 width=16 height=16
   - hotspots: 1
     - hotspot_01 (836.0349797613047, 414.37610263656086), rect: top=441.5555725097656 left=692.888916015625 width=16 height=16
   - dimensions: 1910x922 @1.125x
   - layout: 1 (full)
   - voiceover: Choose where you want the pivot table to be created by selecting either 'New sheet' (recommended) or 'Existing sheet,' then click 'Create.'
   - audio: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8rfc1gp008xji0cntsag25q/cm8rgd55x000g0cleffu8cho5.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8rfc1gp008xji0cntsag25q/cm8rfcl9v000c03huxvaqwsme.png
6. step_06 [image] - Enter the value for sheets.
   - source type: IMAGE
   - description: Enter Data Range
   - target: (815.0298687455147, 468.89105376449), rect: top=476.4444580078125 left=714.888916015625 width=256 height=25
   - hotspots: 1
     - hotspot_01 (815.0298687455147, 468.89105376449), rect: top=476.4444580078125 left=714.888916015625 width=256 height=25
   - dimensions: 1910x922 @1.125x
   - layout: 1 (full)
   - voiceover: If required, enter the value for sheets where the pivot table should be placed.
   - audio: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8rfc1gp008xji0cntsag25q/cm8rgd56f000h0clea223a26v.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8rfc1gp008xji0cntsag25q/cm8rfcm0g000d03hubsy2ql3h.png
7. step_07 [image] - Then Click on Create.
   - source type: IMAGE
   - description: Click 'Create'
   - target: (1016.8416787047606, 583.4891934913242), rect: top=578.4444580078125 left=930.0694580078125 width=45.93055725097656 height=17.77777862548828
   - hotspots: 1
     - hotspot_01 (1016.8416787047606, 583.4891934913242), rect: top=578.4444580078125 left=930.0694580078125 width=45.93055725097656 height=17.77777862548828
   - dimensions: 1910x922 @1.125x
   - layout: 1 (full)
   - voiceover: Click 'Create' to generate the pivot table layout in the chosen sheet.
   - audio: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8rfc1gp008xji0cntsag25q/cm8rgd56w000i0cle1y1n63ec.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8rfc1gp008xji0cntsag25q/cm8rfdrk7000p03hurd4zkxnc.png
8. step_08 [image] - In the Pivot Table Editor, add:
Rows (e.g., "Product Name")
   - source type: IMAGE
   - description: Select Rows and Columns
   - target: (1183.3357313612805, 387.35149850491814), rect: top=373.3333435058594 left=1397.625 width=56.90277862548828 height=24
   - hotspots: 1
     - hotspot_01 (1183.3357313612805, 387.35149850491814), rect: top=373.3333435058594 left=1397.625 width=56.90277862548828 height=24
   - dimensions: 1910x922 @1.125x
   - layout: 1 (full)
   - voiceover: In the Pivot Table Editor on the right side of your screen, add the data fields to 'Rows' (e.g., 'Product Name').
   - audio: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8rfc1gp008xji0cntsag25q/cm8rgd57f000j0clehx1g55bc.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8rfc1gp008xji0cntsag25q/cm8rfdufe000q03huza0grb6d.png
9. step_09 [image] - In the Pivot Table Editor, add:
Rows (e.g
Columns (optional)
   - source type: IMAGE
   - description: Add Values
   - target: (1205.0387292520181, 633.891046742015), rect: top=641.6666870117188 left=1426.888916015625 width=56.11111068725586 height=16.88888931274414
   - hotspots: 1
     - hotspot_01 (1205.0387292520181, 633.891046742015), rect: top=641.6666870117188 left=1426.888916015625 width=56.11111068725586 height=16.88888931274414
   - dimensions: 1910x922 @1.125x
   - layout: 1 (full)
   - voiceover: If necessary, add data fields to 'Columns' in the Pivot Table Editor to further categorize your data.
   - audio: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8rfc1gp008xji0cntsag25q/cm8rgd57x000k0cle7ze68yki.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8rfc1gp008xji0cntsag25q/cm8rfe0iz000u03hu6ys9kfrn.png
10. step_10 [image] - Your pivot table is ready! 🎯 
   - source type: IMAGE
   - description: Customize the Pivot Table
   - target: (613.7805276108005, 599.1090028251461), rect: top=165.7777862548828 left=46 width=1148 height=604
   - hotspots: 1
     - hotspot_01 (613.7805276108005, 599.1090028251461), rect: top=165.7777862548828 left=46 width=1148 height=604
   - dimensions: 1910x922 @1.125x
   - layout: 1 (full)
   - voiceover: Your pivot table is now ready! 🎯 You can further customize it by adding values, filters, and more to suit your analysis needs.
   - audio: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8rfc1gp008xji0cntsag25q/cm8rgd58f000l0cle7vak16k2.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8rfc1gp008xji0cntsag25q/cm8rfe2js000v03huyq564ges.png
12. [Outro] All set 👍
   - body: You have successfully created a pivot table in Google Sheets. Now, you can customize it further, analyze your data, and generate insightful reports.
   - voiceover: Now that you have created your pivot table, you can begin analyzing your data by applying filters, changing data ranges, and utilizing other advanced features in Google Sheets.
   - audio: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8rfc1gp008xji0cntsag25q/cm8rgd2s7000b0clee1w3dq8w.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM

Source: https://share.layerpath.com/share/cm8rfc1gp008xji0cntsag25q/tour