Categories: Wordpress Plugin
WP CSV to Database plugin allows you to insert CSV file content into WordPress database. Useful when you want to bulk upload data from your CSV file (e.g. product details) to the WordPress database (MySQL) in one go.
If you didn’t know what a CSV file is then you can learn more from Wikipedia. You can use Microsoft Excel to enter all your data and then save the file as a CSV file.
Many of my WordPress Shopping Cart users have requested me to add an option so that they can bulk upload their product details into the database from a CSV file (really useful when you have hundreds of products). Hopefully this plugin will satisfy that need and in addition you will be able to use it to bulk upload any data into your WordPress database to save you time and effort.
Installation of the Plugin
- Unzip and Upload the folder ‘wp-csv-to-db’ to the ‘/wp-content/plugins/’ directory
- Activate the plugin through the ‘Plugins’ menu in WordPress
Usage of the Plugin
Access the plugin’s User Interface in the WordPress dashboard under the “Settings” menu after installation and do the following:
- Specify the general options.
- Specify the input file (Upload the CSV file or specify the location of a pre-uploaded CSV file)
- Hit the “Import to DB” button to import the CSV file content into the database table.
Download Latest Version (v1.8)
Download the CSV to DB plugin.
How to Use This Plugin to Bulk Upload WP eStore Products
How to Use This Plugin to Bulk Upload WP eMember members
If the cell values in the CSV file have special characters like apostrophe (‘) or quotes (“) then don’t forget to use a backslash before them (e.g Karen\’s book). You shouldn’t need to do this anymore if you are using v1.5 or above.
The video tutorial on the following page might also be a good resource for importing data into your WordPress database table:
If you have any issues with the plugin please leave a comment below.