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 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 MS Excel to tidy up your exported information, and how to export data from reports and other screens in AbtracOnLine.

Continue reading