« About Site2nd.org

CSV import to wordpress

I found a script which can import csv file to wordpress. Thanks Zack for posting the original csv import script. I asked a programmer to modify the script(I am not a coder anyway :-)). Here are the changes:

  • tags support
  • multiple categories in one column

CSV sample:

wp_title|wp_post_date|wp_category|wp_content|wp_tags|field1|field2|field3….

title1|2008-05-14 23:59:59|cat1,cat2|long text content|tags1,tags2,tags3|extra field|some extra fields|other extra fields

Please use Category Slug in the csv file.

You can get the script here

This entry was posted on Monday, May 19th, 2008 at 11:50 pm and is filed under wordpress. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

4 Responses to “CSV import to wordpress”

  1. Ludo Says:
    May 23rd, 2008 at 5:44 pm

    Thank you very much for this release.

    Also, can you tell me how the header of the CSV file much look like ?
    specialy for the tags..
    Is it tag | tag | tag | or tag1 | tag2 | tag3 … ?
    Is the rest of the header is the same of the older version ?

    thank you very much again

    Ludo

  2. admin Says:
    May 26th, 2008 at 11:08 am

    The header is like:

    wp_title|wp_post_date|wp_category|wp_content|wp_tags|field1|field2|field3….

    If you have multiple categories and tags, just separated by commas.

  3. bali Says:
    June 12th, 2008 at 7:12 am

    May I change like this :
    wp_title|wp_category|wp_content|wp_tags|field1|field2|field3|wp_post_date

  4. admin Says:
    June 22nd, 2008 at 1:03 am

    Actually, I didn’t try that. But I think it’s better follow the sequence.

Leave a Reply