Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Welcome to the CollectiveAccess support forum! Here the developers and community answer questions related to use of the software. Please include the following information in every new issue posted here:

  1. Version of the software that is used, along with browser and version

  2. If the issue pertains to Providence, Pawtucket or both

  3. What steps you’ve taken to try to resolve the issue

  4. Screenshots demonstrating the issue

  5. The relevant sections of your installation profile or configuration including the codes and settings defined for your local elements.


If your question pertains to data import or export, please also include:

  1. Data sample

  2. Your mapping


Answers may be delayed for posts that do not include sufficient information.

exporting data to excel spreadsheet

Can anyone explain how to export data from Collective Access to an excel spreadsheet?

Thank you.

Comments

  • Create a display (Manage - My Displays) including whatever fields you wish to export to excel. Put them in sequence according to the column structure you wish to see in Excel.

    Run a search, browse, advanced search, or search-by-set to retrieve the records you wish to export.

    From the search results, click on the Export tools icon. Under the download options you will see an option for exporting directly to Excel, along with options for exporting to other formats such as CSV and Tab-delimited text.
  • Thank you Jonathan.
Sign In or Register to comment.