Jason Judge

<p>This WordPress plugin imports posts from CSV (Comma Separated Value) files into your<br />
WordPress blog. It can prove extremely useful when you want to import a bunch<br />
of posts from an Excel document or the like – simply export your document into<br />
a CSV file and the plugin will take care of the rest.</p>
<p>https://wordpress.org/plugins/csv-importer-improved/</p>
<h4>Features</h4>
<ul>
<li>Imports post title, body, excerpt, tags, date, categories etc.</li>
<li>Supports custom fields, custom taxonomies and comments</li>
<li>Deals with Word-style quotes and other non-standard characters using<br />
WordPress’ built-in mechanism (same one that normalizes your input when you<br />
write your posts)</li>
<li>Columns in the CSV file can be in any order, provided that they have correct<br />
headings</li>
<li>Multi-language support</li>
</ul>
<p>This plugin is forked from https://wordpress.org/plugins/csv-importer/ by dvkob<br />
in order to keep up with changes to the core WordPress.</p>
<p>This importer writes directly to the database. It does not go through the internal<br />
WordPress objects for creating posts etc. That may be an advantage to you (it will<br />
be faster for large imports) but do be aware of any data integrity issues that may arrise.</p>
<p>Only UTF-8 encoding is supported, both with and without Byte Order Marks (BOM).</p>
<p>The development repository for this plugin can be found here:</p>
<p>https://github.com/academe/csv-importer-improved</p>
<p>Please feel free to raise issues there, and submit pull requests, as well as through<br />
the normal WordPress channels.</p>
<h3>Usage</h3>
<p>Click on the CSV Importer link on your WordPress admin page, choose the<br />
file you would like to import and click Import. The <code>examples</code> directory<br />
inside the plugin’s directory contains several files that demonstrate<br />
how to use the plugin. The best way to get started is to import one of<br />
these files and look at the results.</p>
<p>CSV is a tabular format that consists of rows and columns. Each row in<br />
a CSV file represents a post; each column identifies a piece of information<br />
that comprises a post.</p>
<p>You can create new posts, or update existing posts by supplying the csv_post_id<br />
field pointing to an existing post. When updating, all field names you provide<br />
in the CSV file will be updated – even if blank – but fields you don’t list at<br />
the head of the CSV file will be left intact.</p>
<h4>Basic post information</h4>
<ul>
<li><code>csv_post_id</code> – optional, used to update an existing post.</li>
<li><code>csv_post_title</code> – title of the post</li>
<li><code>csv_post_post</code> – body of the post</li>
<li><code>csv_post_type</code> – <code>post</code>, <code>page</code> or a custom post type.<br />
From 0.3.2, <code>csv_post_type</code> column supports custom post types.<br />
Refer to the WordPress<br />
<a href="https://codex.wordpress.org/Custom_Post_Types" rel="nofollow ugc">documentation on custom post types</a> for more info<br />
on how to set up custom post types.</li>
<li><code>csv_post_excerpt</code> – post excerpt</li>
<li><code>csv_post_categories</code> – a comma separated list of category names or ids.<br />
The list must be enclosed in quotes, e.g. “EC > UK, Island”.<br />
If a chain of subcategories does not exist, e.g. <code>Animalia > Chordata > Mammalia</code><br />
then they will all be created and the post assigned to the end of the chain.<br />
The parent category can also be defined using its id, e.g.<br />
    42 > Primates > Callitrichidae, where <code>42</code> is an<br />
existing category id.</li>
<li><code>csv_post_tags</code> – a “quoted” comma separated list of tags.</li>
<li><code>csv_post_date</code> – most standard formats are supported.<br />
For example, <code>now</code>, <code>11/16/2009 0:00</code>, <code>1999-12-31 23:55:00</code>, <code>+1 week</code>,<br />
    next Thursday, <code>last year</code> are all valid. For technical<br />
details, consult PHP’s <code>strtotime()</code> function <a href="http://php.net/manual/en/function.strtotime.php" rel="nofollow ugc">documentation</a>.</li>
</ul>
<h4>Custom fields</h4>
<p>Any column that doesn’t start with <code>csv_</code> is considered to be a custom field<br />
name. The data in that column will be imported as the custom fields value.</p>
<p>All custom fields must be unique. Multiple fields with the same name will be<br />
updated to the same value if updating an existing post.<br />
Prior to version 0.6.0 loading the same field name multiple times to an existing<br />
post would create multiple custom fields.</p>
<h4>General remarks</h4>
<ul>
<li>WordPress pages <a href="https://codex.wordpress.org/Pages" rel="nofollow ugc">don’t have categories or tags</a>.</li>
<li>Most columns are optional. Either <code>csv_post_title</code>, <code>csv_post_post</code> or<br />
    csv_post_excerpt are sufficient to create a post. If all of these<br />
columns are empty in a row, the plugin will skip that row.</li>
<li>The plugin will attempt to reuse existing categories or tags; if an<br />
existing category or tag cannot be found, the plugin will create it.</li>
<li>To specify a category that has a greater than sign (>) in the name, use<br />
the HTML entity <code>&gt;</code></li>
</ul>
<h4>Advanced usage</h4>
<ul>
<li><code>csv_post_author</code> – numeric user id or login name. If not specified or<br />
user does not exist, the plugin will assign the posts to the user<br />
performing the import.</li>
<li><code>csv_post_slug</code> – post slug used in permalinks.</li>
<li><code>csv_post_parent</code> – post parent id.</li>
</ul>
<h3>Custom taxonomies</h3>
<p><strong>New in version 0.3.0</strong></p>
<p>Once custom taxonomies are set up in your theme’s functions.php file or<br />
by using a 3rd party plugin, <code>csv_ctax_(taxonomy name)</code> columns can be<br />
used to assign imported data to the taxonomies.</p>
<p><strong>Non-hierarchical taxonomies</strong></p>
<p>The syntax for non-hierarchical taxonomies is straightforward and is essentially<br />
the same as the <code>csv_post_tags</code> syntax.</p>
<p><strong>Hierarchical taxonomies</strong></p>
<p>The syntax for hierarchical taxonomies is more complicated. Each hierarchical<br />
taxonomy field is a tiny two-column CSV file, where <em>the order of columns<br />
matters</em>. The first column contains the name of the parent term and the second<br />
column contains the name of the child term. Top level terms have to be preceded<br />
either by an empty string or a 0 (zero).</p>
<p>Sample <code>examples/custom-taxonomies.csv</code> file included with the plugin<br />
illustrates custom taxonomy support. To see how it works, make sure to set up<br />
custom taxonomies from <code>functions.inc.php</code>.</p>
<p>Make sure that the quotation marks used as text delimiters in <code>csv_ctax_</code><br />
columns are regular ASCII double quotes, not typographical quotes like “<br />
(U+201C) and ” (U+201D).</p>
<h3>Comments</h3>
<p><strong>New in version 0.3.1</strong></p>
<p>An example file with comments is included in the <code>examples</code> directory.<br />
In short, comments can be imported along with posts by specifying columns<br />
such as <code>csv_comment_*_author</code>, <code>csv_comment_*_content</code> etc, where * is<br />
a comment ID number. This ID doesn’t go into WordPress. It is only there<br />
to have the connection information in the CSV file.</p>
<h3>Credits</h3>
<p>This plugin uses <a href="http://code.google.com/p/php-csv-parser/" rel="nofollow ugc">php-csv-parser</a> by Kazuyoshi Tlacaelel.<br />
It was inspired by JayBlogger’s <a href="http://www.jayblogger.com/the-birth-of-my-first-plugin-import-csv/" rel="nofollow ugc">CSV Import</a> plugin.</p>
<p>Contributors:</p>
<ul>
<li>Kevin Hagerty (post_author support)</li>
<li>Edir Pedro (root category option and tableless HTML markup)</li>
<li>Frank Loeffler (comments support)</li>
<li>Micah Gates (subcategory syntax)</li>
<li>David Hollander (deprecation warnings, linebreak handling)</li>
</ul>


CSV Importer Improved

Import posts from CSV files into WordPress.

Pratik Sinha

Shivam Kumar

