Blog

Data - How to view the progress and status of a Dataverse CSV/Excel Import

When users import Excel data from a model-driven app table, where can we find the import results? This post describes where to look.

Users can import records from model-driven apps by clicking the Import from Excel menu item, as shown in the screenshot beneath. 


This opens a panel to upload an Excel or CSV file and to define the source and destination columns.

Completing this process opens the confirmation screen shown beneath. This includes a 'Track Progress' button to view the details and progress of the import.


If we accidentally close this window, how can we return to 'Track Progress' page?

The answer is that we can see the result through a built-in system table

How to view the Dataverse Excel/CSV file import history

To access this system table, go to the Tables section in the designer, click the 'All' tab and search for the word 'import'. We should see a table called 'Import Source File' (shown below).


The screenshot below shows what we see when we open this table. The rows at the bottom show the import history and status.


When we open one of the import records, we can see the rows that succeeded, failed, or partially failed.

Conclusion

To view the import history of records imported into Dataverse through the table view of a model driven app, we can inspect a system table called 'Import source file'.