Important: Explore in Google Docs, Sheets, and Slides will no longer be available by January 30, 2024. You can use the tool finder in Docs, Sheets, and Slides to quickly get to actions like âconditional formattingâ in Sheets, âpagelessâ in Docs and âopen templatesâ in Slides. You can also enter â@â and select from a series of items to create content like:
- Dropdowns, emojis and people chips
- Meeting notes and email drafts in Docs
- Finance chips in Sheets
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.