17 Collecting Data SQL

Data Collection, Selecting, Sorting, and Publishing

Google Forms allows a person with a Google account to collect data and import it into a Google Sheet. Once it is in a Google Sheet the =query(data, "select ...", heading) command allows the user to select, sort, and publish that organized information to the Web. This is one of the most power systems for an ordinary person to collect, organize, and publish data.

Sample Google Form to Collect Data

Reference for Using Google Sheets =query() Function

Google Query Function Basics

Sample Google Sheet that uses the =query() Function in Different Sheets

Utah HS w Addresses

Online Google Query Resources

Google Spreadsheet Query Resources