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
Other People Are Reading
Things you need
- Google Docs account
Visit the Google Docs website at docs.google.com.
Log in to Google Docs using your Google account username and password if you are not already logged in to your Google account.
Click on the "Create New" button and select the "Spreadsheet" option from the list.
Enter or import all of your data.
Click on "View" and select "List."
Click on the drop-down box above each column to select the type of data you wish to query.
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.