You are right, to extract data from a mysql server, one way is using php with queries, it is required login (user/pass) , database and the table where there is the data. that is all.
I have works on Excel using macros and form, also I have expertise on Python PHP and Javascript so as you see I have the required knowledge for your project, my works have quality and warranty, check my portfolio and reviews.