This is a small project relating to a market research site where I store information about my customers in the form of a Wordpress site. The database records are in the form of "posts". I have about 40 customers at this time. I need certain fields exported from one of the MySQL databases for that site into an Excel spreadsheet. I would like this to be done in 24 to 48 hours.
I have attached the form of Excel file where the data will go.
Also, at the end, I would like a written explanation, not long, basic enough for me to get the idea of how you did it. For example, I know how to export an entire MySQL database/table in various formats, but I don't know which database or table to export from and how to identify the particular fields to export. Thanks.