FR: Export comments as CSV

Just a thought. For large comment lists, this would be helpful.

2 Likes

If you select the text of the rendered html page in a browser, and copy and paste into a text editor, then it’s already Tab separated. (Bear in mind that comments will likely have commas.)

I paste the text into BBEdit, and then perform all manner of manipulations on the text to get it into the shape I want for Editorial Notes, etc. (e.g. stripping the author and date).

I have been thinking about ways to automate post-processing of the html directly.

You could also open the HTML file directly in Excel and then save as CSV (after maybe removing the boilerplate lines on top).

That way, you can be sure that fields containing commas, quotes, linebreaks or other problematic characters will automatically be encoded correctly.

1 Like