How to Query a Google Spreadsheet

Written by katherine johnson
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Query a Google Spreadsheet
Google Docs allows queries only within spreadsheets. (Stockbyte/Stockbyte/Getty Images)

The Google Docs Spreadsheet program is not a database, but it does allow you to make queries. The query function used within Google Docs allows you to query your data using your spreadsheet's column IDs and referenced ranges that exist within your data. The query function used in Google Docs is somewhat limited because it does not allow SQL-like queries for inserts, deletes or updates. Instead, the Google Docs query function only allows you to pull data from your spreadsheet.

Skill level:
Moderately Easy

Things you need

  • Google Docs account

Show MoreHide


  1. 1

    Visit the Google Docs website at

  2. 2

    Log in to Google Docs using your Google account username and password if you are not already logged in to your Google account.

  3. 3

    Click on the "Create New" button and select the "Spreadsheet" option from the list.

  4. 4

    Enter or import all of your data.

  5. 5

    Click on "View" and select "List."

  6. 6

    Click on the drop-down box above each column to select the type of data you wish to query.

  7. 7

    Return to your spreadsheet after you have finished your queries by clicking on the "Go to Spreadsheet View" link at the top of the screen.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.