Exporting Table Data

Many table pages include an Export tool in the page toolbar that lets you export the table data to a file. The export always includes all rows currently in the table, even those on subsequent pages for paginated tables. However, the export does not include rows that are not currently displayed because they have been filtered out of the table using one of the table filter mechanisms.

For details on how data is exported for each format, see Choosing Your Export Format.

To export table data

1. Make sure you have selected the export format that you want using the Export Table Data Format option in Preferences.
2. Click on the table page toolbar.

If you chose CSV or Text as your preferred export format, a dialog appears asking if you want to open or save the report.

If you chose HTML as your export format, the table data opens in a new browser window as an Excel file. (If you chose HTML and are in Netscape, the system handles the export as a CSV file due to a limitation with the Netscape browser.)

3. Use this table to save or open the file.

   If the export format is:	Steps to open or save the file:
   CSV	To open the file in Excel, click Open. The file opens in Excel if you have Excel installed. Once open, you can work with the file and save it as needed. To save the file, click Save and save the file. The default extension is *.csv.
   HTML	From the Excel menu in the browser, save the file as needed.
   Text	To open the file in your default text editor, click Open. The file opens in Excel if you have Excel installed. Once open, you can work with the file and save it as needed. To save the file, click Save and save the file. The default extension is *.txt.