Filter Your Buildings by Class, Size, Occupancy and Rent
Maptive turns the columns in your property list into marker colors and filters, so the map shows only the buildings that match the class, size, occupancy or rent you set.
No credit card required
- Color markers by building class, or by a status like keep versus sell, with the Grouping Tool.
- Band cap rates into ranges you choose and give each band its own bubble color on the map.
- Drag a Number filter slider to keep only the buildings inside the size range you care about.
- Set a Date filter to show every property with a lease or loan maturing in the next 24 months.
- Stack a class filter on top of an occupancy filter to build a watch list from the whole portfolio.
- Export the filtered buildings to .xlsx or .csv and hand the list to your leasing or dispositions team.
Trusted by teams at
Cutting a Long Property List Down to the Few That Fit
I love the heat map, and the sharing capability is very efficient. The initial data upload is easy and the settings are intuitive.
Turning Spreadsheet Columns Into Map Controls in Maptive
- 1
Clean the Data Before Upload
Store square feet, rent, cap rate and occupancy as plain numbers with no currency or percent symbols, and keep lease dates as real dates so Maptive treats them that way. Convert every asking rent to the same basis, either full service gross or triple net. Then upload the property list or availability export you work from, and geocoding places each building.
- 2
Color by Category and Range
In the Grouping Tool, pick the Class column, then hit Group Now so each building class gets its own color. Add cap rate as a secondary group, choose Numeric, set the ranges, then pick Multi color bubbles. The pins now show quality by color and yield by bubble, and the legend explains both to anyone who opens the map.
- 3
Set the Conditions
In Map Tools, open the Filter Tool and click Create Filters. Use a Number filter on square feet, a Group filter on class and a Date filter on lease expiration, each set from the dropdown beside its column. Only buildings that pass every active filter remain on the map, and a column’s checkbox turns its filter off without losing the settings.
- 4
Save, Export and Share
Filters reset when you refresh the page, so save each question you come back to, such as a Class B watch list, as a map view. From the Export Data icon, choose Export Filtered Data and download .xlsx or .csv for the team that acts on it. When an owner or lender wants to click through the buildings, send a read-only link instead of a spreadsheet.
Try It on the Assets You Manage
Bring your building list into a free 10-day trial. No credit card is required. If your data comes from more than one system, a Maptive specialist can help you line up the columns on a demo.
No credit card required
Frequently Asked Questions
How do I color-code my properties by cap rate or status?
Status values like Keep or Sell work best as distinct colors that don’t suggest an order, while cap rate is easier to read as a light-to-dark scale where darker means higher yield. In the Grouping Tool, choose Numeric for cap rate and set the breakpoints yourself at values that mean something to your fund, such as your target return or the submarket’s going-in rate, instead of accepting even splits. The percentages option puts a similar number of buildings in each band, which helps when most of the portfolio is bunched in a narrow range.
Can I filter my building map by square footage and price per square foot?
Yes. Each of those columns gets its own Number filter in the Filter Tool. A slider covers the lowest to the highest value in your data, and you drag the two handles to set the low and high ends for size and for price. The map keeps only buildings that pass both filters. Check that those columns hold plain numbers, because a cell typed as $150/SF is text and won’t behave like a number in the filter.
Why does my asking rent filter give odd results?
Usually because the rents in the list aren’t quoted the same way. Office space is commonly quoted full service gross. Industrial and retail space is commonly quoted triple net, so a $28 gross rent and a $28 net rent are two different costs to a tenant. In some markets, Southern California industrial for one, asking rents are quoted per month instead of per year. Some lists also mix rentable and usable square feet. Pick one basis, convert every row to it in the spreadsheet, and add a Rent Basis column so anyone reading the map knows which number they’re filtering.
How should I assign building class before I map it?
Building class is a judgment against the local market, so a Class A tower in a small city might rate as Class B downtown in a major metro. Pick one source for the grade, such as the rating in your CoStar export or your own research team’s call, and apply it the same way across the portfolio. If your team disagrees with the third-party grade, keep both in separate columns. You can then group by either one in Maptive and compare where your view and the database’s view of a building differ.
What filters help with a hold or sell review?
Lease rollover in the next few years and expected capital spending are good first filters, with occupancy close behind. Put each in its own column, then filter for the combination your fund uses as its sale screen. The map shows the result by location, so you can see when several sale candidates share a submarket and could go to market together or would compete for the same buyers. Export the filtered list to start the cash flow work in your model.
How do corporate real estate teams use owned versus leased filters?
A company with offices or plants in many markets usually owns some sites and leases others, each with its own decision dates. Group by Owned or Leased, then narrow the leased side to expirations 18 to 24 months ahead, since that’s about how long a team needs to weigh renewal against relocation and still negotiate from a good position. On the owned side, filter for low headcount or low use per square foot to find sites worth reviewing for consolidation or a sale-leaseback.
Can I filter on more than one value stored in a single cell?
Yes, with the Attribute filter. Type several values into one cell with a semicolon between each, for example the amenities or zoning tags you track, and Maptive treats each value as its own option you can switch on or off. That lets one building appear under every tag it has, which a normal category column can’t do. Maptive doesn’t supply zoning or amenity data, so these values come from your own records or the property database you already use.
Do my filters stay set when I share the map?
They do once you set them up for sharing. Each filtered column needs a filter type set before you share, or the people you share with can’t use that filter. You can also turn tools like the Filter Tool on or off on a shared map, and hide columns such as basis or debt terms that an outside viewer shouldn’t see. Give the colleagues who maintain the data edit rights, and keep owners and lenders on read-only access.
Which columns are worth adding before I map the portfolio?
Start with the columns you’ll filter or color by, which for most owners are property type, class, submarket, rentable square feet, occupancy, in-place rent and the date of the next major lease expiration. Add debt maturity if refinancing is on the table, and the renovation year if capital planning is part of the review. Each column becomes something you can group or filter, so a field nobody will ever filter on can stay in the source file, where your analysts already keep the underwriting detail.
Can I export the buildings left after filtering?
Yes. Open the Export Data icon on the map and choose Export Filtered Data to download only the rows that passed your filters, or Export Data Visible on Map to get only what’s in the current view. Files come out as .xlsx, .csv or .tsv, or you can copy them to the clipboard. That gives the leasing team or a buyer’s broker the exact shortlist you were looking at on the map, with every column you brought in, ready to sort in Excel.
