TableTools export as CSV - Trademark character not displaying properly in Excel

jon93

Hello,
I am currently using the TableTools plugin to save a table to CSV. Cells may contain special characters (Smart Quotes, Registered symbol ® or Trademark symbol ™).

The ™ does not display well in Excel - regardless of the version of Excel, there is an exclamation mark (' ! ') at the position of the ™ and an extra quote (' " ') at the very end of the cell. In Notepad++, the special characters show properly.

I tried importing the file as a text file (from the "Data" tab in Excel) and changing the encoding (UTF8, US ASCII, etc.) but that did not do the trick. Note that I changed the default CSV encoding in the tabletools JS file from UTF8 to UTF16le, which enabled the display of the ® symbol.

Does any of you have an idea about this?

Thank you,
Jon

visionx

Did you enable the BOM for CSV export? Try as following way.

aButtons: [{ "sExtends": "csv",
"bBomInc": true,
"sFileName": "*.csv"}]

jon93

Thank you visionx, that worked!