<p>Smart Spam Cleaner provides an efficient way to remove spam users and posts from your WordPress site. It uses background processing via WordPress cron jobs to handle large datasets without impacting your site’s performance.</p>
<h4>Key Features</h4>
<ul>
<li><strong>Dynamic Filtering</strong> – Configure your own spam keywords and email domains</li>
<li><strong>Advanced Conditions</strong> – Use AND/OR logic to combine keyword and domain filters</li>
<li><strong>Include/Exclude Domains</strong> – Specify which email domains to target or protect</li>
<li><strong>Flexible Post Handling</strong> – Choose between moving posts to trash or permanent deletion</li>
<li><strong>Background Processing</strong> – Uses WordPress cron jobs for non-blocking cleanup operations</li>
<li><strong>Batch Processing</strong> – Processes users and posts in small batches to avoid server overload</li>
<li><strong>Smart Detection</strong> – Identifies spam users based on customizable patterns</li>
<li><strong>Detailed Logging</strong> – Comprehensive logging of all cleanup activities</li>
<li><strong>Modern UI</strong> – Beautiful, responsive admin interface with progress tracking</li>
<li><strong>Security</strong> – Built-in security measures including nonce verification and capability checks</li>
<li><strong>Configurable</strong> – Customizable batch sizes and spam keywords</li>
</ul>
<h4>What Gets Deleted</h4>
<p><strong>Users:</strong><br />
The plugin uses your configured filters to determine which users to delete:</p>
<ul>
<li>Keyword Matching – Users with spam keywords in email, username, or display name</li>
<li>Domain Filtering – Users with email domains in your include list (or all domains except exclude list)</li>
<li>Condition Logic:
<ul>
<li>OR: Delete if user matches ANY keyword OR domain filter</li>
<li>AND: Delete if user matches ALL keyword AND domain filters</li>
</ul>
</li>
<li>Only affects users with the ‘subscriber’ role</li>
</ul>
<p><strong>Posts:</strong></p>
<ul>
<li>Published posts containing spam keywords in the title or content</li>
<li>Uses your configured post keywords list</li>
<li>Deletion Mode:
<ul>
<li>Move to Trash: Posts are moved to WordPress trash (recoverable)</li>
<li>Permanent Delete: Posts are permanently deleted (irreversible)</li>
</ul>
</li>
</ul>
<h4>Use Cases</h4>
<ul>
<li>Clean up spam user registrations</li>
<li>Remove bot-generated users</li>
<li>Delete users from specific spam domains</li>
<li>Clean up casino/gambling spam posts</li>
<li>Bulk delete spam comments authors</li>
<li>Protect legitimate users while removing spam</li>
</ul>
<h4>Safety Features</h4>
<ul>
<li>Only processes users with ‘subscriber’ role</li>
<li>Requires administrator privileges to run</li>
<li>Includes confirmation dialogs</li>
<li>Provides detailed logging for transparency</li>
<li>Always backup your database before running cleanup operations</li>
</ul>
<h3>Configuration</h3>
<h4>Default Settings</h4>
<ul>
<li><strong>Batch Size</strong> – 500 items per batch</li>
<li><strong>User Keywords</strong> – btc, binance, crypto, telegram, usd, tinkoff, money, trading, wallet, forex, meta, xrp, airdrop, bam, bet, eur, rub, invest, usdt, euro</li>
<li><strong>User Domains</strong>:
<ul>
<li>Include: (empty – all domains)</li>
<li>Exclude: gmail.com</li>
</ul>
</li>
<li><strong>User Condition</strong> – OR</li>
<li><strong>Post Keywords</strong> – casino, gambling, slots, bet, poker, blackjack, win money, jackpot, spin, roulette, wager, baccarat</li>
<li><strong>Post Deletion Mode</strong> – Move to Trash (recoverable)</li>
</ul>
<h4>Customization</h4>
<p>You can modify the default settings through the admin interface or by adding the following to your <code>wp-config.php</code> file:</p>
<pre><code>// Custom batch size
define('WWSSC_BATCH_SIZE', 1000);
</code></pre>
<h3>Support</h3>
<p>For support, feature requests, or bug reports, please visit our <a href="https://wizzyweb.com/support" rel="nofollow ugc">support page</a>.</p>
<h3>Privacy</h3>
<p>This plugin does not collect, store, or transmit any user data outside of your WordPress installation. All operations are performed locally on your server.</p>
<h3>Requirements</h3>
<ul>
<li>WordPress 5.0 or higher</li>
<li>PHP 7.4 or higher</li>
<li>Administrator privileges</li>
</ul>
<h3>Credits</h3>
<p>Developed by <a href="https://wizzyweb.com" rel="nofollow ugc">WizzyWeb Private Limited</a></p>
<h3>Important</h3>
<p><strong>Always backup your database before running any cleanup operations. This plugin performs destructive operations that cannot be undone.</strong></p>


Smart Spam Cleaner

Remove spam users and posts using background processing with dynamic filters.

CSV Importer Improved vs Smart Spam Cleaner