Export MYSQL phpadmin to Excel

Question

I am a little new to MYSQL and PHP so any help is much appreciated. I have a database right now that is storing ten values, a name and 9 scores. I also have an excel spreadsheet that has the names and empty slots for those 9 scores. I have a bunch of formulas that use those 9 scores to calculate other scores. Is it possible to read those 9 scores for each individual name from my database then place them into that specific slot of the spread sheet based on there name? I do not want to write to a new spread sheet but rather input these scores into that spreadsheet that is being used. Thanks in advance!

Danilo Paone · Accepted Answer · 2014-03-23 23:57:24Z

1

In PhpMyAdmin select your database, then export -> CSV or CSV for MS Excel

Take a look at the screenshot:

enter image description here

answered Mar 23, 2014 at 23:57

Danilo Paone

1481 gold badge2 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

chatycat99 Over a year ago

Yes I understand how to export it to a new file. I am wondering if I can export it to a specific spreadsheet I have already made and if I can make this automated

Danilo Paone Over a year ago

With PhpMyAdmin it's not possible. I think you should before export it manually and then import it wherever you want!

chatycat99 Over a year ago

Do you know if this is possible with PHP or would I just be wasting my time?

Collectives™ on Stack Overflow

Export MYSQL phpadmin to Excel

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related