Configure the format of exported form data
Version: 10.4
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:RequestResponse<!-- 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.