Bug #64955 Mysql Workbench Excel file export has not a proper extension "xls"
Submitted: 12 Apr 2012 14:14 Modified: 30 Aug 2012 22:04
Reporter: pedro oriani Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:5.2.39 OS:Any
Assigned to: CPU Architecture:Any

[12 Apr 2012 14:14] pedro oriani
Description:
The export file output defined as 'Excel Spreadsheet (.xls)'
this is misleading cause the proper extension for XML Excel 2002/2003 is xml.
If not clearly specified xls as to be intented as Excel Biff format 97/2003

taken from wikipedia: Microsoft Office XML formats

Microsoft Office Excel 2002 and Excel 2003 XML Format — SpreadsheetML (.XML)

How to repeat:
Sql Editor > Query > Click on Export on output

Suggested fix:
Update name description in combobox and/or change extension file to .xml
[12 Apr 2012 14:21] Valeriy Kravchuk
Thank you for the bug report. Indeed, file is exported with XML content but .xls extension.
[30 Aug 2012 22:04] Philip Olson
Fixed as of the upcoming 5.2.43, and here's the changelog entry:

Exported "Excel Spreadsheet" files were exported with the ".xls"
extension, instead of the ".xml" extension.

Thank you for the report.