Exporting Search Results to Excel – File Format Error
When I export a saved search to Excel and open the file, I receive an error message saying “The file format and extension of [export file name] don’t match. The file could be corrupted or unsafe. Unless you trust its source, don’t open it. Do you want to open it anyway?”
PS – I know the answer, but this is a question we get pretty frequently in Slack, so I thought I’d add it here for others that might be searching.
My understanding is that this error occurs because NetSuite outputs the excel export in an xml format to preserve formatting and be Excel version agnostic (and they haven’t devoted the resources to updating the file format that gets exported). This error can be safely ignored and there is no easy/simple fix to get around this error.
When exporting from NetSuite to Microsoft Excel there is a standard pop-up that will appear:
“The file format and extension of ‘xxx.xls’ don’t match. The file could be corrupted or unsafe. Unless you trust its source, don’t open it. Do you want to open it anyway?”
This is a standard message coming from excel when the extension does not match. Since NetSuite is the known source ‘Yes’ can be selected on this pop-up and the results will be exported.
It is recommended that users manually change file type from XML Spreadsheet to Microsoft Excel Workbook before saving the file.
For more information on this reference this article from Microsoft: