You can ask questions about the data in your spreadsheet. Based on your data, you’ll get suggestions for formatting, charts, and analysis.
Ask questions about your data
Note: This feature is only available in English.
- On your computer, open a spreadsheet in Google Sheets.
- At the bottom right, click Explore
.
- If you want to ask questions about data that’s on a different sheet, at the top right click Edit and make your changes.
- Under "Answers," enter your question in the box and press Enter.
- To find answers, click the question under the text box.
Questions you can ask:
- "Which person has the top score?"
- Make sure "person" and "score" are in your spreadsheet.
- "Total sales in September 2017?"
- Make sure "sales" and a "date" column are in your spreadsheet.
- "What’s the sum of price by salesperson?"
- Make sure "price" and "salesperson" are in your spreadsheet.
Questions that don’t work:
- Help questions like, "How do I bold this cell?"
- Web search questions like, "What’s the weather?"
Add alternating color backgrounds automatically
- On your computer, open a spreadsheet in Google Sheets.
- At the bottom right, click Explore
.
- Under "Formatting," choose an option.
Note: You can only add formatting to a spreadsheet if you have permission to edit the file.
Get charts & analysis automatically
- On your computer, open a spreadsheet in Google Sheets.
- To get info for specific data, select a range of cells.
- At the bottom right, click Explore
.
- If you want to get charts and analysis for data that’s on a different sheet, at the top right click Edit and make your changes.
- To see what data is being used in a chart, in the panel at the right, point to a chart.
Add a chart, formula, or pivot table to your spreadsheet
- On your computer, open a spreadsheet in Google Sheets.
- At the bottom right, click Explore
. If you want to get charts and analysis for data that’s on a different sheet, at the top right click Edit and make your changes.
- To add a chart, drag it to your spreadsheet.
- To add a formula, drag it to your spreadsheet.
- To add a pivot table, click Insert pivot table
.
Note: You can only add a chart, formula, or pivot table to a spreadsheet if you have permission to edit the file.
Can't find suggestions
If you open the Explore panel and don’t find any suggestions, make sure that:
- The spreadsheet or selected cell range isn’t empty.
- You’ve selected a range of data that contains numbers, repeated text, or another type of pattern. For example, a range of data with "Yes" / "No" form responses.