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

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