How to Export Dataverse Table to Excel

Getting your Microsoft Dataverse data into a spreadsheet doesn't have to feel like a high-stakes technical operation. Whether you need a quick data snapshot for a meeting or a "live" report that updates automatically, you can connect your Dataverse table to Excel in just a few clicks. This guide will walk you through three different methods, ranging from a simple one-off export to a more powerful, refreshable connection for serious analysis.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Why Bother Exporting Dataverse Data to Excel?

While you can view and work with data directly in Power Apps or Dynamics 365, sometimes Excel is just the right tool for the job. You’re already familiar with it, and it gives you a ton of flexibility.

Here are a few common reasons to export a Dataverse table to Excel:

• Ad-Hoc Analysis: You need to quickly sort, filter, or create a pivot table to answer a one-off business question without building a formal report.
• Data Sharing: Your colleagues don't have access to Dataverse or Power Apps, but they need to see the latest sales figures, project updates, or customer lists. Sending an Excel file is a universal language.
• Custom Reporting & Charting: You want to build custom charts, dashboards, and calculations using Excel's powerful functions, formatting, and visualization capabilities.
• Bulk Edits & Manipulation: While not covered in this guide, once you have a connected sheet, you can sometimes edit data in Excel and publish the changes back to Dataverse, which can be faster than editing record by record in the app.
• Snapshots & Backups: Creating a quick point-in-time snapshot of your data for archival purposes is simple with a static export.

Now, let's look at the best ways to get it done.

Method 1: The One-Time Spot Check with a Static Export

This is the fastest and most straightforward way to get a copy of your data. Think of it as taking a screenshot of your Dataverse table and pasting it into Excel. It's a static, point-in-time copy — perfect for when you need the data right now and don't care if it's updated later.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

When to Use This Method:

• You need to send a report to someone as of this morning.
• You want to run a quick analysis that won't need to be repeated.
• You need a data snapshot for record-keeping or compliance.

Step-by-Step Instructions:

1. Navigate to Your Table: Log in to make.powerapps.com. On the left-hand navigation pane, select Tables. Find and click on the table you want to export (e.g., "Accounts," "Contacts," "Opportunities").
2. Select a View: In the upper-right corner of the screen, you'll see the name of the current view (e.g., "My Active Accounts"). The export functionality only exports the columns visible in your currently selected view. Click on the view name and choose the one that has the columns you need, or create a new view first with just the data you want. This is a crucial step to avoid exporting dozens of unnecessary columns.
3. Export to Excel: Once your view is set, look for the Export to Excel button in the command bar at the top of the list. Click it.
4. Download the File: An .xlsx file will be immediately downloaded to your computer. Open it up, and you’ll see all the data from your selected view neatly laid out in a worksheet.

What You Need to Know:

• This file has no connection back to Dataverse. If records are added or changed in your app, this Excel file will not see those updates.
• There's typically a limit to the number of rows you can export this way (often capped at 100,000 rows). For larger datasets, you'll need one of the other methods.

Method 2: Stay Up-to-Date with a Dynamic Worksheet

What if you want a report that you can refresh every day without having to export a new file each time? That's exactly what a dynamic worksheet does. It creates an Excel file with a live data connection back to your Dataverse table, allowing you to get the latest data with a single click.

This is the best choice for recurring reports, team dashboards, and any other process where you need to track changing information.

When to Use this Method:

• Creating weekly or monthly reports (e.g., sales performance, lead tracking).
• Providing a team member with a self-service way to get the latest data.
• Building a spreadsheet that always reflects the current state of your business.

Step-by-Step Instructions:

