# How to find absentee owners

> Absentee owners get tax bills at a different address. Filter a county export in a spreadsheet, then trace them: 1,000 records cost $16.00.

Source page: https://skipcheap.com/guides/how-to-find-absentee-owners/ · Prices read 2026-11-11

An absentee owner is one whose tax-bill mailing address is not the property address. They own it but do not live there: landlords, heirs, owners who moved. You can find them for free from a county export. Tracing 1,000 of them costs $16.00 at PennySkips, the cheapest no-subscription service at that size.

## Step 1: get the data

Many county appraiser or assessor offices sell or give away a bulk file of every parcel, often as CSV or a database file. Ask for the "parcel roll" or "tax roll" with owner mailing addresses. If your county does not offer one, a list tool such as an investor platform can export the same fields by area.

## Step 2: compare the two addresses

1. Open the file in a spreadsheet. Find the columns for property address and owner mailing address.
2. Clean both: trim spaces, make everything upper case, and strip punctuation. "123 Main St." and "123 MAIN ST" must match.
3. Add a column that compares the street number and street name of each. In Excel or Google Sheets: =IF(LEFT(UPPER(TRIM(B2)),15)<>LEFT(UPPER(TRIM(D2)),15),"absentee","owner"), where B is the property address and D is the mailing address.
4. Filter for "absentee".
5. Spot-check 20 rows by eye. Abbreviations such as "Rd" and "Road" create false hits, so fix the common ones with find and replace and run the formula again.

## Step 3: narrow the list

- **Out of state.** Keep rows where the mailing state differs from the property state. These owners are the least likely to visit, and the most likely to consider a sale of land or a rental.
- **Long ownership.** Keep rows with a sale date more than 10 years back.
- **Remove the obvious.** Drop banks, government bodies and large companies. They do not sell through cold outreach.
- **Remove homestead.** If your state flags a homestead exemption, an owner who claims it lives there. A flagged row with a different mailing address is worth a second look.

## Step 4: trace the list

Before you upload, remove duplicate parcels (see [list stacking](https://skipcheap.com/guides/list-stacking/)). Then trace. Absentee lists often have a full mailing address but no phone, which is the case a trace is for. Compare the services on [pay-per-record skip tracing](https://skipcheap.com/best/pay-per-record-skip-tracing/), or enter your count in the [calculator](https://skipcheap.com/).

You can also mail the owners directly using the mailing address from the county record, with no trace at all.

**Next:** [list stacking](https://skipcheap.com/guides/list-stacking/), [how to find a property owner's phone number](https://skipcheap.com/guides/how-to-find-a-property-owners-phone-number/), or [the cheapest at 1,000 records](https://skipcheap.com/cost/1000-records/).
