FirstElement

Daijiro Miyazawa

<p>FE CSV Import & Export helps you import and export WordPress content as CSV from the admin area.<br />
It is designed for site owners who want a stress-free CSV workflow for daily operations and for developers who need extensibility through WordPress hooks.</p>
<h4>Main features:</h4>
<ul>
<li>Import and export WordPress content as CSV</li>
<li>Fast export of approximately 10,000 posts in about 15 seconds (depending on site configuration and server environment)</li>
<li>Support for posts, pages, and custom post types</li>
<li>Option to include or exclude custom taxonomies</li>
<li>Support for term ID or term name input/output</li>
<li>Proper handling of hierarchical terms</li>
<li>Import of unregistered terms (currently uses term name as slug)</li>
<li>Option to include or exclude custom fields</li>
<li>Option to include or exclude private meta</li>
<li>New custom field items can be registered with the “cf_” prefix</li>
<li>Option to target published status or all post statuses</li>
<li>Option to export only frequently edited “basic fields” or “all fields”</li>
<li>Option to update (overwrite) existing posts with the same ID or create new ones</li>
<li>Dry run functionality</li>
<li>Batch processing for large CSV files</li>
<li>Real-time progress display in the admin interface</li>
<li>Option to enable/disable logging (speed priority)</li>
<li>Extensibility through filter/action hooks for custom workflows</li>
</ul>
<h4>FE CSV Import & Export is suitable for tasks such as:</h4>
<ul>
<li>Bulk updating existing posts from spreadsheet data</li>
<li>Exporting content for reporting or external processing</li>
<li>Importing structured content into custom post types</li>
<li>Migrating content between sites</li>
</ul>
<p>For large imports, this plugin processes data in batches to reduce memory usage and improve reliability. It automatically adjusts batch size based on server settings (max_execution_time, memory_limit) to efficiently process large datasets without timeout.</p>
<p>Using filter hooks, you can output only necessary columns for external editing (e.g., title and content only) or add custom processing when exporting ACF (Advanced Custom Fields) related custom fields.</p>
<h4>Note:</h4>
<p>For custom field output, by default, the plugin picks up fields associated with the first post (first row). If the first post does not contain all necessary custom fields, those fields will be ignored. To avoid this, consider these two approaches:</p>
<p><strong>Pattern A</strong><br />
Create a dummy post immediately before export and fill it with dummy values for all necessary custom field items (this ensures all necessary custom field items are expanded as CSV columns)</p>
<p><strong>Pattern B</strong><br />
Use a filter hook to specify a sample post ID for extracting custom field items (by specifying a post ID that contains all custom field items, you ensure all necessary custom field items are expanded as CSV columns)</p>
<h4>Documentation and support resources:</h4>
<ul>
<li><a href="https://firstelementjp.github.io/fe-csv-import-export/" rel="nofollow ugc">Documentation</a></li>
<li><a href="https://github.com/firstelementjp/fe-csv-import-export" rel="nofollow ugc">GitHub Repository</a></li>
<li><a href="https://github.com/firstelementjp/fe-csv-import-export/issues" rel="nofollow ugc">Issue Tracker</a></li>
</ul>
<h4>Pro Version:</h4>
<p>This plugin works completely on its own with the free version and provides sufficient functionality, but when used with the Pro version, you can access these convenient features:</p>
<ul>
<li><strong>ACF Integration</strong> – Import and export ACF data while preserving field formatting. Export taxonomy values as readable names and handle multi-value fields with pipe-separated values. Support major ACF field types including Taxonomy, User, File, Relationship, Repeater, and Flexible Content fields</li>
<li><strong>Direct SQL Export Mode</strong> – Customize export queries directly for advanced workflows and integrations</li>
<li><strong>UpdraftPlus Database Backup</strong> – When used with the backup plugin ‘UpdraftPlus’, automatic SQL backup is executed during import and import begins after completion. If problems are discovered after import, you can immediately restore from backup</li>
<li><strong>Enhanced Security</strong> – Import/export execution permissions can be assigned to editors in addition to administrators. You can set a shared password for import/export execution. You can require users to enter their login password for import/export execution</li>
<li><strong>Dedicated Support</strong> – Priority customer support from the development team</li>
<li><strong>Automatic Updates</strong> – Seamless updates from our update server</li>
</ul>
<p><a href="https://www.firstelement.co.jp/en/products/fe-csv-import-export-plugin/" rel="nofollow ugc">Pro Version</a></p>
<h3>External Services</h3>
<p>FE CSV Import & Export Pro uses an external license API service for license validation and activation. This service is used solely for:</p>
<ul>
<li>License key validation</li>
<li>License activation and deactivation</li>
<li>License status checks</li>
</ul>
<p><a href="https://www.firstelement.co.jp/en/legal/privacy-policy/privacy-statement-eu/" rel="nofollow ugc">Privacy Policy</a><br />
<a href="https://www.firstelement.co.jp/en/legal/terms-of-use/fe-csv-import-export-pro/" rel="nofollow ugc">Terms of Service</a></p>
<p>The license API service is operated by FirstElement K.K. and is used exclusively for license management purposes. No content data is transmitted to this service.</p>


