Please let us know below the article if you found it helpful. Thank you!
Each connection supports 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.