Return to Revisions

There is some way to import excel to WordPress database. but I have an easy solution to import this file.

1. Go to convertcsv.com and convert your excel file to JSON.
2. Create the below files and folders:

Folder: wp-content/plugins/import/

File: wp-content/plugins/import/import.json

File: wp-content/plugins/import/import.php

3. Then save JSON file to import.json

4. Put below code in import.php

   ' . print_r( $data, 1 ) . ''; // Each data foreach ( $data as $item ) { // Create post object $args = array( 'post_title' => $item['title'], // your column 'post_content' => $item['content'], // your column 'post_status' => 'publish', 'post_type' => 'post', 'post_author' => 1 ); // Insert the post into the database //$post_id = wp_insert_post( $args ); } } exit; }

5. Go to Plugins and enable Import plugin. then run this request in your WordPress:

   http://yoursite.com/wp-admin/?do=import

Don't forgot, You should get valid data from your json. You can see this data through print_r befor each data.