WPBeginner

Beginner's Guide for WordPress

  • Blog
    • Beginners Guide
    • News
    • Opinion
    • Showcase
    • Themes
    • Tutorials
    • WordPress Plugins
  • Start Here
    • How to Start a Blog
    • Create a Website
    • Start an Online Store
    • Best Website Builder
    • Email Marketing
    • WordPress Hosting
    • Business Name Ideas
  • Deals
    • Bluehost Coupon
    • SiteGround Coupon
    • WP Engine Coupon
    • HostGator Coupon
    • Domain.com Coupon
    • Constant Contact
    • View All Deals »
  • Glossary
  • Videos
  • Products
X
☰
Beginner's Guide for WordPress / Start your WordPress Blog in minutes
Choosing the Best
WordPress Hosting
How to Easily
Install WordPress
Recommended
WordPress Plugins
View all Guides

WPBeginner» Blog» Plugins» How to Import Post Ideas from CSV Spreadsheet in WordPress

How to Import Post Ideas from CSV Spreadsheet in WordPress

Last updated on December 30th, 2014 by Editorial Staff
54 Shares
Share
Tweet
Share
Pin
Free WordPress Video Tutorials on YouTube by WPBeginner
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+.

54 Shares
Share
Tweet
Share
Pin
Popular on WPBeginner Right Now!
  • How to Start Your Own Podcast (Step by Step)

    How to Start Your Own Podcast (Step by Step)

  • Revealed: Why Building an Email List is so Important Today (6 Reasons)

    Revealed: Why Building an Email List is so Important Today (6 Reasons)

  • Checklist

    Checklist: 15 Things You MUST DO Before Changing WordPress Themes

  • Google Analytics in WordPress

    How to Install Google Analytics in WordPress for Beginners

About the Editorial Staff

Editorial Staff at WPBeginner is a team of WordPress experts led by Syed Balkhi. Trusted by over 1.3 million readers worldwide.

The Ultimate WordPress Toolkit

4 Comments

Leave a Reply
  1. Chris Daly says:
    Jul 4, 2017 at 12:21 am

    Really Simple CSB has not been updated in over 3 years. It’s not deprecated but it is not compatible with any current version of WordPress. I attempted to get it to work in WP 4.8 and it said it imported the posts but I could not find them in the wp_post table.

    Reply
  2. Rob Braddock says:
    Jul 8, 2016 at 2:22 pm

    Do you know if there is any way to schedule the publish date of posts through the CSV import? I know there are plugins to set up a routine schedule for publishing, but I can’t find an easy way to bulk edit the individual publish date for individual posts

    Reply
    • Mia says:
      Oct 3, 2017 at 3:10 am

      Rob,
      You can use Import/Update tool like WP Ultimate CSV Importer. It helps you schedule your future posts to be published in a routine basis. At the same time, you can also update the previously published data by updating your existing Post. You can update the published date either with Post ID, Title or slug.

      Reply
  3. Heidi Pungartnik says:
    Apr 24, 2016 at 12:07 pm

    Great tip, very helpful, especially for large imports! Thanks

    Reply

Leave a Reply Cancel reply

Thanks for choosing to leave a comment. Please keep in mind that all comments are moderated according to our comment policy, and your email address will NOT be published. Please Do NOT use keywords in the name field. Let's have a personal and meaningful conversation.

Over 1,320,000+ Readers

Get fresh content from WPBeginner

Featured WordPress Plugin
WP Mail SMTP logo
WP Mail SMTP
Fix WordPress email delivery issues. #1 SMTP plugin. Learn More »
How to Start a Blog How to Start a Blog
I need help with ...
Starting a
Blog
WordPress
Performance
WordPress
Security
WordPress
SEO
WordPress
Errors
Building an
Online Store
Useful WordPress Guides
    • 7 Best WordPress Backup Plugins Compared (Pros and Cons)
    • How to Fix the Error Establishing a Database Connection in WordPress
    • Why You Need a CDN for your WordPress Blog? [Infographic]
    • 30 Legit Ways to Make Money Online Blogging with WordPress
    • Self Hosted WordPress.org vs. Free WordPress.com [Infograph]
    • Free Recording: WordPress Workshop for Beginners
    • 24 Must Have WordPress Plugins for Business Websites
    • How to Properly Move Your Blog from WordPress.com to WordPress.org
    • 5 Best Contact Form Plugins for WordPress Compared
    • Which is the Best WordPress Popup Plugin? (Comparison)
    • Best WooCommerce Hosting in 2020 (Comparison)
    • How to Fix the Internal Server Error in WordPress
    • How to Install WordPress - Complete WordPress Installation Tutorial
    • Why You Should Start Building an Email List Right Away
    • How to Properly Move WordPress to a New Domain Without Losing SEO
    • How to Choose the Best WordPress Hosting for Your Website
    • How to Choose the Best Blogging Platform (Comparison)
    • WordPress Tutorials - 200+ Step by Step WordPress Tutorials
    • 5 Best WordPress Ecommerce Plugins Compared
    • 5 Best WordPress Membership Plugins (Compared)
    • 7 Best Email Marketing Services for Small Business (2020)
    • How to Choose the Best Domain Registrar (Compared)
    • The Truth About Shared WordPress Web Hosting
    • When Do You Really Need Managed WordPress Hosting?
    • 5 Best Drag and Drop WordPress Page Builders Compared
    • How to Switch from Blogger to WordPress without Losing Google Rankings
    • How to Properly Switch From Wix to WordPress (Step by Step)
    • How to Properly Move from Weebly to WordPress (Step by Step)
    • Do You Really Need a VPS? Best WordPress VPS Hosting Compared
    • How to Properly Move from Squarespace to WordPress
    • How to Register a Domain Name (+ tip to get it for FREE)
    • HostGator Review - An Honest Look at Speed & Uptime (2020)
    • SiteGround Reviews from 4196 Users & Our Experts (2020)
    • Bluehost Review from Real Users + Performance Stats (2020)
    • How Much Does It Really Cost to Build a WordPress Website?
    • How to Create an Email Newsletter the RIGHT WAY (Step by Step)
    • Free Business Name Generator (A.I Powered)
    • How to Create a Free Business Email Address in 5 Minutes (Step by Step)
    • How to Install Google Analytics in WordPress for Beginners
    • How to Move WordPress to a New Host or Server With No Downtime
    • Why is WordPress Free? What are the Costs? What is the Catch?
    • How to Make a Website in 2020 – Step by Step Guide
Deals & Coupons (view all)
Photocrati Coupon
Get 20% off on Photocrati premium photography theme for WordPress.
WP Business Reviews
WP Business Reviews Coupon
Get 15% OFF on WP Business Reviews plugin for WordPress.
Featured In
About WPBeginner®

WPBeginner is a free WordPress resource site for Beginners. WPBeginner was founded in July 2009 by Syed Balkhi. The main goal of this site is to provide quality tips, tricks, hacks, and other WordPress resources that allows WordPress beginners to improve their site(s).
Join our team: We are Hiring!

Site Links
  • About Us
  • Contact Us
  • FTC Disclosure
  • Privacy Policy
  • Terms of Service
  • Free Blog Setup
  • Free Business Tools
Our Sites
  • OptinMonster
  • MonsterInsights
  • WPForms
  • SeedProd
  • Nameboy
  • RafflePress
  • Smash Balloon

Copyright © 2009 - 2021 WPBeginner LLC. All Rights Reserved. WPBeginner® is a registered trademark.

Managed by Awesome Motive | WordPress hosting by SiteGround | WordPress CDN by MaxCDN | WordPress Security by Sucuri.