How to Filter Data in Google Sheets

As a marketer, I know the importance of analyzing data in making sound business decisions. But let's be real, going through a huge amount of data can be daunting. Fortunately, Google Sheets offers a range of features that make it easier to filter through loads of data and organize them in a way that makes sense. In this article, I’ll show you how to filter data in Google Sheets in simple, easy steps.

Step 1: Open your Google Sheets file

The first step in filtering data is to open your Google Sheets file. If you don't have one, go ahead and create a new Google Sheets document. To access Google Sheets, simply visit and click on 'Blank' to create a new sheet. You can also create a new document directly from your Google Drive.

Step 2: Select the data range

After opening your Google Sheets document, the next step is to select the range of data you want to filter. A range is a selection of cells, and you can select a range by either clicking and dragging your mouse or using the shift key and arrow buttons on your keyboard. You can also name your data range for easy filtering in the future.

Step 3: Click on the 'Filter' button

The 'Filter' button is located on the top right corner of your Google Sheets document. It’s the icon that looks like a funnel. Clicking on this button will bring up a drop-down menu with filter options.

Step 4: Choose your filter options

Once you've clicked on the 'Filter' button, the next step is to choose your filter options. You can filter data based on the following criteria:

  • Text
  • Number
  • Date
  • Wildcard
  • Checkbox
  • Condition

To filter data based on a specific criteria, click on the filter button and select the criteria that you want to use. You can then enter your filter criteria into the appropriate field.

Step 5: Apply your filter

After selecting your filter criteria, click on the 'Apply' button to apply your filter. Your data will now be organized based on the criteria you have selected.

Step 6: Sort your filtered data

If you want to sort your filtered data, click on the header of the column you want to sort by. Clicking on the header for a second time will change the sort order from ascending to descending.

Step 7: Clear your filter

To remove your filter and restore your data to its original state, simply click on the 'Filter' button and select 'Clear filter'.


Filtering data in Google Sheets is a powerful way to organize large amounts of data and make it easier to analyze. By following the steps outlined in this article, you can apply filters and sort your data to find the information you need quickly. With practice, you'll be able to use these filtering tools to elevate your data game and make more informed business decisions.

By clicking “Accept”, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts. View our Privacy Policy for more information.