Export data from Dataverse and use Microsoft Excel to edit records

Beginner
App Maker
Functional Consultant
Power Apps

Note

App in a Day instructor-led training

Continue your learning journey with the App in a Day instructor-led workshop. This course provides hands-on experience for building custom apps! Browse training events.

Explore how you can use Microsoft Excel files to export and edit Microsoft Dataverse table data.

Learning objectives

In this module, you'll:

  • Learn how to export data from Dataverse into Excel files.
  • Discover the different exported file types.
  • Learn about the security concepts for the exported data.

Prerequisites

  • A Power Apps license
  • Access to Microsoft Dataverse
  • Access to Microsoft Excel
  • A basic understanding of what a database is and its role within a software solution.