The Google Sheets logo.

The Explore feature in Google Sheets helps you gain insight from the data in your spreadsheets with the power of machine learning. Explore automatically analyzes everything in Sheets to make visualizing data easier.

Explore for Sheets takes away a lot of the stress and guesswork when you deal with large data sets in your spreadsheet. Simply open it and choose a suggested chart, graph, or pivot table to insert into your spreadsheet. You can also “ask” to create charts that are not automatically suggested.

To get started, fire up your browser, head to your Google Sheets homepage, and open a file with a few data sets.

A spreadsheet in Google Sheets.

In the bottom-right corner, click “Explore” or use the Alt+Shift+X (Windows/ChromeOS) or Option+Shift+X (macOS) keyboard shortcut to open the Explore pane.

RELATED: All the Best Google Sheets Keyboard Shortcuts

Click "Explore."

By default, Explore analyzes the whole sheet’s data sets, but you can isolate specific columns or rows if you highlight them before you click “Explore.”

When you open Explore, you see four sections: “Answers,” “Formatting,” “Pivot Table,” and “Analysis.” In “Formatting,” you can change the color scheme of your sheet with the click of a button, and in “Pivot Table,” you can insert a pivot table into your spreadsheet. We’ll focus on “Answers” and “Analysis.”

RELATED: What are Pivot Tables in Google Sheets, and How Do I Use Them

At the top, under the “Answers” section, you see a few suggestions under the text box—which we’ll cover later. These questions are produced by the AI as optional ideas to get you started; click a link to preview one of the questions the AI conceived.

Suggested questions in the "Answers" section of Explore.

After you click a suggested question, Explore automatically creates a chart based on the criteria listed. In this example, it created a column chart to show sales by division.

A column chart showing sales by division in the "Answers" section of Explore.

To insert the chart into your spreadsheet, click “Insert Chart” at the bottom of the pane.

Click "Insert Chart."

If this isn’t the chart you want, click the Back arrow to see the other suggestions available.

Click the Back arrow to return to the previous menu.

Scroll down until you see the Analysis section. Here, you’ll find premade charts and stats from the data sets you chose earlier. Explore analyzes this data, and then chooses the best way to view it as a chart.

Premade charts in the "Analysis" section of Explore.

To preview a chart and insert it into your spreadsheet, click the magnifying glass or the plus sign (+), respectively.

Click the magnifying glass to preview a chart or click the plus sign (+) to insert it into your spreadsheet.

If you click “More,” you see a few other charts and graphs that didn’t fit in the Explore feature pane.

Click "More" to see more premade charts.

If none of the questions or premade charts will work, you can type a custom query in the text field at the top to get a specific answer. For example, if we want to see each division’s average sales for Q2 in a pie chart, we can type, “Pie chart average of Q2 for each division,” into the text field and press Enter.

An example of a custom question typed in the text box.

Just like that, a pie chart is created showing the average Q2 sales by division.

A pie chart generated by Explore based on a sample query.

Depending on the data you choose and how it’s displayed, Explore might have a few other charts to view your data sets. You can click “Pivot Table” or “Chart” and select the type of chart you want from the drop-down menu.

Click "Pivot Table" or "Chart," and then select the type of chart you want from the list.

To insert a chart into your spreadsheet, simply click “Insert Chart” under the current selection.

Click "Insert Chart."

Your chart then appears in the current sheet. You can move and resize it however you want.

A pie chart in a spreadsheet.

Brady Gavin Brady Gavin
Brady Gavin has been immersed in technology for 15 years and has written over 150 detailed tutorials and explainers. He's covered everything from Windows 10 registry hacks to Chrome browser tips. Brady has a diploma in Computer Science from Camosun College in Victoria, BC.  
Read Full Bio »