WP CSV to Database – Insert CSV file content into WordPress database

Description

WP CSV to Database plugin allows you to insert CSV file content into WordPress database. You can selectively insert data into a particular database table.

You can also export any WordPress database table content to a CSV file using this plugin.

Useful when you want to bulk upload data from your CSV file (example: product details) to the WordPress database in one go.

Bulk data import from CSV (Microsoft Excel) file. Bulk data export from your database to CSV file

For detailed documentation please visit the CSV to DB Plugin page

Usage

Access the plugin’s UI in the WordPres dashboard under the “Settings -> WP CSV/DB” menu after installation. Read the “Guide” tab for instructions.

Installation

  • Go to the Add New plugins screen in your WordPress admin area
  • Click the upload tab
  • Browse for the plugin file (wp-csv-to-db.zip)
  • Click Install Now and then activate the plugin

FAQ

  1. Can this plugin be used to bulk upload product details for the WP eStore plugin? Yes
  2. Can this plugin be used to dump data into any WordPress database table? Yes.

Reviews

Best CSV importer around

This is one of the best CSV importers I've found. I created a couple of new tables for a client and I needed a way to import CSV content into these tables. I tried a number of other components, but they only worked for stock items (posts, pages, comments, etc). This component does that and more. It will import data into your custom tables and it doesn't so cleanly and easily. This has saved me hours of coding and it has a clean, simple interface that will not overburden my clients with jargon. If you're looking to import CSV files regularly or just to populate data from the get go, this is the one you're looking for.

Awesome plugin!

Very good! Works like a charm and saves a lot of time. Thank you for making this awesome plugin!

Not Working with qoutes (Solved)

Current version doesn't support files with escape characters. you can add this features by adding following line in main.php file: $row = array_map(function($v) { return esc_sql($v) ;}, $row) ; Add this just line After this comment: //If. csv column count matches db column count
Read all 7 reviews

Contributors & Developers

“WP CSV to Database – Insert CSV file content into WordPress database” is open source software. The following people have contributed to this plugin.

Contributors

Changelog

2.6

  • Updated the plugin to be compatible with PHP7+

2.5

  • The jquery UI css file is loaded over the same protocol as the site.

2.4

  • Added support for files with escape chars. Thanks to @alexuidian

2.3

  • Updated the code to address the “This is not a valid .csv file extension” error. Thanks to @sirhaver.

2.2

  • Fixed an issue with the export to CSV function.

2.1

  • WordPress 4.1 compatibility

2.0

  • Complete new revamped architecture for this plugin. It is now a lot more user friendly and has more features.

1.8 and before

  • The old versions with old architecture can be downloaded using the following link
    https://downloads.wordpress.org/plugin/wp-csv-to-database.v1.8.zip