CODEWITHSUNDEEP
phpmysqlexcelphpmyadmin
chatycat99
chatycat99

Reputation: 107

Export MYSQL phpadmin to Excel

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!

Upvotes: 0

Views: 80

Answers (1)

Danilo Paone
Danilo Paone

Reputation: 148

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

Take a look at the screenshot:

enter image description here

Upvotes: 1

Related Questions