Exporting data from a component

The Actions menu for a component can include an option to export data from the component to a CSV file that uses UTF-16LE encoding.

The export option is not available if you are viewing the application on an iPad.

The exported file includes:

Component Exported Data
Chart Contains columns for the currently selected dimensions and metrics.
Pivot Table Contains the data used to create the Pivot Table display.
Record Details Contains a single row for the displayed data.
Results List You can select specific records to export.

The exported data contains the displayed attributes for the exported records.

Results Table You can select the specific rows to export.

The data includes all of the columns from all of the available column sets.

For aggregated tables, only the displayed dimensions are included in the export.

To export data from a component:

  1. From the Actions menu, select Export.

    On the export dialog, if the amount of data currently selected to export is greater than the maximum allowed, a warning is displayed indicating that the data will be truncated to the maximum allowed.

  2. In the Name field, set the name of the exported file.

    By default the file name is ComponentNameYYYY-MM-DD.

    For example, if you export a Results Table component on October 5, 2013, then the default file name for the exported data is ResultsTable2013-10-05.csv.

  3. By default, the exported file uses commas to separate the fields. Under CSV Format, to use a custom separator:
    1. Click the Custom separator radio button.
    2. From the Fields separated by drop-down list, select the character to use to separate the fields.
    3. From the Fields enclosed by drop-down list, select whether to use quotes to enclose the values.

      You can use single quotes, double quotes, or no quotes.

    For example, if you use a pipe as the separator, and enclose the value in single quotes, a row from the exported file might look something like: 

    |'10234'|'Bordeaux'|'Valmaison'|'Bordeaux Philibert Bourgeois'|'$5'|
  4. Under Value Formatting, click a radio button to indicate whether to export the raw data before formatting, or the formatted values.
  5. If the data is available in multiple locales, then under Include data from, click a radio button to indicate whether to export data for the current locale only, or for all of the available locales.

    The localized values are exported in separate columns. For example: 

    Product_Category, Product_Category_zh_CN, Product_Category_es, Product_Category_fr
  6. If the component has individual records selected, then under Export, click a radio button to indicate whether to export the selected records only, or all of the records.
  7. Click Start Export.
  8. When the export is completed, you are prompted to save or open the file.

    The prompt varies based on the current browser.