Reports in Excel

Build 1501 on 14/Nov/2017  This topic last edited on: 25/Oct/2016, at 11:54

It is possible to import the XML reports directly in Excel 2007. Select 'Import' in the 'Developer' tab:

reporting2

Select the report XML file or URL in the resulting file selection dialog, then Excel will prompt for a confirmation:

reporting3

and for where to place the data:

reporting4

Simply clicking 'OK' on both dialogs produces something like this as the end result:

reporting5