Tag Archive for list

A List Blogging

Check out these blogging products:

A List Blogging
Kickstart Your Blog! Create Your Very Own Blog Quickly And Easily Without Knowing Any Geek-speak!
A List Blogging

A-list Blogging Masterclass
This Outstanding Membership Program For Bloggers Teaches How To Become A Top Blogger, Create Killer Content, Make Your Blog Look And Feel Professional, And Turn It Into A Business That Lets You Say Goodbye To Your Boss.
A-list Blogging Masterclass

How can I get a list of post titles and URL’s off my wordpress blogs in a CSV format?

Question by ChrisW: How can I get a list of post titles and URL’s off my wordpress blogs in a CSV format?
How can I get a list of post titles and URL’s off my wordpress blogs in a CSV format?

I tried exporting it but it was in xml, i need a csv of titles and their corresponding URLs in CSV format. I am on wordpress v2.8.

Best answer:

Answer by paulcoughlin
There isn’t an official way, but there are two fairly easy workarounds:

1. Import your xml file into excel (or another spreadsheet app), clean up colums, then export as csv.

2. If you have cPanel, or access to phpMyAdmin, go into your wordpress database, and export the posts table as csv, clean up extra colums. The urls are in the guid column.

Oh – here’s something that came to me last night :-)

— added after quick test —

if you can ftp and edit, unzip/save the file called csv-export.php, then upload that file to your current theme folder. Create a new blog page, use csv-export as the page template (choose template option over on the right in wordpress), then publish and view the page – it will list your posts and titles. Copy and paste list into excel, notepad etc, save as csv..

http://paulcoughlin.com/csv-export.zip

cheers,
Paul.

Add your own answer in the comments!

Powered by Yahoo! Answers