# Exporting Blog Posts to CSV File

**URL:** <https://community.hubspot.com/t/exporting-blog-posts-to-csv-file/19825>\
**Category:** CMS Development\
**Created:** [April 2, 2020, 9:06pm UTC](https://community.hubspot.com/t/exporting-blog-posts-to-csv-file/19825 "2020-04-02T21:06:30Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![GCandido](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/gcandido/32/98997_2.png) [@GCandido](https://community.hubspot.com/u/GCandido)\
**Post date:** [April 2, 2020, 9:06pm UTC](https://community.hubspot.com/t/exporting-blog-posts-to-csv-file/19825/1 "2020-04-02T21:06:30Z")

</div>

Hello Hubspot Developers Community,

I am trying to export my blog posts to a CSV file. I had been using the code below to achieve this, but the code is limited to a 200 post output. In the space that says ‘my\_blog\_id’, I put my actual blog’s ID. Now, I understand that the 200 post limit is due to the use of blog\_recent\_posts, but is there a way to extend this limitation to 2000? Thank you so much for your help!

{% set export = blog\_recent\_posts(‘my\_blog\_id’, 2000) %}

“post\_title”,“post\_slug”,“post\_date”,“post\_content”,“post\_thumbnail”,“post\_author”,“post\_category”,\<br\>  
{% for content in export %} “{{ content.name|forceescape }}”,“{{ content.slug|forceescape|replace(‘blog/’, ‘’) }}”,“{{ content.publish\_date\_localized|forceescape }}”,“{{ content.post\_body|replace('”‘,’“”‘)|forceescape|escape\_jinjava }}“,”{{ content.featured\_image }}“,”{{ content.blog\_post\_author }}“,”{{ content.topic\_list|forceescape|replace(’[‘, ‘’)|replace(’]', ‘’) }}"\<br\>{% endfor %}

---

<div class="post-metadata">

**Author:** ![Phil\_Vallender](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/phil_vallender/32/48924_2.png) [@Phil\_Vallender](https://community.hubspot.com/u/Phil_Vallender)\
**Post date:** [April 2, 2020, 10:54pm UTC](https://community.hubspot.com/t/exporting-blog-posts-to-csv-file/19825/2 "2020-04-02T22:54:21Z")

</div>

Hi @GCandido

I think 200 is an API limit? Don’t think you can change that.

The clever people over at Blue Leadz might have an alternative solution though: [How To Export a HubSpot Blog to WordPress](https://www.bluleadz.com/blog/how-to-export-a-hubspot-blog)

Hope this helps.
