Map Filter Tool

The Map Filter Tool pares heavy spreadsheet data down to only the rows you want plotted on the map, with 5 filter types fitted to how each column was built.

Create Your Map

Filtered Map Views From a Column

The Filter Tool reads every column header from your uploaded data and lets you pick which columns to filter and how. Each column gets its own pull-down menu and an on or off checkbox.

Group filter: Choose this for any column that holds categories, like region or status. The menu lists every value it finds in the column so you can keep or hide any value.

Text filter: Pick this for a column where you want to search inside the values, like store number or notes. You type a term and the map narrows to rows containing a match.

Number filter: Reach for this when the column holds numeric data only. The slider sets a low and high end from the lowest and highest values that the column contains.

Attribute filter: Use this for cells listing items inside a column, separated by semicolons. Maptive splits each entry into its own group you can toggle in the panel.

Date filter: Apply this to a date column to view rows inside a given date range. The control runs from the earliest date in your column to the latest date found there.

Per-column checkbox: Every column you set up gets its own checkbox in the panel. Uncheck to turn a filter off without losing the setup, recheck to bring it back to work.

Filter Your Map in 3 Steps

1

Open

Inside the map, click Map Tools, then pick the Filter Tool from the panel that opens up on the right side of the screen.

2

Build

Click Create Filters, find the column header you want to filter, open the pull-down beside it, and pick a filter type.

3

Read

The map now shows only the rows passing every filter you set, so you read the focused subset of points on your base map.

Filter Wins for Crowded Maps

Read a Crowded Map

A spreadsheet with thousands of rows turns your map into a wall of pins you cannot read. The Filter Tool pares the view down to the rows that match the columns you care about, working from the panel reached through Map Tools. Your base map keeps every row in memory, so you flip the view back the moment a filter is unchecked.
15 Best Online Mapping Software in 2026

Rank by Number Column

The Number filter handles size questions on any column of numeric data. You drag the slider against the lowest and highest values found in that column, and the map redraws to the band you set. Top accounts, the smallest counts, or any band in the middle show up plotted, with the rest dropping out of view until you change the range again.

Search Inside a Column

Hunting a keyword inside a long column of text values is slow inside a spreadsheet. Pick the Text filter on that column, type the term, and the map narrows to rows where the value contains a match. Use this on store numbers, SKU strings, account notes, or any column where the answer is a substring you can spell out yourself.

Split Multi-Value Cells

Some columns hold a list inside a single cell, with each item separated by a semicolon. The Attribute filter reads those semicolons and splits the cell into separate groups inside the panel. You toggle each group on or off, and the map shows rows that include the items you picked, with no spreadsheet rebuild needed first to make it work.

Hold a Date Window

Old records pile up in a date column and pull attention away from what is current right now. The Date filter sets a date range from the earliest date in your column to the latest date found in it, and the map redraws to that window only. Move the range to last month, this quarter, or any custom date pair you pick yourself.

Toggle Without Tearing Down

Every filter you build keeps its setup until you decide to take it back down. Uncheck the box on a column to drop that filter out of play, and recheck the same box to bring it right back. The Grouping Tool sits behind the same gear once filters exist, so you swap between segmenting and grouping in a shared panel together.

Filtering Map Data to Subsets

Why Filtering Pays Off

A map plots every row you upload by default, which is helpful at the start and noisy past a point. Once your data set carries thousands of rows across a dozen columns, the map turns dense and reading a segment off of it gets harder than it should be. The Filter Tool inside Maptive iQ pares the visible set down to only the rows you currently care about, working off the column headers already inside your data without any extra setup.

The wins come from the column-by-column setup. You pick a column, you pick how that column is built, and the right type of control loads in the panel for you. A category column gets a Group filter with an entry per value found in the column itself. A numeric column gets a slider that runs between the lowest and highest values inside that column. A date column gets a date range. A text column gets a search box. A multi-value column with semicolons gets the Attribute split.

The result is a map that holds every row in memory but plots only the rows passing the filters you have on at that moment. You read the focused subset against the same base map you started with, then toggle filters off through the per-column checkbox to bring rows back into play instantly.

The 5 Filter Types

Maptive supports 5 filter types, and each is built around a different kind of column you might have on your sheet. The Group filter is for category columns, where the values repeat across rows and you care about which categories you want plotted. The Text filter is for any column where you want to search inside the value itself, like a store number, a name, or any string you can spell out by typing.

The Number filter only works on numeric data, and it gives you a slider with the lowest value found in the column at the low end and the highest value at the top end. You drag the handles to set a low end and a high end. The Attribute filter is for cells that hold multiple items separated by semicolons, and Maptive splits those entries into their own groups inside the panel so you can keep some on and turn others off.

