Export data from Insights
Choose the right listing table and download its data as a CSV file.
Table of Contents
Use Insights to download a CSV listing for analysis in a spreadsheet. Select the worksheet that contains the listing you need; the default selection may be an information sheet or a chart.
Choose the listing you need
| Listing you need | Open in Insights | Select this sheet in Download Crosstab |
|---|---|---|
| Record listing from the summary dashboard | Record summary | record listing |
| Detailed records with benefits, recipients, and their statuses | Record listing | record listing (detailed) |
| Recipient listing | Recipient summary | recipient listing |
| Submitter listing | Submitter summary | sub listing |
| Records matching your form-analysis criteria | Form explorer | Record list |
Sheet names are shown exactly as they appear in the dashboards, including capitalization. The download window calls these tables sheets. For a listing, select the named listing sheet rather than an info sheet, count, trend, or chart. For example, info (rl) is not the detailed record table.
Download the listing as CSV
- Open Insights from the navigation bar and choose the dashboard from the table above.
- Set the filters for the records you need. Use the dashboard’s filter button; in Form explorer, also check selected questions, record criteria, and AND/OR match logic. Wait for the displayed results to update.
- Review the listing before exporting. Clear any unintended selections or filters.
- In the toolbar at the bottom of the embedded dashboard, select Download (the download icon).
- Select Crosstab.
- Under Select a sheet from this dashboard, select the exact listing sheet from the lookup table. Scroll within the sheet list if necessary. Check the selected card; the initial selection may be an informational sheet.
- Under Select Format, select CSV. Excel is a separate option and may be selected initially.
- Select Download, then open the downloaded CSV from your browser’s downloads.

Check the exported data
- Confirm the scope. Check the dashboard filters and compare a few references and values with the CSV. Keep the filter criteria with your analysis so others know what the listing covers.
- Check the level of detail. A request with several benefits or recipients can occupy multiple rows in the detailed listing. A row count is not necessarily a count of unique requests; use the request reference when identifying distinct requests.
- Read status columns separately. Record status, benefit status, recipient status, and allotment status describe different parts of the request.
- Check blanks and Null values. They are not automatically zero amounts. Some fields may not apply to a record or may have no value.
- Match the export to the question. Record list in Form explorer exports the matching-record listing. It is not a promise that every question and answer will be included as a column.
If the download is not what you expected
- If the file contains a title, information, or chart summary instead of rows, repeat the export and select the listing sheet named above.
- If Data is unavailable in the Download menu, use Crosstab for the listing export.
- If expected rows are missing, review filters and Form explorer criteria, then check the displayed listing again.
- If Insights or a download option is unavailable, contact your administrator about your access.