Filter the Pins on Your Maps

Customize your map views to visualize business opportunities

Customize your map views to visualize business opportunities

Map filters allow you to show or hide location pins on your map Excel data according to distinct characteristics. Just plot pins on a map, filter what you want to focus on, and easily visualize your data to identify business opportunities you could not see before. Here’s an example of how this works:

Let’s say you are an insurance company and have data about their policy types: Policy A, Policy B, and Policy C. Now, once you categorize your customers according to their policy type, you can apply filters! You would just add a column in your Excel spreadsheet with the policy category. When you paste in your data and create maps with pins, be sure to include the policy column. Now that you have your map, you can click the filter icon in the left sidebar to see all the columns from your spreadsheet. Expand any of your categories and you will see the options available to show or hide locations with those attributes.

Steps to apply filters to map pins

  1. Open you map.
  2. Click the drop down menu next to your dataset.
  3. Select “Filter.”
  4. Click “New Filter.”
  5. Select whether to filter by a “Checkbox” or “Formulas.”
  6. Select a column in your spreadsheet in the “Category” drop down.
  7. Check and uncheck boxes if using “Checkbox” filter type. Enter your formulas if using the “Formulas” filter type.
  8. Click “OK.”
  9. Repeat steps 4-8 to add an additional filter or click “OK” to finish.

What are you waiting for?

Start Mapping