3 ms·

Google Sheets has a QUERY function which does exactly this. https://support.google.com/docs/answer/3093343?hl=en https://support.google.com/docs/answer/3093343

• samanator 8y ago
  This works for one offs. But performance is non-existent when you try to mock up google sheets as a database. I'm in the process of switching a company from google sheets + google sheets query to postgres. Loading one of their google sheets takes around 60 seconds. If they move around one of their 'id' columns it takes 5-10 minutes for everything to recalculate (also keep in mind that google offloads the computations onto the user's CPU...)