Filter by color Google Sheets

Google Sheets is one of the most intuitive and collaborative spreadsheet applications out there.  Unfortunately, it does come with some limitations. For example, there is no built-in functionality with which you can filter by color in 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.

How it works

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.

Example

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”).

Example

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).

Example

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.

Example

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.

Share This