Posting list copied to Excel?

• 

  smartamarketing · Member · May 17, 2012 at 5:36 am

  • Copy link
  • Add topic to favorites

  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: (visible only to logged in users)

• 

  thesacredpath · Member · May 17, 2012 at 8:24 am

  • Copy link

  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.