Configure data export options in Data-Viewer

• When checked the Export to Excel link will be visible in the bottom right corner of the Data-Viewer Web part.
• If the Data-Viewer Web Part is configured to display both parent and nested data, only the parent data will be exported.

• The Export to Excel with data formatting (slower performance) button will only be available after the Enable Export to Excel option has been selected.

• When selected, data exported to Excel is formatted based on a combination of Regional Settings and column configuration.

• Export performance may be slower when exporting with data formatting.

  When this option is not selected:

  • Date and Time columns will be displayed in UTC time.
  • Choice columns that allow multiple selections will include the separator characters #; between values.
  • Lookup column values will include the item ID and the characters #;.
  • Multiline Rich Text will display tags
  • Percent columns won’t show the % sign

See examples here.

• When checked the Export Nested Data to Excel link will be visible in the bottom right of the web part.

• What nested data is exported is determined by the following options:

  • Export expanded nested items only: Only nested items from an expanded parent item will be exported. Nested items that are collapsed (not currently visible) will not be exported.
  • Export all nested items: All nested data is exported, even if the associated parent items are not expanded.

If you export all nested items, be sure the nested data is configured with a column that displays the name of the parent item or you won’t know which nested items goes with which parent item.