# Analyzing report data with Excel and XML
> APPLIES TO: Business Central 2021 release wave 2 and later
As a developer or advanced user, it helps to inspect the data that is generated for a given report dataset while you create new reports or modify existing ones. To support this capability, you can export a report dataset as raw data to an Excel workbook or XML file&mdash;directly. In Excel, for example, you can then do ad-hoc analysis of the data and diagnose issues.
## Export a report dataset
To export a report dataset to an Excel workbook or XML file, open the report in the client, then in the request page, select Send to > Microsoft Excel Document (data only) or XML Document. The file downloads to your device.
## Understand Excel data-only exports
The Microsoft Excel Document (data only) option exports the report results and the criteria used to generate them&mdash;but it doesn't include the report layout. The Excel file includes the full dataset, as raw data, arranged in rows and columns. All data columns of the report's dataset are included, regardless of whether they're used in the report layout.
Once you have the Excel file, you can start analyzing the data. For example, you could filter the data and use Power Pivot to display it.
Each export creates a new workbook. Exporting the report again doesn't automatically refresh an existing workbook. To reuse an analysis, export the report for the new period, copy the data into your existing workbook, and refresh the analysis that uses that data. You can also find a reporting app on Marketplace<https://marketplace.microsoft.com/>.
> NOTE
> You can't export a report that has more than 1,048,576 rows or 16,384 columns. With Business Central on-premises, the maximum number of exported rows might be even less. Business Central Server includes a configuration setting, called Max Data Rows Allowed to Send to Excel, for decreasing the limit from the maximum value. See Configuring Business Central Server<dev-itpro/administration/configure-server-instance#General> or contact your administrator.
## For administrators
 Microsoft Excel Document (data only) was introduced as an optional feature in the 2021 release wave 1, update 18.3. To give users access to this feature when running 2021 release wave 1, enable the Save report dataset to Microsoft Excel Document feature update in Feature Management. See Enabling Upcoming Features Ahead of Time<dev-itpro/administration/feature-management>. In 2021 release wave 2, this feature became permanent.
 To use Microsoft Excel Document (data only), user accounts need the Allow Action Export Report Dataset To Excel system permission. You can give users this permission by assigning the Export Report Excel permission set, whose display name is Export Report DataSet to Excel, or a permission set that includes it, such as Excel Export Action. See Assign permissions to users and groups<ui-define-granular-permissions>.
## For developers and advanced users
The Microsoft Excel Document (data only) option exports all columns, including columns that hold filters and formatting instructions for other values. Here are a few points of interest:
 Binary data in a field, like an image, isn't exported.
  In columns that hold binary data, fields include the text Binary data ({0} bytes), where {0} indicates the number of bytes.
 The Excel file also includes the Report Metadata worksheet.
  This worksheet shows the filters applied to the report and general report properties, like the name, ID, and extension details. The filters are shown in the Filter (DataItem::Table::FilterGroupNo::FieldName) column. The filters in this column include filters set on the report's request page. It also includes filters defined in AL code, for example, by the dev-itpro/developer/properties/devenv-dataitemlink-reports-property and dev-itpro/developer/properties/devenv-dataitemtableview-property.
For more information about report design, see Report Overview<dev-itpro/developer/devenv-reports>.
## Related information
ui-work-report
Managing Report and Document Layouts<ui-manage-report-layouts>
Assign Permissions to Users and Groups<ui-define-granular-permissions>
Working with Business Central<ui-work-product>
Find free e-learning modules for Business Central here<https://learn.microsoft.com/training/dynamics365/business-central>

Copyright (c) Microsoft Corporation. CC BY 4.0, https://creativecommons.org/licenses/by/4.0/; code samples MIT. From https://learn.microsoft.com/en-us/dynamics365/business-central/report-analyze-excel, MicrosoftDocs/dynamics365smb-docs at 46907ac (2026-11-19). Changed: includes filled in, links to this site, and for agents shortened without dropping a fact. https://jonas-paprotka.de/docs/report-analyze-excel/
