I am running into an issue where a vendor is sending us a report in .xls format (Excel 97-2003) and when it gets imported into EM via “Import Excel Spreadsheet” there are several cells that are blank. The fix we have found for this is to convert the file to csv first then import. This solves all the issues.
Is there a way to do this file conversion in EM? Taking the xls file and converting it to csv?
I can attach sample files if needed.