Configure the format of exported form data

Abstract

How to customize the settings used when exporting form data.

You can change how form results are exported by customizing the culture setting, the date format, and the delimiter.

To configure the format of exported form data:

  • Go to App_Config\Sitecore\ExperienceForms\Sitecore.ExperienceForms.config and modify any of the following settings:

    <!-- SITECORE EXPERIENCEFORMS EXPORTCULTURE PARAMETER
               Specifies the culture when exporting forms data e.g. "en", "da-DK", etc.
               Default value: "" (i.e. invariant culture)-->
    
          <setting name="Sitecore.ExperienceForms.ExportCulture" value="" />
    
    <!-- SITECORE EXPERIENCEFORMS EXPORTDATEFORMAT PARAMETER
               Specifies the date format when exporting forms date field values.
               Default value: yyyy-MM-dd HH:mm-->
    
          <setting name="Sitecore.ExperienceForms.ExportDateFormat" value="yyyy-MM-dd HH:mm" />
    
    <!-- SITECORE EXPERIENCEFORMS EXPORTDELIMITER PARAMETER
               Specifies the format delimiter when exporting forms data.
               Default value: , -->
    
          <setting name="Sitecore.ExperienceForms.ExportDelimiter" value="," />

Note

You cannot export form data programmatically using the Forms export API. To do so requires that you create and implement your own API.