How to have an Excel file that automatically updates everytime there's a new submission which is saved through Dropbox?

  • Mauro
    Asked on September 19, 2024 at 11:58 AM

    In my company we use dropbox as storage, I understand that jotform has an integration with dropbox. I would like to know if it is possible to have an excel that has the updated answers of the form answers, that is, every time the form is filled, the answer is saved in a row of the excel and the next answer in the next row and the excel automatically updates the answers.

  • Silvano JotForm Support
    Replied on September 19, 2024 at 12:30 PM

    Hi Mauro,

    Thanks for reaching out to Jotform Support. There's no native integration to do what you want to setup but I believe this is feasible by integrating your form with Microsoft Excel through Zapier, then integration your Microsoft Excel to Dropbox through Zapier as well. Here's how:

    1. In Form Builder, click on Settings in the orange navigation bar at the top of the page.
    2. Now, in the left panel, click on the Integrations.
    3. Next, search and select Microsoft Excel.

    How to have an Excel file that automatically updates everytime theres a new submission which is saved through Dropbox? Image 1 Screenshot 30

    4. Then, select which type of Zap you wanted to create by clicking Use This Zap button. Finally, follow the next prompt which is to login to your Zapier Account.

    How to have an Excel file that automatically updates everytime theres a new submission which is saved through Dropbox? Image 2 Screenshot 41

    That's it. To integrate Microsoft Excel to Dropbox using Zapier, I found this guide that you can check.

    Give it a try and let us know if you have any other questions.

Your Answer