Working with remote and in-office colleagues? Learn how to thrive in hybrid work environments.

Get instant insights into your data



A spreadsheet full of data can be daunting. Get summaries and charts of your data with the click of a button in Google Sheets. It’s kind of like having an expert in data analysis sitting next to you.


  • Find patterns in your data with instant charts.
  • Get automatic suggestions for pivot tables based on your data.
  • Ask questions about your data and get immediate answers. Answers can include suggested charts, pivot tables, and formulas. (English only)
  • Quickly graph a subset of your data by selecting only the cells or columns you’re interested in.

Start exploring your data""

  1. In Sheets, open a spreadsheet with data.
  2. Select a range of cells, columns, or rows. Otherwise, you’ll get insights based on where your cursor is.
  3. At the bottom, click Explore "".
  4. Depending on the data in the sheet, you can:
    1. See which data a chart is based on—Hover over a chart to highlight its data in the spreadsheet.
    2. Ask questions about your data—Enter a search or choose a suggested question. If your answer includes a formula, you can drag it into a cell to add it.
    3. Add a chart—Hover over a chart and click Insert chart "".
    4. Add a pivot table—Hover over a pivot table and click Insert pivot table "".
Was this helpful?
How can we improve it?
Get help from Small Business Advisors

Want to receive one-on-one guidance and tailored recommendations on how to make the most out of your Business Profile? Try booking an appointment with Small Business Advisors.

Important: This service cannot troubleshoot issues, including Business Profile verification or suspension, or Google Ads billing.

Clear search
Close search
Google apps
Main menu
Search Help Center