troubleshooting Question

MySQL export to CSV?

Avatar of fcruz5
fcruz5Flag for United States of America asked on
6 Comments1 Solution788 ViewsLast Modified:

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.
Join our community to see this answer!
Unlock 1 Answer and 6 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros