Search code examples
phpmysqlexcelcsvhtml-entities

Excel exports CSV - what to do about HTML entities?

I have an Excel spreadsheet that I'm exporting as a CSV. HTML entities are being converted into a ?. Is there a way to convert the spreadsheet into a CSV and convert those HTML entities into the CSV compatible counterpart?

My ultimate goal is to import the CSV into a MySQL database using a PHP script. The consumers of the data will mostly be using it within a web environment, but that's not necessarily true always.

Solution

  • If your Save As command is not working properly then you have some encoding problems. Check this question