Connect to Excel from Power Apps
Excel is a connection that becomes a data source when added to Power Apps. To connect to Excel from Power Apps, follow these three steps.
Step 1 - Format your data as a table in Excel
Ensure that the Excel data you want to use in Power Apps is formatted as a table in Excel.
Step 2 - Store your Excel file in a cloud location
Store the Excel file in a cloud-storage account, such as Dropbox, Google Drive, OneDrive, and OneDrive for Business. There are two versions of the Excel connector. The newer version Excel Online (Business) of the connector can access more cloud locations.
Step 3 - Add Excel as a data source for your Power App
- Sign in to Power Apps.
- Depending on how you want to create your app, from the home screen, select one of the following options:
- To create a single-page gallery app with a responsive layout, choose either:
- Start with data > Connect to external data > From Excel.
- Start with page design > Gallery connected to external data > From Excel.
- To create a three screen mobile app, select Start with an app template > From Excel.
- To create a single-page gallery app with a responsive layout, choose either:
- Only one connection is shown at a time. To select a different connection, select on the ... button to switch connection or add a new connection.
- Enter the file location and select the table.
- When you're done, select Create app.
Use the Excel Online (Business) Connector
In the past, Power Apps used the OneDrive connector to connect and get data from Excel. The OneDrive connector provided access to files on OneDrive and to Excel. Now authors should use the new recommended Excel Online (Business) connector. The Excel Online connector allows multiple users to access it and improved functionality.
Other connectors
For information about how to connect to other types of data, see the list of connections for Power Apps.
Known limitations
For information about how to share Excel data within your organization, review these limitations.