Load data into a table
If you're going to import data into a table, remember that every table has required columns. Therefore, your input file must include these required columns. A good technique to modify table data quickly is to create a template. First, export data from the existing table. You can then use the same file (modified with your data) to import data into the table.
This template typically saves time and effort, primarily because you won't have to account for the required columns for each table. If you're unfamiliar with how to export data from a table, the next lesson discusses the necessary steps in that process. The starting point is your Power Apps table editor.
To load data into a table, use the following steps:
Prepare the file template.
Export the table by selecting the Export button from the command bar then Export data from the subsequent dropdown.
On the Export data popup, select Download exported data. Once you've begun this process, you need to check your browser's downloads to find the zipped file. You'll need to extract the Microsoft Excel Comma Separated values file that will have the name of the table that you exported.
Copy or input any data into the template that you created and save the file as an Excel file.
Import the data into your table.
Return to the Power Apps Tables edit screen and ensure you've selected the right table that you want to import data into.
From the command bar, select Import > Import data from Excel.
An Import data popup will open. Select the Upload button (or select the "File not uploaded" input field, both serve the same purpose).
Find your csv file from the Open popup to open the file. The Mapping status will take a moment to update. If done correctly, you'll see a message indicating that "Mapping was successful".
Select the Import button from the top right of the Import data popup, to begin the data import. Once the import is complete, you'll see a status message updating you on whether or not the import was successful.
Close the popup, and you should be able to find the imported data in your columns in data (or you can select the Edit option from the columns and data to show more columns to help you find the imported data). You might need to refresh your browser's cache to see the changes.
With this technique for exporting your data as a template, adding data to the template, and importing it back to your Dataverse table, you can easily import data into your table.