Skip to Content

Junk data is coming in my downloaded Excel

Jan 30 at 09:45 PM


avatar image


I'm trying to download SAP data into excel in OS by using OPEN DATASET ENCODING UTF-8, most of the data is ok, but getting junk for Trade Mark symbol (TM symbol as super-script/sub-script), as below

Tarde Mark 1™ symbol

Pl. let us know how get this TM symbol from SAP to Excel

Thank you

10 |10000 characters needed characters left characters exceeded

Any help pl.?



Google for info on how to create macros in excel from ABAP.

And then accordingly you can check how to create a superscript macro in excel from ABAP


* Please Login or Register to Answer, Follow or Comment.

1 Answer

Sandra Rossi Jan 31 at 08:26 AM

When you say Excel format, it's in fact CSV in your case.

Excel only opens correctly a CSV file without special action by storing the text under UTF-16LE (SAP code page 4103) with a BOM, and fields separated with a horizontal tabulation character.

Otherwise, the user may need to open the file using Excel menu Data -> Open from text -> Import, then choose the code page "65001 Unicode UTF-8".

Workaround: use the XLSX format instead of CSV (search for abap2xlsx)

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Thank you Sandra, we are saving data in .XLS format, user will specify a file name themselves on the selection screen of the report, but we educated the user to specify only .XLS format, example, my_download_file.XLS

Any ideas pl. how to get Trade mark symbol on my_download_file.XLS?

thank you


Mentioning XLS as an extension does not make the XLS format. If it was the true XLS format (binary format also called BIFF, which existed before Excel 2007 XLSX), you wouldn't have issues with character encoding. So, users choose XLS extension name, and it's CSV format (or CSV-like format), which is a text format, and thus may lead to issues with character encoding.

The answers are in my previous reply (choose one among the 3 possible solutions, respectively proposed in paragraphs 2, 3 and 4).