Posted 3 years ago #
Hi all, I thought I would give these forums a shot.
I am looking to export the details of my posts into a spreadsheet and wondered if anyone knew how to do this?
Idealy I would like
Title Of Post | Date | Author | Category
No other info is needed but I can delete it once it's in excel if required.
Thanks for any help if anyone reads this.
I don't know how to do it, but that kind of data is in the MySQL database and maybe you can get it from there.
http://codex.wordpress.org/Database_Description
Another option would be to make a custom WordPress page template with query_posts in it to list out all the posts' info for copy and pasting.
http://codex.wordpress.org/The_Loop
http://codex.wordpress.org/Template_Tags/query_posts#Example_3
http://codex.wordpress.org/Pages#Creating_Your_Own_Page_Templates
Added: I don't know if all the data you want is in there, but feeds and XML sitemaps may also have it.
Posted 3 years ago #
yeah i was hoping that there would be a dead simple way to do it. Either with the rss feed or a plugin to do it.
Any suggestions?
Might try these;
http://www.google.com/search?q=html+to+csv+converter
Posted 3 years ago #
Has anyone got a tutorial or something on how to do this?
I have no idea what I am doing to get this done.
Posted 2 years ago #
Hey
Did you find a solution for this and would you be willing to purchase CSV 2 POST Plus if I added such an ability to it?
I plan to anyway it's just that I could make it higher priority.
CSV 2 POST is a csv import plugin I made that is slowly and will aventually do all things CSV on WordPress so that you don't need to install a plugin to mass delete posts, export data and another one to import it.
Currently selling at £29.99 and the price will go up once the export ability is added however for you I would keep it at this price.
Ryan
Posted 2 years ago #
iridiax,
I need to export post data out of wordpress (to excel) but the xml file generated by wordpress is not XML compilant so i cant read it in Excel...
i need to read post data (title and custom fields) to generate in excel statics
exporting mysql data is not a option because the xml or xls data is veeeery bad constructed..
and the xml (non compilant) data is just what i need but i dont figure out how to make it XML compilant
anybody can help me?
Posted 2 years ago #
Sorry not at the moment tied up with CSV 2 POST importing functions won't be coding the exporting tools for another 2-3 weeks possibly.
Watch the development of CSV 2 POST because it will eventually do everything when it comes to data management for WP.
Ryan
Posted 2 years ago #
I decided to create a new plugin which is even better than CSV 2 POST called Easy CSV Importer. You can do data import from your PC and avoid opening csv files on your server too much.
This topic has been closed to new replies.
