I’m using DiscoverText to collect Twitter data that is mainly written in the Spanish language. When exporting the data there seems to be an encoding error because instead of the characters I see on the screen I get the raw ASCII format. For example:
Ã¡ instead of á
Ã© instead of é
Ã³ instead of ó
When I browse the Twitter tweets using the “View All Documents” option on DiscoverText I don’t have this issue. It only occurs after exporting the files to an Excel spreadsheet. Is there any way to prevent this character substitution issue?