Create a Dataverse Table from Excel or CSV in Power Apps

Recently, I needed to import some Excel data into Dataverse for one of my Power Apps projects. At first, I thought it would be a simple copy-paste job, but it wasn’t. I encountered a few limitations and began exploring alternative options.

That’s when I discovered three easy and practical ways to get Excel or CSV data into Dataverse using Power Apps:

• Create a Dataverse table from Excel or CSV
• Import Excel or CSV into Dataverse Using Power Apps Dataflows
• Add Excel data to an existing Dataverse table

In this post, I will show you all three methods step by step. If you’re dealing with Excel files and want to push that data into Microsoft Dataverse, these approaches will save you a lot of time.

Create a Dataverse Table from Excel or CSV

Suppose you’re working on an internal employee onboarding app, and you have all the employee records stored in an Excel file.

Instead of manually creating columns one by one in Dataverse, I wanted a faster way to turn that Excel file into a fully functional Dataverse table.

Follow the below steps:

1. Open Power Apps and go to the Tables section to open Dataverse.

2. Click on “Create with Excel or .CSV file” at the top.

3. Select Excel (or CSV) as your data source. Upload your Excel file.

4. Power Apps will read your headers and show a preview.

5. Click Save and exit.

Then you can see that Dataverse table is created with the same columns and data.

This way, you can create a Dataverse table from Excel or csv.

Check Out: Add Copilot Studio Knowledge Files Using Power Automate

Import Excel or CSV into Dataverse Using Power Apps Dataflows

Here’s how you can use Power Apps Dataflows to import data from Excel or CSV files into Dataverse, a more powerful and flexible method, especially useful for scheduled refresh or clean transformations before loading.

Suppose you are helping a retail business in the U.S. set up a sales dashboard using Power Apps and Dataverse. They had historical order data in a CSV file, which included details such as customer name, state, category, and order totals.

To avoid manual data entry, I used Power Apps (Power Query) to import the CSV data directly into Dataverse.

Now follow the below steps:

1. Go to Power Apps. In the left-hand menu, select Dataflows. Click on + New dataflow

2. Give your dataflow a meaningful name like Retail Sales Import. Click Create.

3. Select Excel workbook (for .xlsx) or Text/CSV (for .csv).

4. For local files:
   • Choose Upload your file
   • Upload the US-Retail-Sales-Demo.csv
5. Click Next.

6. Now, Power Query will open:
   • You can:
     • Rename columns
     • Change data types
     • Remove or filter rows
     • Apply transformations (optional)
7. When ready, click Next

8. Choose whether to load to a new table or existing table
   • To create a new table, give it a name and configure columns

9. Then, you can choose to refresh this dataflow on a schedule (e.g., daily, weekly). Click Publish.

Your dataflow will now start running.

Once completed, your data will be available in the Dataverse table.

Read: Create Multi Agent in Copilot Studio

Add Excel Data to an Existing Dataverse Table

For this example, I already created a Dataverse table called Customer Feedback.

Here I will add the Excel data below:

Now follow the below steps:

1. Go to Power Apps. Select Tables from the left-hand menu. Find and click on your existing table (Customer Feedback).
2. In the top-right, click on the “Import” dropdown. Choose “Import from Excel“.

2. Click the Upload button and select your Excel file. Then click on Import.

3. Once completed, go back to the table view. You’ll see all new rows from Excel added to your Dataverse table.

These three methods make it super easy to import Excel or CSV data into Dataverse. Whether you’re creating a new table, using dataflows, or updating an existing one, each option helps save time and avoid manual work. Try them out and choose the one that best fits your scenario.

Other Dataverse articles you may also like:

• Power Automate Dataverse Add New Row
• Prompt in Power Apps
• Calculate Days Between Dates in Power Apps
• Get Dataverse Created by in Power Automate
• Remove Commas From Dataverse Number Field