Exporting Abtrac Data and exporting reports to Excel

You can export any data from Abtrac to Microsoft Excel for analysis via the reports screen.

In some instances, for commonly exported screens and reports the data is ‘pre-cleaned’ and will export in a similar format to the report preview.

In other instances the export may result in ‘messy’ data, where the formatting is not as expected. This export format depends on the report data, your version of Abtrac, and your version of Microsoft.

You may need to ‘clean up’ the exported file in order to remove blanks and groupings from the original report. Read on for tips on using excel to tidy your exported information, and how to export data from reports and other screens in both AbtracOnLine and Abtrac5.

Continue reading