CRMJettyBack to crmjetty.comContact us
Menu
Docs / Guides

CRMJetty Portal

Works with
Docs / Dynamics 365

Dynamics 365 Customer Portalv6.3.0

Docs / Salesforce

Salesforce Customer Portalv6.3.0

Docs / Business Central

Business Central Portal

Guides / Lists

How to Let Portal Users Export Records to CSV

4 min readUpdated
Short answerIn Design → Page Builder, open the List widget settings, turn on Enable Export and select CSV in Select Export Formats. Select Save and publish the page. Portal users can then export the whole list or only the records they select.

Portal users can download the records they see in the portal as a CSV file, for example to work with their invoices or orders in a spreadsheet. They can export the entire list or only the records they select. You turn export on per widget, so you decide on which pages it is available.

Before you start

Note: This article covers portal users exporting CRM records. Exporting portal configuration, such as pages, roles and workflows, is a different feature. See How to Export and Import Portal Configuration.

Turn on export in a List widget

  1. Go to Design → Page Builder.
  2. Open the page with the list in edit mode.
  3. Select the Settings icon on the List widget.
  4. Under Enable Export, turn on the Enable Export toggle.
  5. In Select Export Formats, select CSV. You can also select Excel and PDF.
  6. Select Save.
  7. Publish the page.
List widget settings with the Enable Export toggle on and CSV, Excel and PDF in Select Export Formats
List widget settings with the Enable Export toggle on and CSV, Excel and PDF in Select Export Formats
List widget settings with the Enable Export toggle on and CSV, Excel and PDF in Select Export Formats
List widget settings with the Enable Export toggle on and CSV, Excel and PDF in Select Export Formats

Turn on export in other widgets

Widget Setting Formats
List Enable Export, then Select Export Formats CSV, Excel, PDF
Data Card Enable CSV Export (Business Central: Enable Export, then Select Export Formats) CSV (Business Central: the formats you select)
Sub-Grid (in an Edit or Detail form) Enable Export, then Select Export Formats CSV, Excel, PDF

For the other Data Card settings, see How to Show CRM Records as Cards in the Portal. For sub-grids, see How to Add Sub-Grids to Portal Forms.

How portal users export records

  1. Open the page with the list.
  2. To export only some records, select the checkbox next to each one. Otherwise, the whole list is exported.
  3. Select the export option and choose CSV.
  4. Open the downloaded file in a spreadsheet app.
Portal list with two records selected and the export option showing CSV, Excel and PDF
Portal list with two records selected and the export option showing CSV, Excel and PDF
Portal list with two records selected and the export option showing CSV, Excel and PDF
Portal list with two records selected and the export option showing CSV, Excel and PDF

Tip: Export what portal users need and nothing more. A record that appears in the list can be exported, so use roles and workflows to control what the list shows. See How to Filter Which Records Portal Users See.

Troubleshooting

Portal users don’t see the export option: Check that Enable Export is on in the widget, that at least one format is selected in Select Export Formats, and that you saved the widget and published the page.

The export is missing some records: The export contains only records the portal user can see. Check the user’s role and any Data loading Workflow selected in the widget.

Did this solve it?No, contact support