THERE ARE TWO OPTIONS TO EXPORT SPREADSHEET IN SAP:
1) AFTER GENERATED SAP REPORT, GO à LIST à EXPORT à SPREADSHEET OR
1) AFTER GENERATED SAP REPORT, GO à LIST à EXPORT à SPREADSHEET OR
2) AFTER RUN THE REPORT, RIGHT CLICK MOUSE à SPREADSHEET.
3) In pop up box, select ‘All Available Formats’ à 08 Excel(In previous XXL format)
Remember check ‘Always Use Selected Format’ to save the change into sap system.
4) After click ‘thick’ to complete.
4) After click ‘thick’ to complete.
IF THE POP UP BOX ABOVE DIDN’T APPEAR, ADDITIONAL STEPS REQUIRED. REASON BEING THE PREVIOUS ALV/FORMAT SETTING ALREADY SAVED INTO SAP SYSTEM
a) Go à System à Services à Reporting OR transaction code: sa38
a) Go à System à Services à Reporting OR transaction code: sa38
b) Click execute to run ‘SALV_BS_ADMIN_MAINTAIN’ program.
c) Under Actions tab à Display ; under General Data à Detailed Selection ;
c) Under Actions tab à Display ; under General Data à Detailed Selection ;
Under ALV Data à All. Put correct client and specific user name. 
d) Highlight row to delete any result return if any. After repeat number 1-4.
d) Highlight row to delete any result return if any. After repeat number 1-4.
