Print      Open PDF Version of Online Help

Analytics > Designing an Analysis > Downloading Analyses

Downloading Analyses

You can download an analysis if your role can access the analysis.

To download an analysis from the Catalog

1. In the Analytics tab, click Catalog.
2. Navigate to the analysis.
3. Right-click (or pull down the More menu, depending on the view type) on the analysis, choose Export, and then choose one of the following:
   • PDF
   • Excel 2007+
   • Powerpoint 2007+
   • Web Archive (.mht)
   • Data (requires further selection from the following:)
     • CSV format
     • Tab-delimited format
     • XML format
4. Follow the onscreen instructions to download the analysis.

To download an open analysis

1. Navigate to an analysis and click Open.
2. At the bottom of the screen, click Export, then choose one of the following:
   • PDF
   • Excel 2007+
   • Powerpoint 2007+
   • Web Archive (.mht)
   • Data (requires further selection from the following:)
     • CSV format
     • Tab-delimited format
     • XML format

Importing Your Downloaded Report

Within Excel, choose File then Open to import your downloaded report. If the data appears in a single column, select that column and choose Data then Text to Columns. In some versions of Excel, you can also double-click the downloaded file icon in Windows Explorer to import your downloaded report.

Analytics reports downloaded in CSV mode do not delimit the data automatically when opening in Microsoft Excel. After downloading a report in CSV mode, use Microsoft Excel’s Convert Text to Columns wizard with the comma-delimiter option. For more information about the compatibility of the different versions of Microsoft Excel, contact your internal IT support team.

Delimiting a CSV file in Microsoft Excel

Perform the following procedure to delimit a CSV file in Microsoft Excel (Windows 2003 or 2007).

To delimit a CSV file in Microsoft Excel

1. Press CTRL-A to select all the data.
2. In the Data tab, click Text to Columns.

   The Convert Text to Columns Wizard appears.

3. Select Delimited, then click Next.
4. Select Comma and deselect all the other check boxes, then click Next.
5. Select General, and then click Finish.