Google Sheets is one of the most intuitive and collaborative spreadsheet applications out there. Late March, its functionalities expanded even more by releasing a new feature: sort and filter cells by text or fill color. Unfortunately, Google Sheets’ connectivity and filter options do come with some limitations. For example, there is no built-in functionality with which you can filter by color between Google Sheets. For that reason, Sheetgo created the feature and therefore enables the possibility to filter data, solely based on the cell color, from one spreadsheet to the other. Learn how to filter by color by following the simple steps below.
Let’s get you started
Step 1. Install Sheetgo
Click on the button below to install the Sheetgo add-on for Google Sheets. First, sign in with your Google account. Second, complete the authorization steps, for Sheetgo to create your account simultaneously.
For the purpose of demonstration, let’s say we have a spreadsheet called “Template database”. It includes all relevant information about the templates you provide. But we need to export data from only the sales department templates (in the color blue) to the “Sales templates database” spreadsheet.
Step 2. Open the add-on
Inside your destination spreadsheet “Sales templates database”, go to Menu > Add-ons > Sheetgo > Start. After that, Sheetgo opens as a sidebar on your screen. Click on ‘Connect files’ to select your data source. In other words, select from which file you need to import the filtered data (in this case: “Template database”).
Step 3. Settings > filter by color
In the ‘Settings’ tab, give your connection the appropriate name (in this case: “Sales_Templates”) and enable the ‘Filter by’ option. Notice that here you can choose between Filter by query, Filter by condition, or Filter by color. Select the Filter by color option and choose which column you would like to filter (in this case: column A “Template”). After that, choose which color you want to filter out (in this case: blue).
Step 4. Save the connection
Finally, click on ‘Save connection’ to import only that specific data. As a result, Sheetgo creates a new tab “Sales_Templates” in your destination spreadsheet. Here you can now see the sales templates data, as we requested. Sheetgo has filtered out the “Template” column to only export the cells formatted in the color blue, as seen on the image below.
This is how you easily Filter by color in Google Sheets with Sheetgo! Check out the following blog post if you are curious about our other features that help boost your spreadsheet connectivity: how to track changes in Google Sheets.