FE CSV Import & Export

Import and export WordPress posts, custom post types, taxonomies, and custom fields as CSV with batch processing.

Takuro Hishikawa

<p>Alternative CSV Importer plugin. Simple and powerful, best for geeks.</p>
<ul>
<li>Category support</li>
<li>Tag support</li>
<li>Custom field support</li>
<li><a href="https://wordpress.org/plugins/smart-custom-fields/" rel="ugc">Smart Custom Fields</a> support</li>
<li><a href="http://customfieldsuite.com/" rel="nofollow ugc">Custom Field Suite</a> support</li>
<li><a href="http://www.advancedcustomfields.com/" rel="nofollow ugc">Advanced Custom Fields</a> support</li>
<li>Custom Taxonomy support</li>
<li>Custom Post Type support</li>
<li>Filter hook for dry-run-testing</li>
<li>Filter hooks for customize csv data before importing to database</li>
<li>Action hook for update post data after importing to database</li>
</ul>
<p>You can get example CSV files in <code>/wp-content/plugins/really-simple-csv-importer/sample</code> directory.</p>
<h4>Available column names and values:</h4>
<ul>
<li><code>ID</code> or <code>post_id</code>: (int) post id.<br />
This value is not required. The post ID is already exists in your blog, importer will update that post data. If the ID is not exists, importer will trying to create a new post with suggested ID.</li>
<li><code>post_author</code>: (login or ID) The user name or user ID number of the author.</li>
<li><code>post_date</code>: (string) The time of publish date.</li>
<li><code>post_content</code>: (string) The full text of the post.</li>
<li><code>post_title</code>: (string) The title of the post.</li>
<li><code>post_excerpt</code>: (string) For all your post excerpt needs.</li>
<li><code>post_status</code>: (‘draft’ or ‘publish’ or ‘pending’ or ‘future’ or ‘private’ or custom registered status) The status of the post. ‘draft’ is default.</li>
<li><code>post_password</code>: (string) The password to protect the post. The password is limited to 20 characters.</li>
<li><code>post_name</code>: (string) The slug of the post.</li>
<li><code>post_parent</code>: (int) The post parent id. Used for page or hierarchical post type.</li>
<li><code>menu_order</code>: (int)</li>
<li><code>post_type</code>: (‘post’ or ‘page’ or any other post type name) <em>(required)</em> The post type slug, not labels.</li>
<li><code>post_thumbnail</code>: (string) The uri or path of the post thumbnail.<br />
E.g. http://example.com/example.jpg or /path/to/example.jpg</li>
<li><code>post_category</code>: (string, comma separated) slug of post categories</li>
<li><code>post_tags</code>: (string, comma separated) name of post tags</li>
<li><code>tax_{taxonomy}</code>: (string, comma separated) Any field prefixed with <code>tax_</code> will be used as a custom taxonomy. Taxonomy must already exist. Entries are names or slugs of terms.</li>
<li><code>{custom_field_key}</code>: (string) Any other column labels used as custom field</li>
<li><code>cfs_{field_name}</code>: (string) If you would like to import data to custom fields set by Custom Field Suite, please add prefix <code>cfs_</code> to column header name.</li>
<li><code>scf_{field_name}</code>: (string) If you would like to import data to custom fields set by Smart Custom Fields, please add prefix <code>scf_</code> to column header name.</li>
<li><code>comment_status</code>: (‘closed’ or ‘open’) Default is the option ‘default_comment_status’, or ‘closed’.</li>
</ul>
<p>Note: Empty cells in the csv file means “keep it”, not “delete it”.<br />
Note: To set the page template of a page, use custom field key of <code>_wp_page_template</code>.<br />
Note: If providing a post_status of ‘future’ you must specify the post_date in order for WordPress to know when to publish your post.<br />
Note: If the post_type value is <code>attachment</code>, you can use <code>post_thumbnail</code> field to define media URL or path.</p>
<h4>Advanced Custom Fields plugin integrate</h4>
<p>If advanced custom field key is exists, importer will trying to use <a href="http://www.advancedcustomfields.com/resources/functions/update_field/" rel="nofollow ugc">update_field</a> function instead of built-in add_post_meta function.<br />
How to find advanced custom field key: <a href="http://www.advancedcustomfields.com/resources/functions/update_field/#finding-the%20field%20key" rel="nofollow ugc">Finding the field key</a></p>
<h4>Official public repository</h4>
<p>Add star and read future issues about rs-csv-importer on <a href="https://github.com/hissy/rs-csv-importer" rel="nofollow ugc">GitHub</a>!</p>
<h4>Thanks</h4>
<p>Cover banner designed by @<a href="http://uwasora.com/" rel="nofollow ugc">luchino__</a></p>
<h3>How to debug import data</h3>
<p><em>Really Simple CSV Importer Debugger add-on</em> enables you to dry-run-testing and show more detailed post, meta, taxonomy data of each csv row.<br />
Download from <a href="https://gist.github.com/hissy/7175656" rel="nofollow ugc">gist</a>.</p>
<h3>How to customize import post data</h3>
<p>There are three filters available in the importer.</p>
<h4>really_simple_csv_importer_save_post</h4>
<p>This filter is applied to post data.</p>
<p>Parameters:</p>
<ul>
<li><code>$post</code> – (array)(required) post data</li>
<li><code>$is_update</code> – (bool) update existing post data, or insert new post data</li>
</ul>
<p>Example:</p>
<pre><code>function really_simple_csv_importer_save_post_filter( $post, $is_update ) {

    // remove specific tag from import data
    if (isset($post['post_tags'])) {
        $_tags = array();
        foreach ($post['post_tags'] as $tag) {
            if ($tag != 'Apple') {
                $_tags[] = $tag;
            }
        }
        $post['post_tags'] = $_tags;
    }

    return $post;
}
add_filter( 'really_simple_csv_importer_save_post', 'really_simple_csv_importer_save_post_filter', 10, 2 );
</code></pre>
<h4>really_simple_csv_importer_save_meta</h4>
<p>This filter is applied to post meta data.</p>
<p>Parameters:</p>
<ul>
<li><code>$meta</code> – (array)(required) post meta data</li>
<li><code>$post</code> – (array) post data</li>
<li><code>$is_update</code> – (bool)</li>
</ul>
<p>Example:</p>
<pre><code>function really_simple_csv_importer_save_meta_filter( $meta, $post, $is_update ) {

    // serialize metadata
    $meta_array = array();
    if (isset($meta['meta_key_1'])) $meta_array[] = $meta['meta_key_1'];
    if (isset($meta['meta_key_2'])) $meta_array[] = $meta['meta_key_2'];
    $meta = array( 'meta_key' => $meta_array );

    return $meta;
}
add_filter( 'really_simple_csv_importer_save_meta', 'really_simple_csv_importer_save_meta_filter', 10, 3 );
</code></pre>
<h4>really_simple_csv_importer_save_tax</h4>
<p>This filter is applied to post taxonomy data (categories and tags are not included, these are post data).</p>
<p>Parameters:</p>
<ul>
<li><code>$tax</code> – (array)(required) post taxonomy data</li>
<li><code>$post</code> – (array) post data</li>
<li><code>$is_update</code> – (bool)</li>
</ul>
<p>Example:</p>
<pre><code>function really_simple_csv_importer_save_tax_filter( $tax, $post, $is_update ) {

    // Fix misspelled taxonomy
    if (isset($tax['actors'])) {
        $_actors = array();
        foreach ($tax['actors'] as $actor) {
            if ($actor == 'Johnny Dep') {
                $actor = 'Johnny Depp';
            }
            $_actors[] = $actor;
        }
        $tax['actors'] = $_actors;
    }

    return $tax;
}
add_filter( 'really_simple_csv_importer_save_tax', 'really_simple_csv_importer_save_tax_filter', 10, 3 );
</code></pre>
<h4>really_simple_csv_importer_save_thumbnail</h4>
<p>This filter is applied to thumbnail data.</p>
<p>Parameters:</p>
<ul>
<li><code>$post_thumbnail</code> – (string)(required) the thumbnail file path or distant URL</li>
<li><code>$post</code> – (array) post data</li>
<li><code>$is_update</code> – (bool)</li>
</ul>
<p>Example:</p>
<pre><code>function really_simple_csv_importer_save_thumbnail_filter( $post_thumbnail, $post, $is_update ) {

    // Import a local file from an FTP directory
    if (!empty($post_thumbnail) && file_exists($post_thumbnail)) {
        $upload_dir   = wp_upload_dir();
        $target_path  = $upload_dir['path'] . DIRECTORY_SEPARATOR . basename($post_thumbnail);
        if (copy($post_thumbnail, $target_path)) {
            $post_thumbnail = $target_path;
        }
    }

    return $post_thumbnail;
}
add_filter( 'really_simple_csv_importer_save_thumbnail', 'really_simple_csv_importer_save_thumbnail_filter', 10, 3 );
</code></pre>
<h3>How to customize the post data after importing to database</h3>
<h4>really_simple_csv_importer_post_saved</h4>
<p>This action provides availability to run some tasks after importing.</p>
<p>Example: Download image from remote url to custom field (Download from <a href="https://gist.github.com/hissy/0973a6a9977129a6ebd0" rel="nofollow ugc">gist</a>)</p>
<h3>How to customize the importing process entirely</h3>
<h4>really_simple_csv_importer_class</h4>
<p>This filter provides availability to completely replace the <code>RS_CSV_Importer#save_post</code> method.</p>
<p>Example: Update row based on a custom field ID/key match (Download from <a href="https://gist.github.com/hissy/199ad9be855ec9be1e54" rel="nofollow ugc">gist</a>)</p>


Really Simple CSV Importer

Perfect. Worked at first try using CPT and Advanced Custom Fields. Thanks, Takuro, you rock!

The force is with this one

This is a good plugin save me hours in insert Posts, and ACF fields

Amazing plugin!! to upload acf contents

Alternative CSV Importer plugin. Simple and powerful, best for geeks.

FE CSV Import & Export vs Really Simple CSV Importer