1. Library Guide
  2. Basic GUI Operations
  3. Export a GUI Table to a Spreadsheet

Export a GUI Table to a Spreadsheet

Export an .xls file for any of the tables found in the GUI.

  1. Navigate to the table.
  2. Click Export Export table icon.
  3. Save the file to the desired location.
  4. Open the file in a spreadsheet application (such as Microsoft Excel).

    Note:

    The extension of the file is .xls, but the format is html. When opening the file in a spreadsheet program, you may be required to verify that the file is not corrupt and from a trusted source.
  5. You may need to change the format of any Date/Time columns. If using Excel, select the columns. Select Format Cell, Custom, and then enter the format, such as mm/dd/yy hh:mm:ss.0;@.

    If you select Format Cell, Date, and select a date type like MM/DD/YY HH:MM, then time will be rounded to the nearest minute.