National PEARS offers the ability to export your annual report data to Excel.
How to Export Data to Excel
To access the export, navigate to the annual report final review in National PEARS.
Click Actions and Export Report to Excel
Your export will automatically download. If it doesn’t, you can click the link in the modal that appears to start the download.
What is Contained in the Annual Report Excel Export
The Annual Report Excel Export contains 5 sheets displayed the same as the final review.
Codebook
The codebook is the description for each column in the export. Use this to guide your review.
Key Mapping
Because selections can frequently be too long to store in the database, keys are used. The Key Mapping sheet is to help explain what each key represents.
Agencies
The Agencies tab outlines which agencies are included in the export. This is especially useful if you’re exporting as a State agency or Regional Coordinator.
Data Sheets
The following data sheets contain all information included in the annual plan. Items such as projects, objectives, and sites utilize an id to help track them throughout the document.
NOTE:
The Annual Report Excel Export is only for review and any changes made in the export cannot be transferred into N-PEARS
✓ TIP:
You can run a data export at any time to review information before submission.
✓ TIP:
For more information on what is collected in each section of the annual report, visit the Annual Report Support Page: https://support.national.pears.io/annual-report/