Exporting from Gecko is easy. But what should you do if the characters on your export look different? If this sounds like an issue you're encountering, then don't worry; in a few simple steps, we'll help your .CSV return to normal.
How to fix it
- Right-click the .CSV file you exported, and select to open it using Notepad (or any other plain text editor)
- Once opened, click File > Save As
- In the dialogue window that appears - select UTF - 8 from the encoding field and pick type of file - all files. Then click Save.
Now open your .CSV file again using excel (or any other spreadsheet application). The characters should be looking normal again.
By default, all Gecko exports are encoded in UTF - 8. However, there are times when this is overwritten by the default encoding settings on your spreadsheet application. Following the above steps will ensure you easily side-step this issue in the future!
Any questions? Feel free to start a live chat with a member of our support team or explore the rest of our academy at your leisure.