The Date filter rounds out the set. It reads the earliest date in your date column and the latest date in the same column, and it lets you set a date range between those endpoints. Each of the 5 types loads in the same panel through the pull-down beside the column header, with a checkbox that turns the rule on or off without removing the setup behind it.

Filtering With Other Tools

The Filter Tool lives in Map Tools, and it shares its panel with the Grouping Tool once filters or groups are in play on a map. After the first time you set a filter, the entry point switches from the Create Filters button over to the gear icon, and the same gear opens the Grouping Tool when grouping is active on the same map. Both tools sit side by side inside a shared panel.

The pair work on the same column headers but answer different questions. Filtering pares the visible row set down to a subset that fits a column rule, while grouping bundles plotted rows into named groups that you style and read together. You filter to a region, then group the surviving rows by status. You filter to a date range, then group the surviving rows by sales rep. The pairing keeps your map readable as the data set grows.

The per-column checkbox makes the pairing safe to play with. Uncheck a filter and the rows return without you rebuilding the rule from scratch. Recheck the same box and the rule applies again from the same panel. The setup carries through the session, so you compare a filtered view against the full data set, switch back to grouping, and read both views without losing work between passes.

Frequently Asked Questions

1How do I open the Filter Tool inside Maptive?
Inside the map, click Map Tools, then pick the Filter Tool from the panel that appears on the right side of the screen. The first time you reach for it on a map, you click the Create Filters button to open the column setup. After that first run, the same panel reopens through the gear icon, which also fronts the Grouping Tool when grouping is active. Either way, the panel lists every column header in your data and lets you pick a column to filter.
2What is the difference between the 5 filter types?
The Group filter handles category columns, where you keep or hide each unique value in the column. The Text filter searches inside a column for a substring you type. The Number filter offers a slider tied to the lowest and highest values found in a numeric column. The Attribute filter splits cells that list items separated by semicolons into their own groups. The Date filter sets a date range from the earliest date in a date column to the latest date found there.
3Can I have multiple filters on the map at the same time?
Yes, the Filter Tool lets you set up filters on as many of your column headers as you want, and each column has its own pull-down and its own checkbox in the same panel. Pick a filter type for each column you care about, and the panel keeps the setups side by side together. The Maptive support article does not state how the rules combine across columns, so plan to set up a couple, read the map, and adjust from there.
4How do I turn a filter off without losing it?
Each column you set up gets its own checkbox in the panel beside the column header itself. Uncheck the box and the rule on that column drops out, so the rows that were hidden by it return to the map view. The setup behind the rule stays in place. Recheck the same box and the same rule applies again on the map, with no rebuild work needed. Use the toggle to compare a filtered view against the full row set during a working session.
5Which filter type fits a column of dollar values?
Pick the Number filter. It only works on numeric data, and it loads a slider that runs from the lowest value found in the column at the low end to the highest value at the top end. Drag the handles to set a low and a high end, and the map redraws to plot only rows that fall inside the band. Use it for revenue, headcount, store square footage, drive distance, or any column where the value is a number you can rank.
6How do I search inside a text column on the map?
Pick the Text filter on that column. The article describes it as a search inside the values of a single column, like a store number or any string you can spell. Type the term you want to match, and the map narrows to rows where the value contains that term. Use it on store numbers, account names, SKU strings, or any text column where the answer is a substring of the cell. The other rows drop out of the view.
7Does the Attribute filter handle cells with multiple values?
Yes. The Attribute filter is built for cells that list multiple items inside a column, separated by semicolons in the data. Maptive reads those semicolons and splits each entry into its own group inside the panel. You toggle each group on or off, and the map shows the rows where the cell contains the items you have on. Use it for tag columns, services-offered columns, certification lists, or any column where a row carries multiple items inside the same cell.
8Can I filter on a date column by a custom range?
Yes. The Date filter reads the earliest date in your date column and the latest date in the same column, and it gives you a date range control between those endpoints of the column. Set the range to any date pair you want, like the last 30 days, this quarter, or a custom window for an audit. The map redraws to plot only the rows whose date sits inside that window, with the rest dropping out of view in the panel.
9Does Maptive group filtered rows on the map for me?
Grouping is a separate tool, the Grouping Tool, and it lives in the same panel as the Filter Tool once either is active on a map. Filtering pares your row set down to a subset that fits a column rule, while grouping bundles rows into named groups that you style and read together. After your first filter is set, the gear icon opens the same panel, so you can switch from setting up a filter to setting up a group on the map without leaving the panel.
10What happens to my data after I apply a filter?
Filtering is a view operation, so your uploaded data set sits intact on Maptive's side. The map plots only the rows passing the filters you have on, and the rest are held back from the view. Uncheck a filter, and the rows return.

Related Reading