Exporting QuickBooks report to Excel makes it easier to manipulate the information.
Virtually every QuickBooks report has the option of Create New Spreadsheet or Update Existing Worksheet.
To export a report to Excel in QuickBooks:
NOTE: The default file created by Office 2007 & 2010 is an .xlsx file. To have Excel create files in an .xls format by default, complete these steps prior to exporting the desired report: