Display an Exported Spreadsheet

▼	Display an Exported Spreadsheet

Use this procedure to view and optionally edit a file that you have created with “Export Table Data to a Spreadsheet”. The file is automatically assigned a .xls extension, but the data is actually in HTML format. As a result, you can display the file using either of the following options:

•	“Display the Spreadsheet With Excel”

•	“Display the Spreadsheet in a Browser”

▼	Display the Spreadsheet With Excel

Because the file is saved with a .xls extension, you can easily open it in Microsoft Excel and perform spreadsheet functions on the data.

1.	Keep the `.xls` extension on the file, and open it in Excel or a compatible spreadsheet application.

2.	Click Yes to open the file.

3.	To correct formatting issues with numeric data, perform the following steps:

a.	Select the column header to highlight the entire column.

b.	Right-click the column and select Format Cells.

c.	In the Format Cells dialog box, select Number in the Category column.

d.	In the Decimal places field, type “0”.

e.	Leave all other fields as is, and click OK to save the changes.

4.	See the Microsoft Excel documentation for information about the various functions you can perform on the data in the spreadsheet.

▼	Display the Spreadsheet in a Browser

1.	Change the `.xls` file extension to `.htm` or `.html`.

2.	Open the file in your browser.