BS&A Software Blog


The Excel export can be used as an alternative to generating reports through the Report Designer, and is available on most tables. Instead of editing a report and choosing the data fields to include, exporting to Excel allows you to easily select the data to export, and allows you to group and sum fields to see totals. Excel gives you even more flexibility and control over how your data is represented. Reports created using this method can be exported for use in other Building Department databases.

The software manual – located through your Help menu (View Documentation>Manual) – provides an instructional topic on how to export to Excel. This blog article will highlight some of the features.

Tables can be filtered prior to running the export, and edited once you’ve launched the export. Filters are addressed in a previous blog article by Adam Bengal (http://bsasoftware.com/Blog/articleType/ArticleView/articleId/720/Help-with-Filters). Your software manual also provides information on filters.

Titles can be saved/edited for the export:

A large variety of fields are available for selection, and may be ordered for export in any manner you wish (there are rules for ordering fields when exporting for charting purposes; this is addressed in the software manual):

If you choose to Group By a particular field, a summary sheet will be provided along with a sheet for each type. For example, if you “Group By” Permit Type, and four permit types are exported, you will have five sheets: one for each type, and a summary of all:

Field names can be changed to appear less cryptic on the Excel spreadsheet:

Totals can be shown (i.e., total number of permits issued or total amount of permit fees collected):


Posted in: Community Development

Views: 7434

Interested in learning more?

Get in touch and we would be happy to schedule a detailed overview of our solutions. 


Why use BS&A Software?

We hold regular user group meetings so you can: a) Share your new ideas with us; b) Learn the benefits of the new features we have added; and c) Interact with your municipal neighbors to discuss best practices.

See more reasons

We have been using the BS&A Assessing software for 15 years now. What we most like about the software is that data entry is straightforward and produces results that can be duplicated with the manual. What I most appreciate is that the software is continuously updated for changes in State law and has all the new State required reports available at a mouse click. What I find most useful is the software’s ability to allow me to use embedded reports or create a customized report of any information in the files that allow us answer to ans...

Continue Reading »

Roger McCarty, Deputy Assessor

Need help finding the right software solution?

We’ll help you find the software that fits your needs. Get in touch with our team to get started.

Get in Touch

Software Support & Training

Your resource for everything you need to learn about your software. Can’t find what you’re looking for? Get in touch for support.

Featured Tutorial

Check out our learning center for more videos
Employee Self Service

Employee Self Service

Employees can view prior checks, request changes to personal employment information, check leave balances, etc.

Added in AccessMyGov

Have questions or want to learn more about our software? We’re here to help! Feel free to

Get in Touch