sap abap XXL (EXtended Export of Lists)

A tool for displaying and manipulating list objects from R/3 applications. XXL is based on the Microsoft Excel spreadsheet program.

e.g. on ABAP/4 Query using SAPGUI 4.0b

• Further processing options - click Spreadsheet
• execute your query and wait for the Export list object to XXL menu box to appear
• click Excel 4 / SAP macros and click continue
• in the Excel click Enable macros if prompted
• the rest is Excel command which you can try on your own