search
Ctrlk
Contact Us

Export Site Data

Export site data from PEARS to an Excel file for analysis.

The Sites export allows you to download site data from PEARS into an Excel file for external analysis.

circle-exclamation

NOTE: The Sites export is only available for Programming Managers and Organization Administrators.

1

hashtag
Navigate to Sites

From the PEARS homepage, hover over the Analyze menu and click Sites. A list of all sites displays.

2

hashtag
Filter the list

Use the filter and search tools to select the desired site data for export.

3

hashtag
Click Export

Click the Export button. An Excel document containing the selected site data downloads to your device.

hashtag
Working with the Export

  • Enable Editing — Click Enable Editing at the top of the document to unlock protected view.

  • Freeze headers — Use View > Freeze Panes > Freeze Top Row to keep column headers visible while scrolling.

  • Sort and filter — Apply Sort and Filter features from the Data toolbar to analyze subsets of the data.

  • Formulas — Use Excel formulas like SUM, COUNT, and VLOOKUP for data analysis.

circle-info

TIP: All implementing agencies in each state share the same list of sites. Many site fields are optional, including contact information. The export may include a Demographics tab when applicable.

Last updated