Edit

Edit table data in Excel and publish it back to Dataverse for Teams

  • Article

By opening Dataverse for Teams table data in Microsoft Excel, you can quickly and easily view and edit the data by using the Microsoft Power Apps Office Add-in. Dataverse for Teams table data in Excel.

To install the Power Apps Excel Add-in, see Microsoft PowerApps Office Add-in. For more information about how to add or remove an Office Excel Add-in, see Add or remove add-ins in Excel.

Open table data in Excel

  1. Sign in to Teams, and then in the left pane, select the Power Apps.

  2. Select the Build tab, and then select See all.

  3. In the left navigation pane, select Tables, next to the table you want, select …, and then select Edit data in Excel. Edit data in Excel command.

  4. Open the Excel worksheet that is downloaded to your browser's default download folder named similar to crdcb_table-name (1591125669213).xlsx.

  5. In Excel, select Enable editing to enable the Power Apps Excel Add-in to run. The Excel Add-in runs in a pane on the right side of the Excel window.

Important

  • If the pane displays an error message, see Office Store Add-in download disabling.
  • If this is the first time that you've run the Power Apps Excel Add-in, you must Trust this Add-in to allow the Excel Add-in to run.
  • The maximum table size when editing in Excel is one million cells. If there are too many rows or columns, not all data will be read or published.

Next steps