If you have a data stored in excel (.csv : comma seperated values), usually a catalog from affiliate program like revresponse.com or clickbank, and you want to import into your wordpress database you can folllow this instruction below.

I have a plugin designed by http://www.zackpreble.com

important: you must edit your csv file become a pipe (|) delimited. So the format is become:

wp-title | wp_post_date|wp_category| pp_content| feld1 |field2 | field3|….(top of file)
post title1 | 20009-07-13 21:00:00| category |content blog |….
post title2 | 20009-07-13 21:00:00| category |content blog |….
……

1. Download CSV_Import from this source.
2. Unzip and up load the file called csv.php to /wp-admin/import/
3. Prepare your csv file, here is a sample file. It’s really a pipe delimited file.

It MUST follow this format or it will not work. Make sure you include the header row.

posted on on Monday, July 13th, 2009 at 8:19 pm
under Wordpress Tutorial
RSS 2.0 feed. You can leave a response, or trackback from your own site.

2 Responses to “Importing csv file into wordpress”

1. Ryan Says:
   October 10th, 2009 at 6:43 pm

   This is the old way of doing things. The CSV 2 POST plugin doesnt require you to edit your csv file in 99% of projects and uploads with the use of a WYSIWYG editor, plus lots more!

   http://www.csv2post.com

2. admin Says:
   October 14th, 2009 at 9:01 pm

   Thanks for visiting Ryan. and thanks to tell us about csv2 post plugin for WP. I will visit web you reffered.

Leave a Reply