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
Comments
Post a Comment