A company has a list of contacts in a Microsoft Excel file. The company wants to load the contact information into a Microsoft Power Platform solution. You need to recommend a data-loading solution. What should you recommend?

The "Import from Excel" feature is the standard, out-of-the-box tool designed specifically for loading data from existing Excel or CSV files into Microsoft Dataverse tables. This feature provides a user-friendly wizard that guides the user through mapping the columns from the source file to the columns of the target table (in this case, the Contact table). It is the most direct and efficient method for a one-time or bulk data load from a pre-existing file, which directly addresses the company's requirement to load contact information into their Power Platform solution.

A. A static worksheet is a one-way export of data from Dataverse to Excel. It cannot be re-imported to update or add records.

B. The Excel Template feature is used to create a pre-formatted file for users to fill out and then import. It is not the primary tool for importing an already existing data file.

1. Microsoft Learn, Power Apps documentation. "Import data (all record types)". This document explicitly states, "You can import data into tables in Microsoft Dataverse from files like Excel or comma-separated values (CSV)." It then details the process for using the "Import from Excel" command.

2. Microsoft Learn, PL-600 Learning Path. "Module: Perform solution and data migration". In the unit "Import and export data in Microsoft Dataverse," the documentation describes the "Import from Excel" and "Import from CSV" options as primary methods for bringing data into the platform from flat files.

3. Microsoft Learn, Power Apps documentation. "Export data to an Excel static worksheet". This document clarifies the purpose of static worksheets, stating, "When you export data to an Excel static worksheet, you create a copy of the data... The data in the static worksheet won't change if you change data in the app." This confirms it is not an import mechanism.