---
canonical: https://biosonic.io/bat-activity-graphs-word-report
---

# How do you get bat activity graphs into a Word survey report?

Last updated: 2026-11-22. Written by the BioSonic team.

The quickest way is software that writes the Word file for you: BioSonic exports a Word report with editable text and tables, plus maps and activity graphs as images. With any other auto ID program, export the results as CSV, make a pivot table in Excel of passes by night and species, include nights with zero bats, then chart it and paste the chart into Word.

We make BioSonic. The method on this page works with any bat analysis software.

## Option 1: export the report from BioSonic

1. Finish reviewing the identifications.
2. Open the report and choose the survey nights, detectors and species to include.
3. Press Download Word, then edit the text and tables in Word.

The charts in the file are images. If you need a chart that can be edited in Office, export the data from Graphs to Excel and draw it there.

## Option 2: Excel, from any software

1. Export the validated results with detector, date, time and species.
2. Add a survey night column: the date and time minus 12 hours. Records after midnight then stay with the night they belong to.
3. Make a pivot table with survey night as rows, species as columns and the number of records as values.
4. Add the nights when the detector worked and recorded no bats. Leave out nights when it failed, and say so.
5. Draw a stacked column chart, copy it and paste it into Word, linked if you expect the numbers to change.

## What a reader needs under each graph

- What one pass means: a file, or calls within a set time.
- The number of working nights for each detector.
- Whether the numbers are raw auto ID or validated records.
- Any gaps from bad weather, flat batteries or full cards.

## Common question

### Can I report raw auto ID counts in a graph?

BCT says auto ID output is unlikely to be suitable for reporting directly. Validate and verify first, then say in the caption which records the graph shows.

## Sources

- [Bat Surveys for Professional Ecologists, 4th edition](https://www.bats.org.uk/resources/guidance-for-professionals/bat-surveys-for-professional-ecologists-good-practice-guidelines-4th-edition) (Collins, ed., Bat Conservation Trust, 2023, amended March 2024), section 10.2.20.

Related: [The BioSonic product](https://biosonic.io/product) · [Cut the time spent checking calls](https://biosonic.io/cut-bat-call-checking-time) · [What BCT says about auto ID](https://biosonic.io/bct-guidance-auto-id)

## Test it on a survey you know

Upload recordings you have already identified and compare the results and the time it took.

[Start free trial](https://bat.biosonic.se/signup)
