The last time i post on how you can convert mysql files to csv, but how about if you want to directly convert the entire sql table to excel file, well here is a trick.

mysql -uroot -p your_db -Be “select * from your_table” > /home/folder/your_table.xls

Hope this helps… Do drop me a comment if it did.

Like this blog? Why not buy me a cup of coffee?