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.
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.
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.â
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.
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.
To insert the chart into your spreadsheet, click âInsert Chartâ at the bottom of the pane.
If this isnât the chart you want, click the Back arrow to see the other suggestions available.
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.
To preview a chart and insert it into your spreadsheet, click the magnifying glass or the plus sign (+), respectively.
If you click âMore,â you see a few other charts and graphs that didnât fit in the Explore feature pane.
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.
Just like that, a pie chart is created showing the average Q2 sales by division.
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.
To insert a chart into your spreadsheet, simply click âInsert Chartâ under the current selection.
Your chart then appears in the current sheet. You can move and resize it however you want.