Get instant insights into your data

" "

Tips

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.

Examples

  • 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 Open 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 Insert chart.
    4. Add a pivot table—Hover over a pivot table and click Insert pivot table Add table.
Was this helpful?
How can we improve it?