Return data to Excel

To return to Excel, in the Microsoft Query dialog box, click the Return Data button.

Return Data button

Alternatively, on the File menu, click Return Data to Microsoft Excel.

Back in Excel, the Import Data dialog box appears, where you can choose which type of report to create.

The following examples show how to:

  • Create a table
  • Create a PivotTable report