web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Where is Edit in Excel...
Power Apps
Answered

Where is Edit in Excel option for Dataverse tables?

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Where is the option to edit the Dataverse table in Excel? Normally it is an option shown here after clicking on the ellipses next to a table.Capture.PNG

I've noticed this is missing as of 5/27/2022 and was present as of 5/26/2022. It's probably part of the update but where is it now or is this no longer supported?
Thanks, K

I have the same question (0)
  • Drew Poggemann Profile Picture
    9,287 Most Valuable Professional on at

    Hi @Anonymous ,

     

    I went into the table in my situation and in the top navigation I see the "Edit data in Excel".  Does this work for you?

    dpoggemann_0-1654091357290.png

     

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Hi @dpoggemann ! I don't see an option for Edit in Excel, but I don't have a dropdown next to Edit. I see that is what you have, I am listed as an owner so I don't know why I don't have it. Also I'd like to mention we are using Dataverse for Teams.Capture2.PNG

  • Verified answer
    Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Hi @Anonymous , I don't know whether you solved the problem yet, but I encountered the same thing.

    If you select Tables in the Build tab in Power Apps for Teams, but don't select a specific table, you will get the option to 'Open in Powerapps' at the top of the screen.

     

    Maggie_90_1-1654511115740.png

     

     

    When you open in Power Apps your tables are shown again, and if you now click on the three dots next to one of the tables you get a drop down menu when you choose edit, and here you can select 'Edit in Excel'.

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Thank you so much @Anonymous I hope Microsoft will update their documentation to follow this new UI workflow as it was not intuitive until you told me about it. Can't thank you enough for your helping me and my team!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 519 Most Valuable Professional

#2
11manish Profile Picture

11manish 489

#3
Haque Profile Picture

Haque 327

Last 30 days Overall leaderboard