Skip to Content
avatar image
-1
Former Member

Junk data is coming in my downloaded Excel

Hello,

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • 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)

    Add comment
    10|10000 characters needed characters exceeded

    • 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).