Ask about your data & get suggested content


Want advanced Google Workspace features for your business?

Try Google Workspace today!

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.

  1. On your computer, open a spreadsheet in Google Sheets.
  2. At the bottom right, click Explore Explore.
  3. If you want to ask questions about data that’s on a different sheet, at the top right click Edit and make your changes.
  4. Under "Answers," enter your question in the box and press Enter.
  5. To find answers, click the question under the text box.

Add alternating color backgrounds automatically

  1. On your computer, open a spreadsheet in Google Sheets.
  2. At the bottom right, click Explore Explore.
  3. 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

  1. On your computer, open a spreadsheet in Google Sheets.
  2. To get info for specific data, select a range of cells.
  3. At the bottom right, click Explore Explore.
  4. 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.
  5. 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

  1. On your computer, open a spreadsheet in Google Sheets.
  2. At the bottom right, click Explore 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 Add.

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.

Related articles

true
Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

13510834474982538451
true
Search Help Center
true
true
true
true
true
35
false
false
false
Search
Clear search
Close search
Main menu