Exporting to TXT

You can export a report to a text (TXT) file. This allows you to analyze the report data on your local system.

Activities

In a report, choose Start of the navigation path Actions Next navigation step Export to TXT End of the navigation path or click the Export link, depending on the application.

Save the file to a location on your local system.

You can display and analyze the report data in the relevant spreadsheet application.

Caution

When exporting report data to a double byte language, for example, Chinese, the data does not display correctly when you open directly in Microsoft Excel.

Solution:

Open Microsoft Excel and create a blank worksheet.
Select the Data tab.
In the Get External Data section, choose From Text.
Select the TXT file and choose Import.
Select the Delimited option and ensure that Unicode (UTF-8) is selected for file origin.

This should already be selected as Microsoft Excel auto detects this file type. This is the file type that was set when the TXT was exported.
Choose Next.
Under delimiters, select Comma.
Choose Finish and OK.

The TXT file is imported and displays all Chinese characters correctly.