Export List of Blog Posts in a CSV File

In early 2019, it was possible to export a list of Blog posts from Marketing > Website > Blog. There was a link titled ‘Export’ in the top filtering links.

This feature was removed sometime in 2019 whan an interface change was made. I’ve confirmed with Hubspot support that this feature no longer exists.

Who this is for: Marketing teams that need to export Blog posts with a Title, URL, etc for importing into other platforms or for checking the most views and other data on Blog posts.

This feature is used to import into a 3rd party search platform to include Blog posts in search results on an Ecommerce platform.

Blog post attributes that were in this CSV export were:

Publish Date

Blog Post Name/Title

Author

Page Views

CTA Clicks

CTA Click Rate

State (Published/Draft)

Campaign

Creation Date

Last Update

Please restore this Blog posts export feature!

Export list of all blogs on my site. with their published status, tags, url, and other metadata, with traffic analytics etc as well.

this will enable me to analyse my blogs, see on what topics they been written, identify pillar pages and organize.

You can get an export of your blog posts (or website and landing pages) by following these steps:

  1. Go to Reports > Analytics Tools > Website Analytics
  2. Ensure you select “Blog posts” as the “Page Type” (in the upper left corner)
  3. Click the <Export> link (in the upper right corner)
  4. Select " xlsx" as the “File Format” to get a complete report of your blog posts, including name, author, URL, tags, dates, campaigns, etc

I hope this helps!

Not sure why it took me 5 hours to find the info @dtafleur easily provided above. Oh wait, that’s right, it’s Hubspot. Why they refuse to put together useful and simple documentation like the above, is beyond me. It’s all up to the community to figure things out.
So, thank you a million times @dtafleur for posting your comment.
I’m now waiting for Hubspot to email me my exported file so I’m still not sure this export is exactly what I need to migrate my blog posts to Webflow, but hey, it’s progress. Albeit, slow progress.
Oh, and I noticed that you can export this data in CSV format which is what Webflow needs! So that’s good! Again, I’ll have to wait and see if this exported file does have all the data I need to successfully migrate my blog.

@Seahawksean u r welcome! Please note: as per 1 September 2020, they will be moving the report under the pages tab of the traffic analytics report. Good luck with migration your blogs to Webflow!

UPDATE: Unfortunately the exported CSV file doesn’t contain the fields required by Webflow for the migration. The data included is specifically analytics data. It doesn’t include the fields like post-type, post-name, id, etc. that Webflow seem to require for migration. So, I’ve run into yet another deadend.

I found a way to export HubSpot Blog. But it’s not a best practise: Blog | How to Export a HubSpot Blog to WordPress in 11 Easy Steps

Hi folks!

I’m happy to report this is now in Public Beta. To export your blog into a CSV…

  1. Navigate to Marketing >> Website >> Blog
  2. Click on “More tools” in the left navigation menu
  3. Select the “Export all blog posts (CSV)” option

This Beta is gradually rolling out to all CMS Hub Professional & Enterprise and Marketing Hub Professional & Enterprise customers. Contact your CSM if you’d like to be enrolled.

Best,

Joe

Hi folks!

I’m happy to report this is now in Public Beta. To export your blog into a CSV…

  1. Navigate to Marketing >> Website >> Blog
  2. Click on “More tools” in the left navigation menu
  3. Select the “Export all blog posts (CSV)” option

This Beta is gradually rolling out to all CMS Hub Professional & Enterprise and Marketing Hub Professional & Enterprise customers. Contact your CSM if you’d like to be enrolled.

Best,

Joe

Hi folks!

It’s now possible to export HubSpot-hosted blog posts as a CSV file. To export your blogs:

  1. Navigate to Marketing >> Website >> Blog
  2. Click on “More tools” in the left navigation menu
  3. Select the “Export all blog posts (CSV)” option

This is now available to all customers with CMS Hub Professional & Enterprise and Marketing Hub Professional & Enterprise.

Hello,

I was wondering if this same option could be added for landing pages as well? I do not see the same option there to export the list from there, only HTML. Thank you!

Yes, me too, I’m on a treasure hunt for workarounds to export the landing page details without having to copy and paste into Excel myself; each time I find a workaround, it has already been vanished in the interface.