Large screen
Small screen
Use statistics export when you need summarized counts and percentages—for grant reports, permit reports, and fieldwork updates—rather than raw records. Every table in Counts and Spatial can be exported as CSV, TSV, Excel, or JSON.
Statistics work at two scopes:
- Active project: open the
Record statisticspanel E on the projectDashboardand selectExplore more statsF. - All projects: open
Database statisticsfrom the home screen menu to summarize and export statistics across every project in the database.
Opening the statistics screen
Section titled “Opening the statistics screen”Switch between two top-level views:
SummaryA shows overall totals grouped intoRecord summaryC,Taxonomic breakdownD (distinct classes, orders, families, genera, and species), andMedia breakdown—plus aPer projecttable when viewingDatabase statistics—followed by top-five charts. SelectView detailson any chart to open it inExplore.ExploreB has three tabs:Counts: builds a chart or exportable table by measure, grouping, breakdown, and filter.Spatial: maps or tabulates counts per site coordinate.Graph: explores relationships among records interactively (visual only; not exported as a table).
To export, switch Counts or Spatial from Chart or Map to Table, then select Export table above the table.
Counts
Section titled “Counts”Under Explore, select Counts and choose a Measure first—it determines which Group by options appear:
| Measure | Group by |
|---|---|
Specimens | Species, Taxon rank, Site, Date, Method, Sex, Life stage |
Species | Taxon rank, Site, Date, Method, Sex, Life stage |
Part quantity | Part type, Treatment |
Symbionts | Symbiont taxon, Category, Anatomical location, Host species |
Life stage appears only when recorded in the data, and Symbionts appears only when symbiont records exist. Three additional controls appear when applicable:
Taxon rank: chooseClass,Order,Family, orGenus(Specieshas its own grouping because it supports breakdowns and site filtering). Chart titles, column headers, and default filenames use the chosen rank, such asSpecimens by family.Break down by: splitsSpecimensbySpeciesintoSexorLife stage, adding a breakdown column to the exported table.- Filters: filter
SpecimensbySpeciesto one site, or filterPart quantityorSymbiontsto one species. Active filters are included in the default filename.
Exported tables mirror the on-screen table with one row per category:
| Rank | Species | Specimens | Percent (%) || ---- | ----------------- | --------- | ----------- || 1 | Bunomys coelestis | 24 | 40.00 || 2 | Bunomys penitus | 18 | 30.00 |The second header follows the active grouping and the count header follows the measure. When a breakdown is active, its column sits between them, and missing values export as Not recorded.
Spatial
Section titled “Spatial”Under Explore, select Spatial to count Specimens, Species, or Family per site coordinate. Coordinates by species lets you pick a species and count its records at each coordinate.
Exported spatial tables write one row per coordinate with place name, locality, latitude, longitude, elevation, count, and percent. These are raw record counts—not measures of sampling effort—so verify missing coordinates and taxon filters before using them in a report or GIS.
Writing the file
Section titled “Writing the file”Both Counts and Spatial share the same export dialog (a bottom sheet on phones and a dialog on wider screens).
- Review the filename. NAHPU proposes a name from the project name (or
NAHPU_all-projectsforDatabase statistics), measure and grouping, active filter, and today's date. - Turn on
Append dateif you replace the filename with a custom name and still want today's date added. - Choose a format:
CSVorTSVfor analysis tools,Excelfor an.xlsxworkbook, orJSONto keep column headers as keys. - Select a destination folder on desktop (on mobile, NAHPU saves to its app export folder).
- Select
Export. Once written, you canShare, open the folder, or save a copy.
Related pages
Section titled “Related pages”- Record statistics on the dashboard
- Export records for underlying specimen, site, and collecting-event tables
- Bundle records for standards-based packages



