Exporting post metadata into CSV?

I think Data Explorer would actually be the best option for this. You shouldn’t need another plugin.

You can create a custom SQL query that pulls only the fields you need, such as category, topic title, URL and author, without including the post content.

You can also filter the results by category ID, so you’re only exporting data from that particular category.

Once the query is working, you can download the results as a CSV file.

Are you looking to export details for each individual post or just the topics within that category? The SQL query would be slightly different depending on that.