Export data to Excel
Export data from your model-driven app to Excel. You can export up to 100,000 rows of data at a time.
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 will remain text, numbers will remain numbers, and dates will remain dates. However, when you export data from your app to Excel, some cell formats might change. The following table summarizes how you’ll 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
You can export your app data to Excel (.xlsx format) and use the file as a template to add more data and import back into your app. However, if you add or modify columns in the Excel file and then import the file back into your app, the import will fail. This happens because columns were added or modified and those 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 otherwise the import will fail. 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, do this:
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.