php - Excel exports CSV - what to do about HTML entities? -

I have an Excel spreadsheet that I am exporting to CSV as HTML entities to ? Is there a way to convert the spreadsheet into CSV and convert those HTML entities into a CSV compatible equivalent?

My ultimate goal is to import CSV into a MySQL database using a PHP script. Consumers of data will mostly be using it within a web environment, but this is not necessarily true always.

If your save as command is not working properly then Check that you have some encoding problems