How to Use CSV Importer for WordPress

tutuploadsStep_1._Download_and_install..png

This plugin imports posts from CSV (Comma Separated Value) files into your WordPress blog. It can prove extremely useful when you want to import a bunch of posts from an Excel document or the like – simply export your document into a CSV file and the plugin will take care of the rest.

Step 1. Download and install

tutuploadsStep_1._Download_and_install..png

In your administration dashboard go to Plugins > Add New > Search Plugins. Search for CSV Importer.

tutuploadsmedia_1317673357089.png

Click Install Now.

tutuploadsmedia_1317673372270.png
Click Activate Plugin.

tutuploadsmedia_1317673427630.png

Access the plugin from the Dashboard by going to Tools > CSV Importer

Click the check box to import the file as a draft or all the articles will be automatically published (although you may want that)

Select a category to upload them to.

Browse and upload the CSV file

This part is all very simple to understand. The hard part is preparing the file for import. If you don’t have it done correctly it won’t import correctly. Do it right, and you can not only upload the file, but create new categories, fields and taxonomies if they aren’t already created.

It starts with preparing a spreadsheet, and then saving it as a CSV file. The two most popular programs for this are Microsoft Excel and Open Office Calc.

NOTE: Some spreadsheet programs do not save CSV files the same as others. You may run into a problem with punctuation or other special characters in a text field when you upload. Open Office Calc has always worked properly for me. If you are having problems, you can download it for free from http://www.openoffice.org/ and give that a try.

Step 2. Prepare the spreadsheet.

tutuploadsStep_2_91b7a17f0adda7404194d1f8d927ab17.png

Your spreadsheet should look like the sample above.

On your spreadsheet, every line will be a different page or post. Every column will be a part of the post. The import program will import one line at a time, and will distribute the information in the columns based on what titles you have at the top of the spreadsheet. So first you need to know what columns to put at the top.

Here is the list of possible columns to use, which is also available on the plug in page.

These titles need to be in the top row of your spreadsheet. All lower case, with the underscores between words. You don’t need to put all of them in there if you are just going to import titles, with post body content, and tags, you can just create a spreadsheet with three columns. This can be as simple or complex as you need it.

General comments

  • WordPress pages don’t have categories or tags. but posts do.
  • Most columns are optional. Either csv_post_title, csv_post_post or csv_post_excerpt are sufficient to create a post. If all of these columns are empty in a row, the plugin will skip that row.
  • The plugin will attempt to reuse existing categories or tags; if an existing category or tag cannot be found, the plugin will create it.
  • To specify a category that has a greater than sign (>) in the name, use the HTML entity >

Basic post information – use these as the column headers in the first row of your spreadsheet

  • csv_post_title – title of the post
  • csv_post_post – body of the post
  • csv_post_type – post, page or a custom post type. New in version 0.3.2 In prior versions, importing rows as pages could be specified on a per-file basis using the plugins UI. In 0.3.2, csv_post_type column was added to support custom post types as well. Refer to the WordPress documentation on custom post types for more info on how to set up custom post types.
  • csv_post_excerpt – post excerpt
  • csv_post_categories – a comma separated list of category names or ids. New in version 0.3.5 It’s also possible to assign posts to non-existing subcategories, using > to denote category relationships, e.g. Animalia > Chordata > Mammalia. If any of the categories in the chain does not exist, the plugin will automatically create it. It’s also possible to specify the parent category using an id, as in 42 > Primates > Callitrichidae, where 42 is an existing category id.
  • csv_post_tags – a comma separated list of tags.
  • csv_post_date – about any English textual description of a date and time. For example, now, 11/16/2009 0:00, 1999-12-31 23:55:00, +1 week, next Thursday, last year are all valid descriptions. For technical details, consult PHP’s strtotime() function documentation.

Custom fields

Any column that doesn’t start with csv_ is considered to be a custom field name. The data in that column will be imported as a custom fields value.

Advanced usage

  • csv_post_author – numeric user id or login name. If not specified or user does not exist, the plugin will assign the posts to the user performing the import.
  • csv_post_slug – post slug used in permalinks.
  • csv_post_parent – post parent id.

Tip: Sample files

There are samples of the various types of spreadsheets you can use as starters for your own spreadsheets so you can get it right. If you need to view the samples they are located in /public_html/wp-content/plugins/csv-importer/examples You can download them using FTP or you can go to http://yourdomainname.com/wp-content/plugins/csv-importer/examples/ and you will be able to download them. I suggest you delete this directory after you download the samples, or add a blank index.html file for security.

Instructor

0 0 votes
Blog Rating
Subscribe
Notify of
9 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
Opal

I am looking a plugin just like this one but I would like to import products to jigoshop instead of importing posts to my wordpress site. Can I use this plugin to acheive my goal? Thank you.

Nick

Hi Opal, Give the following documentation a look:

[url=http://forum.jigoshop.com/kb/managing-orders/importexport]http://forum.jigoshop.com/k…[/url]

Kind regards,

Nick

Esther Molenaar

Hi, I tried using the example file. I always get the same response. Skipped 13 posts (most likely due to empty title, body and excerpt). Imported 0 posts and 0 comments in 0.01 seconds.

Please help!

Patrick Iverson

I’m having success with everything except the Custom Fields? Any other tips/tricks?

webmaestro

I got everything working *except* for `csv_ctax_(taxonomy)`… Even `csv_post_type` is working!
I’m using the ‘Types’ plugin, so the plugins are all `wpcf-[field-slug]` (e.g., `wpcf-city`), and that seems to be working for me…
Any ideas on how to get the custom taxonomy stuff working? I’d rather not have to go through and… erm… manually classify these things…

David Robinson

I bought ultimate csv imoprter based on the description of its functionality. I had problems form the outset, which I tried to sort out with support. They often came back to me saying an issue had been fixed when it had not. After a week I ended up with a bunch of workarounds and still with issues unfixed. I was on a deadline so purchased WP ALL import. It worked perfectly within 1 hour and has a much better interface. I asked for a refund and was told no. I pushed for a refund and was finally told I would get one. That was 2 weeks ago. The support are now ignoring all emails I send to them. This products does not work as described and the company that makes it are liars. Save yourself a lot of time and money and buy WP All Import.

Dipesh Timalsina

how to open custom cvs files from wordpress

Ronn

Can you post with image urls?

mikall

[b]Ultimate CSV Importer[/b] says it can import media images from any external url.  Check that out [url=https://wordpress.org/plugins/wp-ultimate-csv-importer/]here[/url].

Also, Check out the [url=https://wordpress.org/plugins/wp-all-import/]WP All Import plugin[/url] as they say you can post with image urls with their Pro (paid for) version, but read their documentation first to find out if this would be a good fit for you or not.

9
0
Would love your thoughts, please comment.x
()
x