# Extract Form Submissions Automatically to Excel

**URL:** <https://community.hubspot.com/t/extract-form-submissions-automatically-to-excel/14570>\
**Category:** APIs & Integrations\
**Tags:** forms\
**Created:** [May 29, 2019, 11:33am UTC](https://community.hubspot.com/t/extract-form-submissions-automatically-to-excel/14570 "2019-05-29T11:33:34Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![bcbotxo](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/bcbotxo/32/86357_2.png) [@bcbotxo](https://community.hubspot.com/u/bcbotxo)\
**Post date:** [May 29, 2019, 11:33am UTC](https://community.hubspot.com/t/extract-form-submissions-automatically-to-excel/14570/1 "2019-05-29T11:33:34Z")

</div>

Hello everyone,

I have multiple forms on Hubspot and I am trying to get the number of form submissions each month and automatically store this into an excel file. Where my data updates at the end of each month. Basically, I need an API to extract the data. Could somebody please help me with this?

---

<div class="post-metadata">

**Author:** ![Willson](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/willson/32/84663_2.png) [@Willson](https://community.hubspot.com/u/Willson)\
**Post date:** [May 29, 2019, 1:42pm UTC](https://community.hubspot.com/t/extract-form-submissions-automatically-to-excel/14570/2 "2019-05-29T13:42:43Z")

</div>

Hi @bcbotxo

Great question!  
I believe the **Get analytics data for specific objects** endpoint may be of use here, see here:

> **[Accounts Dashboard | HubSpot](https://app.hubspot.com/myaccounts?next=developerdocs&redirect=%2Fmethods%2Fanalytics%2Fget-analytics-data-by-object)**

This endpoint allows you to request specific data in relation to an object. For form data, you can use the following request:

`https://api.hubapi.com/analytics/v2/reports/forms/total?hapikey=xxxx&start=20180101&end=20190531`

You’ll want to ensure you’re customising the time constraints set by the use of _ **&start=xx** _ and _ **&end=xx.** _

Once this call is made, you’ll receive a response along the lines of the following:

```auto
{
 "offset": 5,
 "total": 5,
 "totals": {
 "submissions": 21,
 "formViews": 56,
 "installs": 8,
 "visibles": 38,
 "interactions": 6,
 "submissionsPerFormView": 0.375
 } //Further breakdowns will be provided but have been removed from this snippet.

```

You can then extract and use the above data as you’d like.

Thanks,

Matt

---

<div class="post-metadata">

**Author:** ![bcbotxo](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/bcbotxo/32/86357_2.png) [@bcbotxo](https://community.hubspot.com/u/bcbotxo)\
**Post date:** [May 30, 2019, 7:09am UTC](https://community.hubspot.com/t/extract-form-submissions-automatically-to-excel/14570/3 "2019-05-30T07:09:04Z")

</div>

Hey Matt,

Thank you for your reply. I am trying to do this in python, however I am not that familiar. Could you please guide me on how I would do this.

Cheers,

Sam

---

<div class="post-metadata">

**Author:** ![Willson](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/willson/32/84663_2.png) [@Willson](https://community.hubspot.com/u/Willson)\
**Post date:** [May 30, 2019, 12:22pm UTC](https://community.hubspot.com/t/extract-form-submissions-automatically-to-excel/14570/4 "2019-05-30T12:22:47Z")

</div>

Hi Sam (@bcbotxo),

Unfortuntely I would not be the best resource to do a full walkthrough here, but I am more than happy to look into specific questions and any roadblocks you encounter.

Thanks,

Matt