1. Follow the Same Initial Steps: Just like with the static export, navigate to your table in Power Apps and select the appropriate view.
2. Choose the Dynamic Worksheet Option: Click the Export to Excel dropdown menu. Instead of the default option, you will see other choices. Select Dynamic Worksheet.
3. Configure Columns (Optional): A new panel will open on the right, allowing you to double-check and edit the columns for your export. You can add or remove columns here before finalizing. Once satisfied, click Export.
4. Open and Enable Content: Download and open the generated .xlsx file. You may see a yellow security warning bar at the top of Excel. Click Enable Editing and then Enable Content to activate the data connection.
5. Sign In and Install Add-in: The first time you open a dynamic worksheet, you might be prompted to install the Microsoft Power Apps Office Add-in. Follow the instructions to install it. You'll then need to sign into your Dataverse account from the add-in's pane on the right-hand side of Excel.

Once connected, the data from your Dataverse table will populate the sheet.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Refreshing Your Data

This is where the magic happens. When you want the latest data, simply go to the Data tab in the Excel ribbon and click the Refresh All button. Excel will securely connect to Dataverse, pull the latest records, and update your sheet. You can also right-click anywhere in the data table and select Refresh.

This method brilliantly combines the analytical power of Excel with the live, single-source-of-truth data in Dataverse.

Method 3: The Power User's Go-To with Excel Power Query

For the ultimate control, flexibility, and power, connecting to Dataverse directly from Excel using Power Query is the gold standard. Power Query is Excel's built-in tool for connecting to, transforming, and loading data from hundreds of different sources — including Dataverse.

This approach lets you do things you can't with the other methods, like combining multiple tables, cleaning up messy data, and restructuring it before it ever touches a cell in your spreadsheet.

When to Use This Method:

• You need to analyze data from multiple tables at once (e.g., Accounts and their related Contacts).
• You need to perform data transformation like splitting columns, removing rows, or changing data types.
• You're building a sophisticated Excel dashboard that pulls from several sources.
• You need to work with more than the 100,000-row export limit.

Step-by-Step Instructions:

1. Start in Excel: Open a blank Excel workbook. Go to the Data tab in the ribbon.
2. Get Data from Power Platform: Click Get Data > From Power Platform > From Dataverse. (If you don't see this option, you may need to update Office or choose "From OData Feed" and use your Dataverse environment's OData URL.)
3. Sign In and Connect: A dialog box will appear. You might be prompted to sign into your Microsoft account. Once you do, Excel will discover the Dataverse environments you have access to.
4. Navigate to Your Table: Choose your environment from the list. A Navigator pane will open, showing a list of all the tables available. Find and select the table(s) you need. You'll see a preview of the data on the right.
5. Load or Transform: You now have two key options at the bottom of the Navigator window:

Like the dynamic worksheet, this connection is fully refreshable using the Refresh All button. The key difference is the immense transformative power you have before the data lands in your analysis.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Choosing the Right Method for Your Task

Still not sure which option to pick? Here’s a quick comparison:

Static Export

• Best for: Quick, one-time snapshots.
• Data Freshness: Point-in-time only. It never updates.
• Complexity: Very easy. Just a few clicks.

Dynamic Worksheet

• Best for: Reusable, refreshable reports based on a single view.
• Data Freshness: Updates on demand with a click of the "Refresh" button.
• Complexity: Easy, with a one-time sign-in and add-in installation.

Power Query Connection

• Best for: Complex analysis, combining multiple tables, and custom data shaping.
• Data Freshness: Updates on demand and can run complex transformations on each refresh.
• Complexity: Medium to advanced. Requires some familiarity with the Power Query interface.

Final Thoughts

Pulling your Dataverse tables into Excel opens up a world of possibilities for analysis and reporting. Whether you need a simple static dump, a live dynamic worksheet for a recurring report, or the full shaping power of a Power Query connection, you have the right tool available for any scenario.

While exporting to Excel is powerful, it can still lead to spending hours manually arranging pivot tables and constantly refreshing data for weekly reports. That’s why we built Graphed — to automate this final stretch of analysis. Instead of pulling data into spreadsheets just to build charts, you can connect your business platforms and just ask questions in plain English, like "show me our sales pipeline" or "compare marketing campaign ROI," and get a live, auto-updating dashboard in seconds.