Tutorial: Proper Filtering and Sorting using Filter Views

Data often gets corrupted when people improperly sort information so they can group items together. Discover how Filters and Filtered Views can temporarily hide and sort your data without destroying its integrity .

Import Data from a Web Site Into Your Spreadsheet and Filter the Results

Quite often people will paste data from a site into their spreadsheet (think of game standings, lottery numbers, etc). The importHTML function in Google Sheets can automatically get the latest data from a page and insert it into your spreadsheet, where you can treat it as if it was text you pasted in

Once your content is in your spreadsheet, you can treat it as if it was text you pasted in. You can use it in formulas, sort it, and filter it.

Combining multiple Gmail filters into one

Gmail's filters and labels are an incredible powerful combination. Typically users create multiple filters and assign them to a single label, but you can easily combine a number of filters into one by using the OR command.

Just open one of your existing filters and add additional email addresses separated by OR with a space on either side (e.g. space-OR-space):

here@there.com OR me@round.com OR peter@parker.com

Creating Filter in Gmail to Flag your Newsletters

A couple of incredibly power features in GMail is filters and labels. With a few clicks, you can setup filters to quickly organize messages by assigning useful labels to them.

A handy filter I've created allows me to quickly identify Newsletters. These are messages I receive weekly or monthly that I quickly peruse and then delete:

• weekly flyer from Best Buy
• travel deals from Expedia
• Costco News
• YouTube notices (someone has subscribed to your channel)

Most people understand how to create filters and people will spend hours ensuring they have a filter setup to address each message. But there's a way you can combine a number of filters into one instead of creating individual filters.

Let's look at the list above. I want to create a filter that will assign the Newsletter label to any messages send by these companies. First I need to identify the return email address:

• Best Buy (newsletter@bestbuy.ca)
• Expedia (caenmail@expediamail.com)
• Costco News (costconews@online.costco.com)
• YouTube (noreply@youtube.com)

Normally you would create a single rule for each email. First you identify the criteria the filter is to look for:

Then you indicate the action that should be taken:

Now, instead of creating more filters that will do the same, you can combine all the email address together in the search criteria by separating each email with the word OR (in all caps).

Now I have one filter where I once had four! All that's left is to select all the messages, read through them and delete!  :-)

Tip: If you have a large number of emails to filter on, edit the list in a text editor (the filter field is very small). When the time comes, you can add your email at the beginning of the list.

What kind of message can you filter with this?