How to Import Post Ideas from CSV Spreadsheet in WordPress


Recently, one of our users asked us if there was a way to import post ideas in WordPress from a spreadsheet. We did a quick research, and well of course there is a way. In this article, we will show you how to import post ideas as draft in WordPress.

Many WordPress site owners plan their content strategy in spreadsheets containing post ideas as titles. This is specially common if you’re part of a larger organization or are working with a virtual assistant.

If you plan like we do, then chances are you have quite a few posts in your spreadsheet, and adding them manually will take a lot of time. Well, let’s take a look at how to easily import post ideas from CSV into WordPress.

Video Tutorial

Subscribe to WPBeginner

If you don’t like the video or need more instructions, then continue reading.

First thing you need to do is install and activate the Really Simple CSV Importer plugin. Upon activation, simply go to Tools » Import and click on CSV.

CSV Importer

On the next screen, you will be asked to upload a CSV file you want to import. But before you do that, first you need to format your spreadsheet properly, so that it can be imported.

The really simple CSV importer fetches post information based on columns in your spreadsheet. The first row in your spreadsheet must contain column names recognizable by the plugin. Some of the most commonly used column names are post_title, post_content, post_date, post_author, post_type and post_status. You can find the full list of column names on the plugin’s homepage.

You don’t need to have all the columns, and you don’t even need to have the columns in a particular order. Here is a screenshot of a sample spreadsheet that we will be importing.

A sample spreadsheet

The plugin also comes with its own sample CSV and ODT files, which are located in the plugin’s directory under sample folder. You can open these files in Microsoft Office, Google Docs, or LibreOffice Calc. Alternately, you can also open a CSV file in any plain text editor like Notepad.

The default post type is set to posts, and post status to draft. However, if you would like to change that, then you can do so by defining the post_status column.

Most spreadsheet software allow you to save your spreadsheet in CSV format. While downloading or saving your spreadsheet as CSV, make sure you use commas to separate columns, and make sure text delimiter is set to double quotes.

After you have converted your spreadsheet into CSV, you are now ready to import it into WordPress. Return back to CSV importer and click on choose file button to upload your CSV file. The plugin will then upload it and import posts into WordPress.

CSV Importer progress

That’s all for now, we hope this article helped you import post ideas as draft in WordPress. If you’re part of a larger organization, then we highly recommend you check out Edit Flow to improve your editorial workflow. We have also compiled a list of 21 great plugins to manage a multi-author blog efficiently.

If you liked this article, then please subscribe to our YouTube Channel for WordPress video tutorials. You can also find us on Twitter and Google+.