Les feuilles de calcul offrent de puissantes capacités d’analyse, mais on a parfois l’impression qu’il leur manque une couche supplémentaire d’aperçu. Lorsqu’il y a une quantité massive de données, il est difficile de résumer ou de tirer des conclusions à partir d’une vue de base d’une feuille de calcul.
That's where pivot tables come in. Most Excel power users use pivot tables as their bread and butter. But you can also use pivot tables in Google Sheets.
Here, I'll walk you through how to create and use pivot tables in Google Sheets.
Table des matières:
Vous hésitez entre Microsoft Excel et Google Sheets ? Consultez notre présentation d’appli pour savoir laquelle vous convient le mieux : Google Sheets versus Excel.
Qu’est-ce qu’un tableau croisé dynamique dans Google Sheets ?
A pivot table in Google Sheets is a built-in spreadsheet tool that lets you reorganize, summarize, and analyze large datasets based on whatever dimensions you choose.
Think of it this way. Normal spreadsheets typically have "flat data" represented by two axes: horizontal (columns) and vertical (rows). For example, a sales team might track their sales in individual rows, with each column offering different information about that sale. A pivot table shifts (or pivots) those axes to introduce a third dimension. So instead of looking at individual sales, you can see aggregated data like how many units each sales rep sold per product.
While you could pull many of these insights using formulas, the pivot table allows you to distill it in a fraction of the time and with less chance for human error.
How to create a pivot table in Google Sheets using Gemini
The mechanics of creating a pivot table in Google Sheets are pretty straightforward. Knowing which elements to plug in where—so your pivot table actually surfaces the information you care about—is a different story.
If you want to save yourself the headache, just tell Gemini what you want to know, and it'll build the pivot table for you.
Here's what Gemini created when I asked it to create a pivot table and tell me how much we billed in 2025 for each client across different project types. (It's one sentence versus the multiple steps I'm about to walk you through for the same results.) Gemini even automatically generated a summary of how the data was used to build the pivot table.
How to create a pivot table in Google Sheets manually
If you're more of a DIY-er, respect—I admire the commitment and wish I had it. Here's how to create a Google Sheets pivot table step by step.
As a reminder, this is the question we're asking: How much did we bill in 2025 for each client across different project types? To follow along, grab our demo spreadsheet.
Select the dataset, including the column headers, that you want to summarize or analyze. If your data set contains columns without headers, you'll need to name these columns in order to create a pivot table.
Cliquez sur Insérer, puis sélectionnez Tableau croisé dynamique.
In the Create pivot table panel that appears, choose if you want to insert your pivot table into a new sheet or an existing sheet. Then click Create.
In the Pivot table editor panel that appears, you'll see a few elements you can add to configure your pivot table.
Rows: Choose which field you want to list down the left side of your pivot table. Google Sheets will pull every unique value from that field and stack them as rows. In our example, that's Client Name, so each client gets its own row.
Columns: Choose which field you want to spread across the top of your table. Each unique value will become its own column header. In our example, that's Project Type, so each project type gets its own column.
Values: Choose what number you want to see where each row and column meet. You can show these values in different ways (sum, average, count) depending on the value type. In our example, we want the SUM of Amount Billed, so each cell shows the total billed for that client and project type.
Filters: Choose a field to limit which data gets included in your table at all. In our example, we filter by Year and select only 2025.
That's it! Now you have a pivot table that answers the question, "How much did we bill in 2025 for each client across different project types?"
Comment actualiser un tableau croisé dynamique dans Google Sheets
Let's say you've edited your original source data. These changes should automatically be reflected in your pivot table. If you don't see the changes reflected, refresh your web page. It may take a minute depending on the volume of data.
If you've added new rows or columns of data to your original source data, however, a simple refresh won't do the trick. Instead, you need to update your pivot table's data range to include the new rows or columns.
Passez la souris sur le tableau croisé dynamique, puis cliquez sur Modifier.
Click the Select data range icon at the top of the panel, and enter your new data range.
Comment créer et utiliser des tableaux croisés dynamiques dans Google Sheets : FAQ
Vous avez encore des questions sur l’utilisation des tableaux croisés dynamiques dans Google Sheets ? Consultez les réponses à ces questions fréquemment posées afin de tirer le meilleur parti de vos feuilles de calcul.
Les tableaux croisés dynamiques sont-ils mis à jour automatiquement dans Google Sheets ?
Yes, with one caveat. If you edit existing cells within your data range, changes will automatically show up in your pivot table. If you add new rows or columns outside of it, you'll need to manually update the data range first.
Un tableau croisé dynamique peut-il être extrait de plusieurs feuilles de travail ?
Les tableaux croisés dynamiques dans Google Sheets ne peuvent faire référence qu’à une seule feuille de calcul. Si vous souhaitez que votre tableau croisé dynamique fasse référence aux données de plusieurs feuilles de calcul, vous devez d’abord combiner ces données en une seule feuille de calcul. Ensuite, tu peux créer un tableau croisé dynamique comme tu le ferais normalement.
Peux-tu avoir deux tableaux croisés dynamiques sur une seule feuille ?
Vous pouvez insérer plusieurs tableaux croisés dynamiques dans une seule feuille de calcul Google Sheets.
Crée un tableau croisé dynamique comme tu le ferais normalement.
Dans le panneau Créer un tableau croisé dynamique qui apparaît, sélectionne Feuille existante, puis saisit la feuille de calcul et la cellule dans lesquelles tu souhaites ajouter ton nouveau tableau croisé dynamique.
Cliquez sur Créer.
Peux-tu fusionner deux tableaux croisés dynamiques ?
Il n’existe aucun moyen de fusionner deux tableaux croisés dynamiques dans Google Sheets, mais il existe une solution de contournement. Combinez les données sources d’origine des deux tableaux croisés dynamiques dans une seule feuille de calcul, puis créez un nouveau tableau croisé dynamique.
Automatisez Google Sheets avec Zapier
Pivot tables are only as good as the data behind them. Zapier connects Google Sheets to 9,000+ apps, so you can automatically pull in data from wherever you need it, including form submissions, CRM updates, and ad leads.
And if you're already working in Claude, ChatGPT, or another AI tool, Zapier MCP lets you go further: you can ask your AI assistant to pull data from your connected apps, update your spreadsheet, or practically anything else you can think of, all without leaving your chat window. You could even ask it to figure out which client you billed the most in 2025, pull up their contract in Docusign, and draft a renewal email. Discover more ways to automate Google Sheets.
Lectures complémentaires :
This article was originally published in September 2018 by John Thomas. The most recent update was in June 2026.
