Skip to content

Export Statistics

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 statistics panel E on the project Dashboard and select Explore more stats F.
  • All projects: open Database statistics from the home screen menu to summarize and export statistics across every project in the database.

Switch between two top-level views:

  • Summary A shows overall totals grouped into Record summary C, Taxonomic breakdown D (distinct classes, orders, families, genera, and species), and Media breakdown—plus a Per project table when viewing Database statistics—followed by top-five charts. Select View details on any chart to open it in Explore.
  • Explore B 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.

Under Explore, select Counts and choose a Measure first—it determines which Group by options appear:

MeasureGroup by
SpecimensSpecies, Taxon rank, Site, Date, Method, Sex, Life stage
SpeciesTaxon rank, Site, Date, Method, Sex, Life stage
Part quantityPart type, Treatment
SymbiontsSymbiont 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: choose Class, Order, Family, or Genus (Species has its own grouping because it supports breakdowns and site filtering). Chart titles, column headers, and default filenames use the chosen rank, such as Specimens by family.
  • Break down by: splits Specimens by Species into Sex or Life stage, adding a breakdown column to the exported table.
  • Filters: filter Specimens by Species to one site, or filter Part quantity or Symbionts to 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.

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.

Both Counts and Spatial share the same export dialog (a bottom sheet on phones and a dialog on wider screens).

  1. Review the filename. NAHPU proposes a name from the project name (or NAHPU_all-projects for Database statistics), measure and grouping, active filter, and today's date.
  2. Turn on Append date if you replace the filename with a custom name and still want today's date added.
  3. Choose a format: CSV or TSV for analysis tools, Excel for an .xlsx workbook, or JSON to keep column headers as keys.
  4. Select a destination folder on desktop (on mobile, NAHPU saves to its app export folder).
  5. Select Export. Once written, you can Share, open the folder, or save a copy.