If you’ve ever imported data into Dynamics 365 or troubleshooted an import, you’ll know that it can be incredibly frustrating to deal with high numbers of errors–especially if the import source file was an Excel file (.xls or xlsx). You might notice that there is no option to export your errors! If even a few dozen errors occur, it is inefficient and painful to manually match the error with the line item from the original import file.
It’s entirely possible to export the error logs–but only if you use the correct file type to import the records in the first place!
Both “.xml” and “.csv” file types will allow you to export any error logs under the “Failures” tab in the import window. Dynamics will provide a .csv file with the errors–you’ll just have to use the “Text to columns” feature in Excel to separate the data into the appropriate columns.
For more on troubleshooting imports, check out this blog post!