The Collier County Property Appraiser provides public data in downloadable ZIP file format. These files are updated regularly and contain property, sales, building, land, legal, and other records that can be used for reporting and analysis. Each file contains a CSV (Excel-compatible) version of the data.

Most files can be linked together using the PARCELID field. This allows you to join sales records to parcel data or connect land and building data to their corresponding parcels. Tangible Personal Property (TPP) accounts use a separate ACCOUNTID for tracking, but also include a PARCELID so the personal property can be associated with a real estate parcel when applicable - for example, showing which unit a business occupies in a shopping center.

The files correspond to our internal database tables. Here's a summary of what's available:

• Parcels: Core property file with mailing/site addresses, ownership, values, exemptions, land size, and millage area (PARCELID).
• Accounts: TPP records for business assets like furniture, fixtures, and equipment (ACCOUNTID, PARCELID).
• Legal: Legal descriptions, often split into multiple lines by sequence (PARCELID).
• Sales: Sale date, price, document number, and transfer details (PARCELID).
• Buildings: One record per structure; includes year built, square footage, and class (PARCELID).
• Land: Calc Code, land units, and adjustment data (PARCELID).
• Subdivision/Condos: Lists subdivision/condo names and parcel ranges (SUBCONDO).
• Millage Rate(s): Taxing district rate lookup (MILLAGEAREA).
• Use Codes: Describes USECODE values (e.g., residential, commercial).
• Building Codes: Explains BLDGCLASS values from the Buildings file.
• NAICS Codes: Business types used in TPP (NAICSCODE).
• Real Property Values: Historical real property values by parcel and tax year (PARCELID, TAXYEAR).
• Tangible Personal Property Values: Historical TPP values by account and tax year (ACCOUNTID, TAXYEAR).

Note: Permit data is not included because it is maintained by external permitting agencies, not the Property Appraiser's Office.

Go to the Data Downloads section from the menu on the left side of our homepage. Files are grouped under sections like "Tax Roll / CAMA Database Exports" or "Lists, Data & Codes."

Click on the file you want (e.g., Parcels, Sales, Building), and your browser will download a ZIP file containing a CSV file (or occasionally multiple CSVs).

After downloading, right-click each ZIP file and choose Extract All.... Save the contents to a single folder for easier access later.

You can open the CSV file using Microsoft Excel in one of two ways:

• Option 1 (Quick): Double-click the file.
  Note: If your computer is set to open CSV files with another program (like Notepad), this may not work as expected.
• Option 2 (Recommended): Open Excel first, then go to File > Open and browse to the folder where you saved the CSV file.

Tip: If Excel shows a message about converting data and removing leading zeros, click Convert to proceed. You can reformat the affected columns after opening if needed.

Why format as a table?

Formatting your data as a table in Excel makes it easier to filter, sort, and analyze large datasets. It also improves visibility and helps when using formulas like VLOOKUP or XLOOKUP.

How to create and format tables

1. Select the cell or the range in the data.
2. In the Home menu, select Format as Table.
3. Choose a style for your table.
4. In the Format as Table dialog box, set your cell range.
5. Mark if your table has headers.
6. Select OK.

For more information or a video demonstration, visit Microsoft's support article.

Once your data is formatted as a table, Excel adds drop-down arrows at the top of each column. These allow you to filter and sort your data quickly without changing the file's structure.

To filter your data:

1. Click the drop-down arrow in the column you want to filter.
2. Uncheck the values you want to hide or choose a custom filter (e.g., "greater than" or "contains").
3. Click OK to apply the filter. Only rows matching your criteria will remain visible.

To sort your data:

1. Click the drop-down arrow in the column you want to sort.
2. Select Sort A to Z or Sort Z to A for text, or Smallest to Largest / Largest to Smallest for numbers.

For more information or a video demonstration, visit Microsoft's guide on filtering and sorting data .

Why join files?
Each downloadable file represents a different aspect of property data. Linking them using PARCELID (or ACCOUNTID for TPP) allows you to build a more complete picture of each property or perform detailed analysis.

The Parcels file is the central file and can be linked to these supporting datasets:

• Sales File: Sale date, price, and document number
• Land File: Land units, valuation method, and adjustments
• Building File: Year built, square footage, and type
• Legal File: Legal description of the parcel
• Accounts File (TPP): Business personal property associated with the parcel

You can link in either direction depending on your goal. For example:

• Start with a parcel and retrieve its last sale or buildings
• Start with a sale and link back to parcel details like ZIP code or exemptions
• Join from land or building tables back to the parcel for ownership or valuation

Common questions this helps answer:

• When was a parcel last sold, and for how much?
• What structures or land types are on a parcel?
• Which business assets are located on a parcel?
• What exemptions, use codes, or ZIP codes apply to a sale?

How to link files in Excel using VLOOKUP:

1. Unzip all related files into the same folder
2. Open both the main and supporting files in Excel
3. Insert a new column in your main file for the value you want to retrieve
4. Use a VLOOKUP formula to match PARCELID or ACCOUNTID

Example using VLOOKUP:

=VLOOKUP(A2, 'Sales.csv'!A:C, 3, FALSE)

This finds the value in column 3 of the Sales file where the PARCELID in cell A2 matches a row in column A of the Sales file. Adjust ranges and columns as needed.

For more information or a video demonstration, visit Microsoft's guide on VLOOKUP.

Many fields in the data files use numeric or abbreviated codes to represent property use, building types, subdivisions, and business categories. To make this data more readable, you can join these fields with the corresponding lookup tables found under Lists, Data & Codes on the downloads page.

Available lookup files include:

• Use Codes: Explains values in the USECODE field (e.g., residential, commercial)
• Building Codes: Explains BLDGCLASS values from the Buildings file
• Subdivision/Condos: Lists subdivision or condo names tied to the SUBCONDO field
• Millage Rate(s): Lookup file of taxing district rates MILLAGEAREA. The millage area defines the tax rate district a parcel falls into.
• NAICS Codes: Explains NAICSCODE values for Tangible Personal Property accounts

How to apply code descriptions in Excel using VLOOKUP:

1. Unzip all files into the same folder and open both the main and lookup files in Excel
2. Insert a column in your main file where you want the description to appear
3. Use VLOOKUP to match the code in the main file to the description in the lookup file

Example: Add a Use Code description to the Parcels file:

=VLOOKUP(B2, 'UseCodes.csv'!A:B, 2, FALSE)

This formula looks up the USECODE in cell B2, finds it in column A of the Use Codes file, and returns the description from column B.

For more help using VLOOKUP, visit Microsoft's guide on VLOOKUP.