Connect to Excel from Power Apps
Excel is kind of a connection. To display Excel data in your app:
- Format the Excel data as a table.
- Store the Excel file in a cloud-storage account, such as Box, Dropbox, Google Drive, OneDrive, and OneDrive for Business.
- Connect to the cloud-storage account, and then add the Excel table as a data source.
- Display this information in your app by generating an app automatically or by adding and configuring, for example, a Gallery control.
When you connect to your Excel table from Power Apps, it will create a column called _PowerAppsId_, with a unique ID for each row of your Excel table.
Overview of the cloud-storage connection shows you how to add the connection, add an Excel table as a data source, and use the Excel data in your app.
For information about how to connect to other types of data, see the list of connections for Power Apps.
For information about how to share Excel data within your organization, review these limitations.