Forum Discussion
How to get form submissions from my website automatically into Excel?
Hi everyone,
I have a contact form on my WordPress https://chimneysolutionsplano.com/ (built with Fluent Forms plugin) with fields like First Name, Last Name, Email, Phone Number, Service, Location, and Message. Right now submissions are supposed to send an email notification, but I'm not reliably getting those. Since I can easily access an Excel file from my desktop, I'd rather have the submissions go directly into a spreadsheet instead of relying on email.
I looked into it a bit and found that Fluent Forms has a Google Sheets integration but only in their paid Pro version, and nothing built-in for Excel directly. I'm wondering if there's a way to do this using Power Automate or some other Microsoft tool, ideally without paying for extra plugins if possible.
Has anyone set up something similar? Would appreciate any pointers on where to start.
Thanks!
2 Replies
Yes, Power Automate can write submissions into Excel, but the tricky part is getting them out of Fluent Forms automatically.
The usual setup is:
- Store the workbook in OneDrive for Business or SharePoint, and format the destination range as an Excel Table with your form’s column headings. You can still open that workbook in desktop Excel.
- Send each form submission to Power Automate through a webhook.
- Use Excel Online (Business) > Add a row into a table to map the submitted fields into the spreadsheet.
The catch is cost: Fluent Forms’ webhook integration is generally a Pro feature, and Power Automate’s incoming HTTP trigger generally requires Premium licensing. So this isn’t necessarily a free connection, even if you already have Excel.
If keeping Fluent Forms Free is essential, first check Fluent Forms > Entries. If your submissions are stored there, exporting them as CSV and opening that in Excel is the simplest no-extra-cost fallback, though it isn’t automatic. Automatic delivery without the paid integration would need custom WordPress code or another connector.
Also, keep storing submissions in WordPress as a backup. A spreadsheet connection can fail too, and fixing WordPress mail delivery through a properly configured SMTP service is still worthwhile.
Have you considered moving the form out of your site and using Microsoft Forms to design a form? These can be easily tied to an Excel workbook and can trigger power automate flows which allows you to do all sorts of nice things.
