Free cookie consent management tool by TermsFeed

Export Records to Excel

This page provides information for the most commonly asked questions around exporting records to Excel.

Where is the Export to Excel button available?

You can display an Export to Excel button on the record list and any records-powered grids.

Note:  This button is not available when viewing the record list or a read-only grid on a mobile device.

How much data can be exported?

The amount of record data you can export from your record list or read-only grid depends on the record type's data source:

  • If your record type uses a database table or a web service as the data source, users can export up to 100,000 records and up to 50 columns.

  • If the data source for your record type is a process model, users can export a maximum of 10,000 consecutive records only.

The Export to Excel button will be disabled if the list or grid exceeds the maximum amount. As such, Appian recommends adding a user filter to record lists or grids that exceed these limits. This will allow users interacting with the record list or grid to filter the records below the limit and export them to Excel.

How do you optimally export data from one-to-many relationships?

When configuring a record list or read-only grid, Appian recommends displaying one-to-many related data using a related record field reference instead of using a relationship reference. This avoids querying more data than necessary, which can impact the grid's performance and cause the grid to exceed the maximum amount of data that can be exported.

For example, to display a list of cases associated with each customer, you should use the related record field reference recordType!Customer.relationships.cases.fields.title in the grid column. You should not use the relationship reference recordType!Customer.relationships.cases since it will return all related record fields—like the case title, created on date, and status—which could ultimately display more than the record limit for export to Excel.

Additionally, if possible, Appian recommends using the a!relatedRecordData() function to filter and limit the number of related records returned for each base record. This will make your list or grid easier to read, and also assist with performance.

How do you avoid 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.

How is data exported?

When you export the record list, the way the Appian components appear in Excel may differ. Since Excel has its own formatting and styling restrictions, consider how the following components will display in Excel when designing your record list.

Exporting rich text

Excel supports only one text format per cell. Therefore, if the text in the cell includes more than one text format it will export without formatting. This includes text formatted with links, different rich text types, and different formats using rich text item.

Additionally, for rich text icons, only the value of the altText parameter will be exported. If the altText parameter doesn't have a value, nothing will be exported.

Exporting images

Images cannot be exported to Excel, but image captions can. Add captions to the images in your record list or grid to make sure that information is exported.

Within your captions, you can add links to allow users to learn more. Depending on how you configure the caption and the link, the export results may vary.

For example:

  • 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 will export the nested link label as text.

If your record list or grid displays an image without captions, then the document parameter on the document image or the source parameter on the web image will be exported.

Exporting grid background colors

Read-only grid background colors cannot be exported to Excel. Instead, you can save the page as a PDF if you want to share the grid to those without access to your app.

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

All link types will export as expected except for these three:

These link types will export as text.

Why is export for unsynced service-backed record types disabled by default?

Unsynced record types that use a web service as the source require additional logic to handle paging, sorting, searching, and filtering. Therefore, the Export to Excel button is not displayed by default on a record list or read-only grid that uses an unsynced service-backed record type. This is to ensure developers test the additional logic prior to enabling it.

To test the expression's paging, sorting, searching, and filtering functionality:

  1. In the record type, go to List.
  2. Under URL, click the link. The record list displays where you can try paging, sorting, searching, and filtering the list.

Once you test your expression's configuration, you'll need to review the record list or grid's supported page size.

When record lists are displayed on a web or mobile device, it is typical to have a small page size, like 25 or 50 records. Since record lists and grids are exported using batches to minimize memory usage, developers must support a page size of 1,000 records, which is the page size used when exporting service-backed records. Make sure to test your Web API or integration with this page size to determine whether the export operation will succeed.

Finally, Appian recommends testing the export to Excel functionality before deploying.

To test the export to Excel functionality:

  1. In the record type, go to List.
  2. Select the Show Export to Excel Button checkbox.
  3. Click SAVE CHANGES.
  4. Under URL, click the link. The record list appears.
  5. Click Export to Excel a few times to test for any errors. Any error raised by the source expression will be logged to the Excel file. Use the error message for further troubleshooting.

Feedback