Exporting MySQL table to Excel file?

programming
1

Say I had a table with 4 fields - name, surname, email, phone - and I need an easy way for the user to download the table as an Excel spreadsheet (CSV format?), how would I do it?

I basically just need:
[FONT=Courier New]name1 surname1 email1 phone1
name2 surname2 email2 phone2
name3 surname3 email3 phone3

[FONT=Verdana]Obviously, they need to be arranged into columns in Excel, with each value inside a cell.

What’s the easiest way to do this?

Thanks in advance :slight_smile:
[/FONT][/FONT]