Exporting Catalogue Data to Excel

It is a simple matter to export your catalogue information to an Excel spreadsheet.

First, find the items you wish to export.

In Athenaeum Pro 8.5, you can click the Print button at the top of the list view and then click the Excel button:

catalogue_export_to_excel.png

This will export the following fields: bar code, title, location, call number, dewey, purchase amount, donation amount, full amount, purchase date, depreciation rate, depreciated value.

The first row of the spreadsheet will have those headings using the internal Athenaeum field name.

Custom Export

If you would like to include more information in your export (e.g. you might want to include the Author and publish year), you can perform the export manually directly from the list view.

Simply Choose Export Records from the File menu and specify the file format (Excel), then select the list of fields from the available list.

This quick video shows you how.