Forum Discussion

Parvez_AL's avatar
Parvez_AL
Advisor
9 months ago

Invalid characters for Analytics downloaded topics for other languages

All downloaded CSV content topics for other languages has invalid characters in Community Analytics. Can this be fixed? As per support and engineering this is an issue with MS Excel as it works fine ...
luk's avatar
luk
Boss
9 months ago

I would expect Excel to not deal properly with UTF-8 data in CSV, so what you could try instead of directly opening the .csv with Excel is to use the import function within the "Data" tab where Excel allows you to specify the character-encoding. Select import from text and choose your csv file then select UTF-8 encoding. Not sure that helps, but that's what I would try (not using Excel for years 😉).