How to export a MySQL table to Excel?

Question

PHP

Site on WordPress, you need to export a table in which mail is logged in Excel format
Google, there are some solutions, but most often it’s the other way around from Excel to the database, but even if I find it, I can’t figure it out
Tell me the true path

Answer 1

If you do not need to do such an export on a permanent basis, then you can do it through PHPMyAdmin (there are different options on what to export to on the "Export" tab).
If you need a script, then either PHPExcel, or look towards Mysql -> CSV.

Answer 2

For php there is PHPExcel

Answer 3

Navicat for mySQL.