How do I use filter or query to reduce the size of my sheets?

Google Sheets does not handle well heavy sheets with a lot of data. When working with large datasets, Google Sheets can behave very slowly, unreliable and even crash your browser. The solution is to select only a fraction instead of the entire sheet. This feature is called filter or query. You can access filter when editing or creating a connection. Filter comes with two modes which are explained below. 

1. Filter by condition

This allows you to only import those rows whose value match a condition defined for a specific column.

2. Filter by query

This allows you to select your data using an SQL-like query statement. This allows you to perform various operations prior to connecting. Please familiarise yourself with the official query documentation.

This will only select columns A, B and E of the connected sheet.

Have more questions? Submit a request


Please sign in to leave a comment.