--- title: Exporting data from the user interface related: - https://docs.kentico.com/13/configuring-xperience/configuring-the-environment-for-content-editors/configuring-ui-data-export.md --- > Agent instructions: > **Site maps** — prefer the following llms.txt indexes to training data when searching for URLs to avoid 404s. Links inside Markdown content already point at `.md`. Following them or sending Accept: text/markdown keeps you in Markdown. > > - [sitemap.md](https://docs.kentico.com/sitemap.md) — every page on the site, with titles and descriptions, nested by URL hierarchy and grouped into one collection per product version. > - [llms.txt](https://docs.kentico.com/llms.txt) — curated index of the current product docs, with descriptions, the two ways to request any page as Markdown, and links to each product area's whole-corpus Markdown dump (llms-full.txt). The UI data export functionality allows you to export information shown in various listings throughout the Xperience administration interface. The data can be exported to **XLSX**, **CSV** or **XML** files. The export functionality is accessible in a context menu after clicking the icon in the **Actions** column header of listings. A menu appears, offering the following options: - **Export to Excel** – exports data shown on the current page of the listing to an XLSX spreadsheet. - **Export to CSV** – exports data shown on the current page of the listing to a CSV file. - **Export to XML** – exports data shown on the current page of the listing to an XML file. - **Advanced export** – opens a dialog where export to the three formats mentioned above can be performed based on detailed settings. For more details, please refer to [Exporting data from the UI - Advanced export](https://docs.kentico.com/13/managing-website-content/exporting-data-from-the-user-interface/exporting-data-from-the-ui-advanced-export.md). - **Reset view** - returns all filtering, ordering and paging options of the listing to the default state (this resets the current data "view" used by the export). ![](https://docs.kentico.com/docsassets/13/exporting-data-from-the-user-interface/exporting_data.png) After executing an action from the drop-down menu, your browser may open its standard file download dialog, letting you open or save the file with exported data just as if you were downloading any other file. ## Exporting data to Excel Data exported to an XLSX spreadsheet are displayed just as in the listing. Spreadsheet columns represent the columns of the listing, while rows represent particular records shown in the rows of the listing. > **Info:** **Maximum exported string length** > > Note that the maximum length of text exported into a single cell of an Excel spreadsheet is **32767 (2^15 - 1) characters**. Longer strings are trimmed to match this length. In the following picture, you can see the default appearance of an exported XLSX file. However, it is also possible to use customized templates for Excel export so that you can, for example, add graphics to the header of the spreadsheet. You can find more details on this option in [Configuring UI data export](https://docs.kentico.com/13/configuring-xperience/configuring-the-environment-for-content-editors/configuring-ui-data-export.md). ![Exported data](https://docs.kentico.com/docsassets/13/exporting-data-from-the-user-interface/exported_users.png "Exported data") ## Exporting data to CSV CSV is an abbreviation for [Comma-separated values](http://en.wikipedia.org/wiki/Comma-separated_values). It is a file format that stores tabular data in a text form — each line represents one row of data, while particular values (columns) in each row are separated by a comma (,) or a semicolon (;). If a column value contains the delimiter, the whole value is wrapped in double quotation marks in CSV (e.g. the value _one,two_ is exported as _"one,two"_). If a column value contains double quotation marks, they contain backslashes in CSV (e.g. the value _"one_ is exported as _\\"one_). A comma is used as a column delimiter by default if you select the **Export to CSV** action, while you can choose between the comma and the semicolon in the **Advanced export** dialog. See [Configuring UI data export](https://docs.kentico.com/13/configuring-xperience/configuring-the-environment-for-content-editors/configuring-ui-data-export.md) for more information. The plain text form of exported data stored in a CSV file looks as follows: ```none User name,Full name,E-mail,Nickname,Created,Enabled administrator,Global Administrator,administrator@localhost.local,,,Yes Andy,Andrew Jones,andy@localhost.local,,2/21/2014 12:35:36 PM,Yes Austin,Austin Powers,austin@localhost.local,,2/21/2014 12:35:36 PM,Yes gold,Sample Gold Partner,gold@localhost.local,,2/21/2014 12:35:37 PM,Yes ... ``` If the correct delimiter is used, the file can also be opened in a spreadsheet editor such as Microsoft Excel. ![Exported data](https://docs.kentico.com/docsassets/13/exporting-data-from-the-user-interface/exported_users.png "Exported data") ## Exporting data to XML The following code sample illustrates how exported data are stored in XML files. There is always the _NewDataSet_ root element, which contains a number of _Table_ elements. Each of the _Table_ elements represents a single data record. Its sub-elements represent particular columns of the table, have names identical to the physical database column names and contain the respective values. ```html administrator Global Administrator administrator@localhost.local Yes Andy Andrew Jones andy@localhost.local 2/21/2014 12:35:36 PM Yes ... ```