Send report data to Excel with Report Designer (video)

You can now send any Sage 200cloud report data to Excel. This allows you to analyse data from your reports in a table format in Excel. You can then work with the data in Excel, such as filtering the information, or using pivot tables. This is different to the existing functionality to Export data to Excel.

  • To send the report to Excel, click Data to Excel from the report preview.

Note: You can't do this when the report is sent to the spooler first.

Send data to Excel

This video shows you:

  • How to send data from a report to Excel using Data to Excel.

    Note: The video describes the Send to Excel option, which has been renamed to Data to Excel.

Viewing tips

If the video is too small, try the following tips to see it at full size:

  • Maximise your browser window.
  • Use the 'full screen' mode in the video player, if it has this option.