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.
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..
Add your own answer in the comments!