Excel data export

PDF
Products
All Creatio products

Export Creatio data displayed as a list to an *.xlsx file for processing and further use. Export to Excel is available for section lists, details, and “List” dashboards.

To export records, run the Export to Excel command in the action menu of a section (Fig. 1), detail (Fig. 2), or “List” dashboard (Fig. 3).

Fig. 1 Export section list data to Excel
Fig. 2 Export detail data to Excel
Fig. 3 Export “List” dashboard data to Excel

Note. You must have permission to the “Export list records” (the “CanExportGrid” code) system operation to export the list. The file export speed depends on the “Number of records in Excel export batch” (the “ExcelExportBatchSize” code) system setting.

You can also grant permissions to export lists of specific objects to roles and individual users. Learn more in a separate article: Data export permissions.

The file export speed depends on the number of columns and rows in the exported database, as well as the list settings. By default, Creatio terminates the export operation if it takes longer than 10 minutes. To increase the timeout value, contact Creatio support.

After you run the Export to Excel action, Creatio will download the file that contains every list record. If you specify records via multiple selection, the file will contain only the selected records.

Creatio will export only the columns that are displayed in the list. If the list has custom column titles, the exported file will display them as well.

The export operation takes the data types into account and formats the data if necessary. For example, if the exported list includes a column of the “Date” type, the corresponding column in the Excel file will be formatted similarly.

The columns in the exported file have an optimal width. If the exported values are wider than the column, the file will wrap them.

Creatio does not export contact photos and account logos.