I am trying to export a table in phpMyAdmin to CSV for MS Excel. It does it successfully, but fields that are NULL will display "NULL" in excel. Is there a way to export it without the fields displaying as "NULL"?
On phpMyAdmin, under Excel Options:
It says: "Replace NULL by: NULL
I cleared "NULL" from the option field figuring it would appear blank in Excel, but it doesn't.
Instead of leaving it blank, try putting a blank space