Have you heard of the Google Sheets query formula?
It allows you to use SQL (Structured Query Language, the code used to communicate with databases) style code to manipulate your data in Google Sheets and it’s super powerful. Arguably the most powerful function in Google Sheets.
Maybe you want to learn SQL, but don’t know where to start? You know it’s a super important data skill to master but it’s intimidating because you’ve never seen it before.
Well, here’s a first step you can take:
Try SQL out in a Google spreadsheet using the Google Sheets QUERY function – a familiar and easy environment!
(Note 1: There are a few minor differences which I explain in this tutorial.)
(Note 2: You may find you need to “straighten” the quotes in the formulas in this tutorial if you copy and paste them directly into your Google sheet, to avoid curly quotes which won’t work. You need straight quotes.)
Setting up your Google sheet
1. Go to this Google sheet containing the data we need.
2. Click into cell A1 and hit Ctrl + A (on PC) or Cmd + A (on Mac) to highlight the whole table.