This evening (CEST), the first code from this year GSoC has been merged to phpMyAdmin trunk. And I think it is really interesting piece of code.
Derek Schaefer has spent his time to improve import abilities of phpMyAdmin. You can now import arbitrary spreadsheet documents and you should be able to get reasonably looking table with all of the data.
And as a side effect, we got better export to various Excel formats (including XLSX).
Thanks Derek, your contributions were really great and it was a pleasure to work with you (especially when compared to responsiveness of other students).