Search code examples
javascriptphpwordpressimport-from-excel

Uploading Excel table into a Wordpress phpmyadmin database


Is it possible to upload a user frontend uploaded table and send it to phpmyadmin database and then display it on the website? I've tried searching everywhere but there simply isn't anything I've found on that matter.

All Wordpress plugins I checked out are for me to upload them instead of the users on the frontend.


Solution

  • Build a file upload form on your site and allow CSV files. In the PHP code that will handle the uploaded file, you write the proper code to import CSVs into your database. This can be risky, consider security while processing the file. The user will have to know to make a CSV from excel.