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.

Beginner Asked on October 11, 2019 in Saved Searches.

Thank you. Do you happen to know why the font is so tiny on a saved search export?

on October 16, 2019.
Add Comment
1 Answer(s)

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.

Per SuiteAnswers:

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:

http://support.microsoft.com/kb/948615

Beginner Answered on October 11, 2019.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor