Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Export data from your model-driven app to Excel. The allowed data export size depends on the number of rows, columns, lookup fields, and lookup relationship types. The export query might time out depending on the combination of these factors.
From the left nav, select a table that you want to export data from.
On the command bar, select Export to Excel.
When the download is complete, navigate to the location of the downloaded file.
Note
When you download a worksheet, it should automatically save to your computer. However, if it doesn't then make sure that you save it before you open and edit it. Otherwise, you might get this error message: Excel cannot open or save any more documents because there is not enough available memory or disk space.
Follow these steps to fix the issue:
- Open Excel and go to File > Options > Trust Center Settings Center Settings > Protected View.
- In Protected View, clear all three items.
- Select OK > OK.
We still strongly recommend that you save and then open the data file rather than disabling protected view, which might put your computer at risk.
Open the saved Excel file.
If you see the security warning External Data Connections have been disabled, select Enable Content.
The data is exported in the same format that you see in your app. Text remains as text, numbers remain as numbers, and dates remain as dates. However, when you export data from your app to Excel, some cell formats might change. The following table summarizes how you see the data in apps and how the cell format changes when you export the data to Excel.
| Data format in model-driven apps | Cell format in Excel |
|---|---|
| Text, Ticker Symbol, Phone, Options set, and Look Up | Shows as Text and option set becomes drop-down list |
| Email, URL | Shows as General |
| Number | Shows as Number without group separator |
| Currency | Shows as Number and doesn't include dollar sign ($) |
| Date only, Date and Time | Shows as Date only |
| Calculated and Roll-up columns | Editable in Excel but can’t be imported back to Power Apps |
| Secured columns | Editable in Excel but can’t be imported back to Power Apps |
Export options
There are other export options such as Excel Online, Static Worksheet, Dynamics Worksheet, or Dynamics PivotTable.
The following table summarizes the different options. Pick the one that works best for you.
| Task | Learn more |
|---|---|
| Do an ad-hoc or what if analysis without modifying app data. Or, quick bulk edits to multiple rows. | Open app data in Excel Online |
| Get a snapshot of the data at the current date and time or if you want to share the data with others. | Export to an Excel static worksheet |
| Get the most up-to-date information and be able to refresh it in Excel and match what you see in your app at any time. | Export to an Excel dynamic worksheet |
| View your app data in a pivot table. | Export to an Excel PivotTable |
Known issues
Exporting to Excel doesn't support virtual tables.
If Export to Excel times out, try these options:
- Export smaller batches by adjusting the filter criteria.
- Reduce lookup fields that increase query complexity when retrieving data from related tables.
- Reduce the number of columns.
You can export your app data to Excel (.xlsx format), use the file as a template to add more data, and import it back into your app. If you add or modify columns in the Excel file and import it back into your app, the import fails because the added or modified columns don’t map to tables in your app. When you import an Excel file into your app, make sure that columns and tables are mapped correctly to avoid import failures. For more information on mapping, see Review mapping.
If you’re using Excel 2010, you might get this error message when you export data from the Accounts area:
The file is corrupt and cannot be opened.
The error message occurs due to a setting in Excel. To fix the issue:- Open Excel 2010 and go to File > Options > Trust Center > Trust Center settings.
- Select Protected view and then clear the check boxes for the first two options.
- Select OK and then close the Options dialog box.