Blog list export to csv

How can I export our blog data in terms of blog title, blog url, blog category/categories and publish date into a csv file to analyze? We have a lot of blogs and need to do a full audit but cannot figure out how to even pull a list of what we currently have on our website. I see no option to export in settings>import/export and in website> My blog posts is just has 12 pages of blogs but no option to export a list...please help with how to do this.

By going to "My Blog Posts" - You can highlight everything in the table and use ctrl+c to copy the information, then you can paste the info directly into an empty CSV file, you can repeat this procedure for all 12 pages. There is no download available as you have described.

You can see a video demonstrating how to copy into CSV here: https://www.youtube.com/watch?v=0PqLHO3NuRU