CODEWITHSUNDEEP
javascriptphpwordpressimport-from-excel
Asamardzic
Asamardzic

Reputation: 13

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.

Upvotes: 0

Views: 274

Answers (2)

Matthew Goheen
Matthew Goheen

Reputation: 860

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.

Upvotes: 1

Slartibartfass2
Slartibartfass2

Reputation: 46

You can save the Excel table as csv file. You have to choose the csv file where they use semicolons as separator. If you trust the Google Translator it's called "CSV (separator separated)". It will sperarate the columns with semicolons.

Then you go to phpmyadmin, select your table and click on import. Select your file, and select "CSV" under "Format".

Then you press "OK" and your csv file should be converted to a table in your database.

Upvotes: 0

Related Questions