I have a blog with a large number of posts. I need to give someone a hard copy of the posts, just title, content and date. My immediate thought was to go to phpMy Admin and export the table to Excel, filter out all but the post-type=post and cut out a few columns.
But the option to export to Excel is no longer there.
I've tried exporting to csv, but I don't know how to get this to display in a meaningful Excel manner.
I've looked at many of the other export options like xml etc, but it isn't obvous to me how to remove all the stuff I don't need without cutting and pasting and going through every one of several thousand posts isn't on.