How to Bulk Publish Posts Using a CSV File

You are creating a website or blog using WordPress. You may be interested in making your job of publishing posts easy by bulk publishing because creating every post separately can be a very hectic job. In this article, we will discuss how you can bulk, publish posts in WordPress. We will need to install a plugin in our WordPress.

Bulk Publish Posts Using a CSV File

During the process, we will see which plugin we are using. We will need to create a CSV file for our posts. Start MS-Excel from Start Menu

BPW1 1

Create the file using the basic headers. For Example Title, Description, etc. This will help you in further steps while importing the file in WordPress.

Here we are writing the Status as Draft, this will import the post but will not publish. If you want to publish your posts directly, you can write the Status as Published.

BPW2 1

After creating all your posts in the Excel file, just save the file at a convenient location. Make sure you save the file as the “CSV (Comma Delimited)” format.

If you save your file in any other format, it will not be imported.

BPW3 1

Now login to your WordPress website Dashboard

BPW4 1

In the dashboard move your mouse to the Plugins link

BPW5 1

A submenu will appear, click on the Add New link

BPW6 1

In the Plugins search bar type in “Wp Ultimate CSV Importer”

BPW7 1

In the search results, you will find this Plugin as shown in the image. Click on Install now button.

BPW8 1

Installing will start

BPW9 1

You can click on the “More Details” link to see more details about the plugin

BPW10 1

It is the free version with limited functionality; you can pay and upgrade to the Pro version to use its full features.

BPW11

Close the Details page, and click on the Activate button to activate the plugin in your WordPress dashboard.

BPW12

After activating, the plugin will appear in the left pane of your WordPress dashboard. Click on the Ultimate CSV Importer Free icon to start the plugin.

BPW13

As the Plugin starts, click on the Browse button

BPW14

Locate the CSV file that we created earlier and import it

BPW15

The file will upload into the Plugin. Select the New Item option as we are creating a new post. You can import each record in the file as Page or Post. Select the Posts option and click on the Continue button.

BPW16

The next step is the Mapping step. Here you assign your headers from the file with the WP Fields accordingly. For Example, Tile will come against the Title header from the CSV file.

BPW17

Map as many headers as possible. Here you can see that you can create many headers in your CSV file and map them here. We created some basic headers as an example.

BPW18

As you, continue to the next step. It is a media handling page. It is mostly available for the Pro version of the plugin. We continue to the next step.

BPW19

Next is the import configuration section. Select your options of choice, (The schedule option is for Pro version), and start Import.

BPW20

Import Process will start and take a few seconds.

BPW21

After the import is completed. Click the Close button.

BPW22

Click on the Posts button in the Dashboard to view your posts

BPW23

All your posts are imported in WordPress. You can also preview the post on your website.

Leave a Reply