Exporting Resultset

Starting from SQLyog version 5.22 the export options from the RESULT tab and the DATA tab are identical and compared to previous versions. Right click in the grid where the resullt is shown and choose 'Export data'. We support export to XML (two XML versions actually: a simple XML format and the XML format used by Microsoft Excel), HTML, CSV and various SQL formats.

Read more details about the export options (in the paragraph about 'tables') here.