› Use Analytics for AP Agility › Export to Excel

Export to Excel

On any grid with Export to Excel functionality, you can export the content of the grid to Microsoft Excel. Analytics for AP Agility automatically exports the content of the grid.

If you use the Export > Excel functionality in the toolbar menu, set preferences for exporting the content of the view to Microsoft Excel:

  1. On the Export tab, select Excel.

    The Export to Excel window is displayed.

  2. In the Export content section, select "All pages of grid, top drill down level. Could take some time."
  3. Select an Export format option:

    • Unformatted XML file, readable by Excel

    • Formatted Excel file

    • Unformatted CSV file

    • Unformatted TSV file

  4. Optionally select Enabled to use a flat export, which retains granular details for drill down or expandable data.
  5. Click OK and when prompted, save or open the file.

If you hide any data on a chart and then export that view to Excel, the Export to Excel function generates a file without the hidden data.