firimar

This simple plugin allows you to import any type of data from large CSV files into your wordpress installation.
Plugin reads CSV file and performs import of its records one by one through AJAX requests, so there are no server timeout issues.
You only need to provide PHP function to perform import of CSV field values into post or taxonomy term or whatever you need.
Usage example:
For example, assume we want to import posts from such CSV file: 
 title,text,brand,image 
 “Check this”,”Samsung content”,Samsung,”https://upload.wikimedia.org/wikipedia/commons/thumb/2/24/Samsung_Logo.svg/2000px-Samsung_Logo.svg.png” 
 “Some news”,”News Here are some news”,Philips,”http://www.underconsideration.com/brandnew/archives/philips_2013_logo_detail.png”
Here we have post title, post content, custom field Brand and thumbnail image.
We can use this code in theme’s functions.php file to implement import function:
<pre><code>add_action('lcih_import_csv_row', 'lcih_import_csv_row');
function lcih_import_csv_row($row)
{
 $post_data = array(
 'post_type' => 'post',
 'post_status' => 'publish',
 'post_title' => $row['title'],
 'post_content' => $row['text']
 );
 $post_id = wp_insert_post($post_data);
 if (!$post_id)
 {
 echo "Error inserting post.";
 return;
 }

 update_post_meta($post_id, 'brand', $row['brand']);

 if ($row['image'])
 LargeCSVImportHandlerPlugin::download_post_thumbnail($post_id, $row['image']);

 echo "Created post ".$post_id;
}
</code></pre>
After that we can go to plugin admin page, select CSV file to upload and click “Start import” button. Import process will begin.

Large CSV Import Handler

After trying almost all major CSV plugins, this is the one that works perfectly for large files. I have a file of 35MB with 83000 posts and was unable to import them but this plugin did it with ease. No server time issues, simple to use. Recommended!

Awesome Work, Great Plugin

Provides ability to import any type of data from large CSV files into Wordpress

sonalsinha21

Live demo content can be imported quickly in just one click including all widgets and settings. To establish a new website, this plugin provides a a basic layout plus it speed up the process of development.
In APPEARANCE > SKT Import Content, it will built up the page.
The three files upload inputs will be presented if you are using the theme that do not have any import filed predefined.
Demo content XML file needs to be uploaded as first file is important, for the real demo import.
The second one is not that much important. however for widgets import you will be asked for a WIE or JSON file. With the help of this you can create a file <a href="https://wordpress.org/plugins/widget-importer-exporter/" rel="ugc">Widget Importer & Exporter</a> plugin.
The third option is also not mandatory. thus the customizer settings will be imported, select the DAT file that can be easily generated from <a href="https://wordpress.org/plugins/customizer-export-import/" rel="ugc">Customizer Export/Import</a> plugin (from the same theme if and only if the export file was created than only the customizer settings will be imported.).

SKT Themes Demo Import

Live demo content can be imported quickly in just one click including all widgets and settings.

Large CSV Import Handler vs SKT Themes Demo Import