The error description can be obtained using debug logs.
An application error occurs during an Excel import if the file is not saved in the Excel Workbook format.
Files may have the XLS extension but are not actually saved as Excel Workbooks.
Excel itself will report this when opening such a file.
The files may be text-based; the solution is to re-save them in the Excel file format.