Posting list copied to Excel?

  • Author
    Posts
  • #891835

    Is there a simple way to copy the list of posts from my WordPress site into an Excel or Word list?

    The blog I need help with is smartamarketing.wordpress.com.

    #891979

    You could set up a draft page and then use the archives shortcode in that page, preview it and then copy out the resultant list.

    http://en.support.wordpress.com/archives-shortcode/

    This would produce a straight reverse chronological list of post titles:

    [archives]

    I think if you tried to paste into Excel, it would just put everything into one cell, but you can paste it into Word. You might first want to paste it into a plain text file to strip out the formatting before pasting into Word.

The topic ‘Posting list copied to Excel?’ is closed to new replies.