Skip to Content

Can't export to Excel from MB5L?

Hi all.

Seems after last update, we have lost the function to export from many TA's including MB5L, directly to spreadsheet. Now I have to export to txt and then import to Excel and convert the data to a table. The problem is that when exporting to txt, not all lines are being correctly separated by tabs, and this makes me spend hours running through hundreds of thousands of lines each exported file at a time, or else risk many lines being blank or even having to concatenate the infracting lines one by one, often having to guess were the break points should be.

Is there any way to force export to Excel?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jan 05, 2015 at 04:32 PM


    Whether you have upgraded to EHP7? Then you need to refer Text With Tabulators in place of Spreadsheet.

    Please refer below SAP Note which could be useful to you  2083705 - Save Local File - Spreadsheet option is missing after Support Package SAPKB74001.


    Add comment
    10|10000 characters needed characters exceeded

    • Nuno Marques Felipe Ricardo Guerra Soto

      Seems like the authorizations have been pulled to export to Excel from this transaction. I can export form others, but this one seems to be off limits for now.

      Thanks for taking the time to reply. Cheers!

  • avatar image
    Former Member
    Nov 25, 2015 at 12:43 AM

    Hi Marques,

    Try to convert the excel file to text tab delimited (its text format) by giving save as, it show whether ur data are properly tabbed or not and also use text file to export.

    Add comment
    10|10000 characters needed characters exceeded