Explore works differently in Google Sheets than it does in Google Docs. You can use it to get useful details about your data to help you analyze it. You can also use parts provided by the tool in your spreadsheet.
If you’re looking for a handy way to learn more about the data in your Google Sheets, here are several ways to use the Explore feature.
1. Ask questions about your data
When you first open the Explore tool in Google Sheets, you’ll see suggestions and have the option to ask your own questions at the top of the sidebar. In addition, the suggested questions give you a good idea of what you can ask yourself.
RELATED: How to use the MEDIAN function in Google Sheets
Here we have sales data per month for a handful of products. You can see that the Explore tool offers questions such as the top values in a given column, the lowest value in a particular column, and the middle value in another column.
The suggested questions you see vary based on your data. By default, we see these questions for our cell range A1 through F13. But you can select a certain range of cells and see different suggestions.
You can also ask your own questions, such as what is the correlation between two columns, the average of a column, or a corresponding column with the highest value. Type one in the Ask about this data box to see the results.
With each question you select or ask, a card is created in the sidebar. You can see each card by scrolling down. This gives you a nice history of questions and answers to reuse or review.
Tip: adjust cell range to get more responses
By default, the Explore function reads data from your sheet based on columns. This is important to keep in mind for questions because it affects what you can ask. But you can change this.
At the top of the sidebar, you’ll see the current cell range. Select “Edit” to change the range or choose whether your columns or rows contain headers. This determines how questions work.
Here, you’ll see that the suggestions correspond to our column headers in row 1, which are products.
If we change the tool to read the row headers in column A, you’ll see the options change to see the months instead.
By editing this section, you can see different suggested questions and ask your own questions based on where your headings reside.
2. View and use formulas
To accompany the suggested questions or the ones you ask yourself, you can see the formula that Explore uses to get the answer. Not only can you see the formula, but you can also drop it directly onto your sheet if you want to keep it.
RELATED: Google makes it easy to work with formulas in spreadsheets
Here, we ask for the average of Cases (column B). When you get the result, select “View formula”. You can then click on the formula to copy it to your clipboard and paste it wherever you like.
Alternatively, you can just drag the formula to a cell on your sheet.
3. Get quick calculations
Similar to the calculations you can see in the status bar at the bottom, you can see things like the sum, average, and median in the Explore sidebar.
RELATED: How to view basic calculations without formulas in Google Sheets
Select a range of cells and you’ll see these calculations displayed at the top of the sidebar above the questions section.
You can also drag one of the calculations to a cell on your sheet if you want to keep it.
4. View and insert charts
Another very useful feature of the Explore tool is the graphics it provides. When you see the sidebar, scroll down to the Analytics section. Depending on your data, you may see a few different types of charts.
To view the chart in a larger size, select the Zoom button or to add the chart to your sheet, select the Insert Chart button.
Along with the charts in the Analytics section of the sidebar, you can see others when you ask a question. For example, you can request the correlation between two columns. Select “Chart” and you will see a useful chart that you can simply view or insert into your sheet.
5. Review short summaries
To accompany some of the charts that the Explore tool creates for you, you can view helpful summaries. These can be helpful little snippets that summarize what you see on the chart.
6. Alternate Row Colors
One more useful feature you’ll see with Explore is the ability to color alternate rows on your sheet. This is just a handy place for this action instead of opening the menu.
RELATED: How to toggle row or column shading in Google Sheets
You will see the cell range below the option to confirm. Then choose one of the color schemes to apply the shading to.
Alternatively, select “Edit” to customize the colors of the alternate rows to your preference.
When you want to analyze your data in Google Sheets, consider the Explore feature for helpful insights, charts, and other tools.