A powerful, yet simple, CSV importer and exporter for WordPress.
Features
Import
Import posts and pages using your favourite spreadsheet program.
Export
Export all your posts and pages to a convenient CSV format.
Tags
Add and remove tags from hundreds of posts at once.
Custom Fields
Manage your custom fields the easy way.
Categories
Add and remove categories from thousands of posts at once. Build complex hierarchies too, if you need to.
Images
You can set your featured images. You can even add images to the body of your post or page.
Custom Post Types
All custom post types supported.
Language Support
All characters from all languages are supported (UTF-8).
Free Updates
This plugin is free, and all updates will be published to the WordPress plugin repository.
Documentation
Free Download
This is a free open source plugin. You can download it here:
WP CSV Plugin
Great plugin. I’m attempting to export and then import data from “postmeta” as well. I’m wondering if there is some customization that can be done to extend the plugin. I notice it works with postmeta for thumbnails. Would you have pointers on how to proceed? Thanks!
Hi Tel
It sounds like you just want to import some custom fields. If so, then the plugin does support that. The plugin is designed to let WP and your spreadsheet do most of the heavy lifting.
So, the best way to add the custom fields is in the WordPress post edit screen. You only need to do it once and then next time you export, new columns will appear.
I hope that helps.
Best wishes
Paul
Excellent tip – almost there! I am trying to put in data for longitude/latitude (it is a mapping theme for wordpress) and for some reason the serialized data is “re-serialized” when I import it with WP CSV. I hear this is might be Word Press problem, but i’m wondering if the plugin can help with this in any way. I did not find any “serialize()” in the source files. Thanks!
Functions like update_post_meta automatically serialize/unserialize data, but I’m not sure there’s much you can do to benefit from that without modifying the plugin. I’ve contacted you directly.
Best wishes
Paul
Awesome plugin and thank you it saved me a ton of time. Only thing was though, I went through and set post_author field for the correct author for each post, but when I imported it these were ignored and all posts were set to post_author = 1. Luckily it wasnt many so I manually edited them but for those wondering, is there a way to keep the post_author field accurate?
FYI I tried with and without ID column and no effect, I also uploaded without ID column to get WP to set new post ID’s, then exported and edited manually each row to correct the post_author column and reuploaded but it set all post_author fields to 1 again.
Hi David
Thanks for pointing this out. I’ve uploaded version 1.3.6 to add this field in. As a general rule, if the field doesn’t export, then it isn’t supported (yet).
FWIW, the plugin and its ancestors have actually never supported this field. When I first created the plugin several years ago, my goal was to keep the number of columns to a minimum so this is one of half a dozen fields that got the chop. It really should be available however, so I appreciate you taking the time to give feedback.
Best wishes
Paul
I wish to move my current blog http://www.peacefultable.blogspot.com to wordpress. I know nothing about conmputer so am reading WordPress for Dummies. Would this plugin be something I could use to migrate my old blog date onto wordpress. My new site is peacefultable.net. Thank you.
Hi Amanda
Not without a lot of work, but you could try this:
http://blogger2wordpress.appspot.com/
Then in your WordPress dashboard, choose Tools > Import and follow the prompts. We haven’t tried this ourselves, but hopefully it will help you.
If you run into any problems or just don’t have the time for the WordPress learning curve, we provide a cost effective migration and setup service. Please message us via the contact page if you’re interested.
Best wishes
Paul