Contents
How do I remove a non UTF-8 character from a CSV file?
2 Answers
- use a charset that will accept any byte such as iso-8859-15 also known as latin9.
- if output should be utf-8 but contains errors, use errors=ignore -> silently removes non utf-8 characters, or errors=replace -> replaces non utf-8 characters with a replacement marker (usually ? )
How do I convert an Excel File to UTF-8?
Click File > Save As. You will see the Save dialog box. Via the File Format dropdown menu, select the CSV UTF-8 option. Click Save.
How to display CSV files with Unicode UTF-8 encoding?
First, go to Data > From Text to launch a Text Import Wizard. Now select the file origin to pick “65001: Unicode (UTF-8)”, this will turn your CSV file into something that’s legible.
How to export Visualforce CSV in UTF-8 format?
In the VF page on the first line I have (the strange use of outputText is something I’ve inherited from an existing implementation of a CSV export): The contentType is set to application/vnd.ms-excel#Export.csv;charset=UTF-8. By the time the UTF-8 CSV is output, it has the correct EFBBBF bytes at the start.
Can you use CSV characters outside of ASCII?
Unfortunately, CSV is a very ad hoc format with no metadata and no real standard that would mandate a flexible encoding. As long as you use CSV, you can’t reliably use any characters outside of ASCII. Write to XML (which does have encoding metadata if you do it right) and have the users import the XML into Excel.
Can You Put Persian characters in a CSV file?
Replacing OpenCSV with SuperCSV does not solve this problem. When I typed Persian characters into csv file manually, I don’t have any problems. Unfortunately, CSV is a very ad hoc format with no metadata and no real standard that would mandate a flexible encoding. As long as you use CSV, you can’t reliably use any characters outside of ASCII.