How do I create a Dataverse table from Excel?

Select Tables > Create with Excel or .CSV file, upload the workbook, review the columns and select Save and exit. See Create and edit tables using Power Apps .

Can I import Excel data into an existing Dataverse table?

Yes. On the table, select Import > Import data from Excel, pick the sheet, map the columns and import. See Import data from Excel and export data to CSV .

Will importing Excel create duplicate rows?

With Primary key (None), every row is added as new. Pick a key column in the mapping to update existing rows.

Can I use a CSV file instead of Excel?

Yes. Both the Create with Excel or .CSV file tile and Import data from Excel accept .csv files.

Create a Dataverse Table from Excel or CSV in Power Apps

The SPGuides purchasing team tracked eight vendors in an Excel workbook that got emailed around for every update. They wanted it in Dataverse, with no retyping.

In this tutorial, we’ll create Dataverse table from Excel data in Power Apps: upload the workbook, check the AI column types, fix the table properties, then import more rows from a second file.

Here’s what we’re building: a Vendor table with all 10 vendors, eight from the first file and two added later.

Dataverse Vendor table in Power Apps showing 10 vendor rows after the Excel imports

Table of Contents:

Before You Start

A Dataverse table is a database-backed sheet with real data types and security. New to it? Start with what Microsoft Dataverse is.

You need System Customizer to create tables and Environment Maker to import rows. Get Data from Excel isn’t in the Power Apps Developer Plan.

Our workbook, SPGuides Vendors.xlsx, has a Vendors sheet with seven columns:

Excel column	Example value	Dataverse type the AI picked
Vendor Name	Fabrikam Inc	Text (became the primary column)
Contact Name	Megan Bowen	Text
Email	A work email address	Email
Phone	A business phone number	Phone
State	WA	Text
Contract End Date	12/31/2026	Date only
Active	Yes	Yes/No

The eight sample rows (Email and Phone left out):

Vendor Name	Contact Name	State	Contract End Date	Active
Fabrikam Inc	Megan Bowen	WA	12/31/2026	Yes
Northwind Traders	Alex Wilber	WA	03/31/2027	Yes
Adatum Corporation	Adele Vance	IL	11/30/2026	Yes
Litware Inc	Lee Gu	TX	06/30/2027	Yes
Tailspin Toys	Diego Siciliani	MA	10/31/2026	No
Wingtip Toys	Grady Archie	CO	01/31/2027	Yes
Proseware Inc	Isaiah Langer	GA	09/30/2027	Yes
Relecloud	Lynne Robbins	NC	12/15/2026	No

Keep one header row and no merged cells or blank rows. Building by hand instead? See the other ways to create a Dataverse table.

Step 1: Upload the Excel File

In make.powerapps.com, pick your environment and select Tables.
Select the Create with Excel or .CSV file tile.