Tag Archive for url’s

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!

What is a good WordPress plugin that lets me place my travel affiliate url’s into a widget?

Question by Dave: What is a good WordPress plugin that lets me place my travel affiliate url’s into a widget?
I would like to use a widget that compares different travel affiliates prices on flights, hotels, cars. What is the name of some WordPress widgets that can do this? Thanks!

Best answer:

Answer by Inda Cloud
There isn’t a widget that does this, unless some travel companies offer it.

However, if you have text/html/javascript code given to you by travel companies, all you need are text widgets, which are already in your wordpress backend.

Keep in mind, if you’re on wordpress.com there is a good chance your affiliate links won’t work.

Give your answer to this question below!

Powered by Yahoo! Answers