Change the file format to another Excel format:
 
  1. Open or highlight the query to export.
  2. Select File, Export from the menu bar.
  3. On the Export Parameters screen, select another Excel format.
  4. In the Destination field, select Disk File and click OK.
  5. Enter a valid Export file name (including the file path), or click browse [...] and locate the file's destination and click OK.
  6. Click Export now. When the query finishes exporting, a message appears stating the export file was created.
     
Note: Query is a grouping tool, not a reporting tool so the results may contain 'duplicates'. We recommend exporting the query from the Export module instead to eliminate duplicates and only export from the query when the information cannot be obtained from the Export module