How can I get a list of post titles and URL's off my wordpress blogs in a CSV format? - wordpress blogs
How can I get a list of post titles and URLs of my WordPress blogs in CSV format?
I tried to XML export, but I need a csv file titles and the URLs to CSV. I am in WordPress v2.8.
Saturday, December 12, 2009
Wordpress Blogs How Can I Get A List Of Post Titles And URL's Off My Wordpress Blogs In A CSV Format?
1 comment:
There is no official way, but there are two relatively simple solutions:
1. Import) your XML file in Excel (or another spreadsheet program, clean, and the columns, then export to CSV.
2. If you have cPanel, phpMyAdmin, or access to, go to your WordPress database, and then export the table headings in CSV format, additional purification columns. URLs will be made in the column GUID.
Oh - here's something that struck me last night :-)
- Inclusion of the rapid --
If you are called to change the FTP, uncompress / Save the CSV file export.php, then download the file to the current theme folder. Create a new blog page, CSV export and use of top model (model on the right side in WordPress select option), then publish and display the page - is the list of headings and titles. Copy and paste the list into Excel, Notepad, etc., save as .. csv
http://paulcoughlin.com/csv-export.zip
Cheers!,
Paul.
Post a Comment