Optimizing Record Lists for Export to Excel

This page provides guidance on optimizing your record list to best take advantage of the Export to Excel feature. The configuration recommendations here take into consideration the constraints of the Excel format so you can adjust your record list accordingly.

To learn how to configure the Export to Excel option for record lists, see Record Types.

What Can Be Exported?

Entity-backed record lists displayed as grids

How Is Data Exported?

Images

If your record list has images, we recommend adding captions before exporting to Excel. Only image captions will be exported. If a caption is not available, either the document parameter on a document image or the source parameter on a web image will be exported.

The following link types will export as text. All other link types will export as expected.

  • Dynamic Link
  • Start Process Link
  • Authorization Link

Excel only supports one link per cell. When one link is provided, the link will be exported accordingly. If multiple links are provided, Appian will export the link label followed by each link URL as text in parenthesis.

Rich Text

Excel only supports one text style per cell. Therefore, styled text will only be exported accordingly if there is one styled text per cell. Cells with multiple styled text will export as unstyled text. The same rules apply for styled links. Bulleted lists and nested lists are exported appropriately.

Appian recommends you add captions when using images. Below are some scenarios that could happen when trying to export images with links.

  • An image with a caption and a nested link will export the image's caption and the corresponding hyperlink.

  • An image with no caption and a supported nested link will export the nested link as text and as a hyperlink.

  • An image with no caption and an unsupported nested link (Dynamic Link, Start Process Link, or Authorization Link) will export the nested link label as text.

How Much Data Can I Export?

You can export record lists with up to 100,000 rows or 50 columns. The Export to Excel button will be disabled if either of these limits are exceeded. We recommend that Designers add filters for record lists exceeding this limit, so that record viewers can filter down record lists to below the limit and still export to Excel.

Avoiding Query Timeouts when Exporting Data

Exporting data store entities from either record lists or smart services relies on sorting the entity by its primary key. This sorting ensures that data is exported consistently - that is, all rows are exported and no row is exported more than once.

Appian export operations use small batches to control the amount of memory consumed. The last row of a batch is tracked and used to determine where the next batch starts. By managing load this way, we avoid high memory consumption when exporting entities with a very large number of rows.

Designers should adhere to Database Performance Best Practices when creating their schema relationships. Because database views do not have a primary key, or the ability to have indexes, Appian recommends exporting data only from tables or materialized views in order to avoid query timeouts with large data sets.

FEEDBACK