Exporting information as .CSV files

You can export the contents of any Talis Alto grid (for example, borrower or item lists, search results, etc.) as a .CSV file. This file can be imported into a table-oriented application such as Microsoft Excel. If using Microsoft Excel, you should import your saved data (see below) rather than open it directly.

To export the contents of any Talis Alto grid as a .CSV file

1. Right-click anywhere within the grid.
   
   Talis Alto displays a pop-up menu.

2. Select the Export to CSV File option.
   
   The Windows Save As form is displayed.

3. Specify the required directory and filename and click OK.
   
   Talis Alto confirms that the file has been saved.
    

To import a saved .CSV file into Microsoft Excel

1. Open a new file in Microsoft Excel.

2. From the Data menu choose Get External Data and then Import Text File.
   
   The Import Text File form is displayed.

3. Locate the .CSV file and click Import.
   
   The Text Import Wizard starts.

4. In step 1, ensure the default Delimited option is set and click Next.

5. In step 2, clear all the Delimiters options except for Comma.

6. In step 3:

• Highlight any column that contains control numbers or barcodes.

• Set the Column data format to Text.

• Repeat for each column.

7. Click Finish.
   
   The Import Data form is displayed.

8. Specify whether you want to import the data into the existing worksheet or a new one.

9. Click OK.
   
   The data is imported.

Tips

For information about the different methods of printing available within Talis Alto, refer to the topic Printing in Talis Alto.