--- title: Exporting data from the UI - Advanced export related: - https://docs.kentico.com/k8/managing-website-content/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). Clicking the **Advanced export** option can raise two different versions of the **Advanced export** dialog, depending on the type of user performing the operation. ![Using advanced export](https://docs.kentico.com/docsassets/k8/exporting-data-from-the-ui-advanced-export/advanced_export.png "Using advanced export") ## Advanced export - global administrator When the **Advanced export** option is selected by a user with the Global administrator [privilege level](https://docs.kentico.com/k8/managing-users/user-management.md), the system displays an **Advanced export** dialog. ![Using advanced export as an admin](https://docs.kentico.com/docsassets/k8/exporting-data-from-the-ui-advanced-export/exporting_data_using_advanced_export.png "Using advanced export as an admin") **Advanced export options** | Export to | Type of file to which the data will be exported. You can choose from the following:
**Excel** - exports data to an XLSX spreadsheet.
**CSV** - exports data to a CSV file.
**XML** - exports data to an XML file. | | ------------------------ | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | Delimiter | Displayed only when export to CSV is selected. Determines the value separation character used by the CSV file. The character can either be a comma (,) or a semicolon (;). See the [Configuring UI data export](https://docs.kentico.com/k8/managing-website-content/configuring-the-environment-for-content-editors/configuring-ui-data-export.md) topic for more details. | | Export raw database data | The format of data displayed in listings is not always identical to actual data stored in respective database columns. E.g. the **Enabled** column in user listing shows _Yes/No_ values, while boolean _True/False_ values are actually stored in the **UserEnabled** column of the **CMS\_User** table.
With this option enabled, raw data will be exported exactly as stored in the database and column headers will be identical to the database column names. If disabled, column headers and the actual data will be exported as shown in the listing. | | Current page only | If enabled, only records displayed on the current page of the listing will be exported. If disabled, all records on all pages of the listing will be exported. The number of exported records in both cases can be limited by means of the **Number of records** value. | | Number of records | Specifies the number of data records that will be exported. Empty value results in all records being exported. The specified number of exported records can be limited by enabling the **Current page only** option. | | Export column header | If enabled, column headers will be included in the exported file. This option is not available when exporting to XML as column header names are used as names of the respective XML elements. | | Order by | Standard SQL ORDER BY expression. Exported items will be ordered according to this expression in the exported file.
Please note that you can select only columns that have a corresponding physical column in the database. | | Use grid filter | If enabled, only data matching the filter above the listing will be exported. If disabled, all data will be exported regardless of the filter settings. | | Where condition | Standard SQL WHERE condition. Only items matching this condition will be included in the export file. | | Columns | In this section, you can use the check-boxes to choose which columns will be included in the export file. Bulk column selection can be performed using the following link buttons:
**Select all** - selects all columns listed in this section.
**Deselect all** - deselects all columns listed in this section.
**Default selection** - selects columns that were selected initially when the dialog was opened.
If the **Export raw database data** option is enabled, listed column names are identical to the actual database columns name. If the option is disabled, column names are shown as in the listing. | When you have the options adjusted, you can click **Export** to get the data exported to the chosen type of file. By clicking the **Preview** button, you get a maximum number of 100 records exported (unless you set a smaller number by means of the **Current page only** or **Number of records** options). This is useful in case that you are exporting large amounts of records and want to get a quick preview of the exported file without waiting for all the records to be exported. ## Advanced export - standard user When the **Advanced export** option is selected by a standard user who is not a global administrator, the system displays a simplified **Advanced export** dialog with more secure options (compared to the global administrator version).  ![Using advanced export as a non-admin user](https://docs.kentico.com/docsassets/k8/exporting-data-from-the-ui-advanced-export/exporting_data_using_advanced_export_nonadmin.png "Using advanced export as a non-admin user") **Advanced export options** | Export to | Type of file to which the data will be exported. You can choose from the following:
**Excel** - exports data to an XLSX spreadsheet.
**CSV** - exports data to a CSV file.
**XML** - exports data to an XML file. | | -------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | Delimiter | Displayed only when export to CSV is selected. Determines the value separation character used by the CSV file. The character can either be a comma (,) or a semicolon (;). See the [Configuring UI data export](https://docs.kentico.com/k8/managing-website-content/configuring-the-environment-for-content-editors/configuring-ui-data-export.md) topic for more details. | | Current page only | If enabled, only records displayed on the current page of the listing will be exported. If disabled, all records on all pages of the listing will be exported. The number of exported records in both cases can be limited by means of the **Number of records** value. | | Number of records | Specifies the number of data records that will be exported. Empty value results in all records being exported. The specified number of exported records can be limited by enabling the **Current page only** option. | | Export column header | If enabled, column headers will be included in the exported file. This option is not available when exporting to XML as column header names are used as names of the respective XML elements. | | Order by | In this section, you can determine how exported records will be ordered in the exported file.
Initially, there are two drop-down lists displayed. In the first one, all columns that have a corresponding physical column in a database are offered. The second one determines if values will be exported in ascending or descending order according to values in the selected column.
Once you make your choice, another two drop-down lists are displayed below, allowing you to choose how records will be ordered in case of identical values in the column chosen above. After selecting, two other drop-downs are displayed below again. In the end, you can get as many pairs of drop-down lists as the number of offered columns. | | Columns | In this section, you can use the check-boxes to choose which columns will be included in the export file. Bulk column selection can be performed using the following link buttons:
**Select all** - selects all columns listed in this section.
**Deselect all** - deselects all columns listed in this section. |