Jul 25 2019 03:12 AM
Hi,
I want to use Microsoft forms for an invoice in excel. I have made the invoice, which automatically collects data from the Excel table opened with Microsoft Forms, but when a new response has been filled in, the table used for the invoice is not updated. Does anyone know if it is possible to automatically add new Forms responses to an Excel table, or to obtain the data in another way?
Thanks in advance,
Suzanne Kepel
Jul 25 2019 04:16 AM
Hi
When you open the the Form in Microsoft Forms, you have 2 tabs at the top >> Click on the Responses Tab.
in the Upper right side there is an option saying: Open in Excel
If your excel file is saved in the clouds (oneDrive) then it updates to include new responses.
If you click on the elipses, there is an option to print the responses or delete them.
Hope that helps
Nabil Mourad
Jul 25 2019 04:32 AM
Jul 25 2019 05:21 AM
Hi Suzanne
I assume you started creating your survey in Microsoft Forms and you try to view responses in Excel.
try to initially create your survey by using Forms in Excel Online: Insert Tab of the Ribbon >> Survey (or Form) and go from There.
Save the File in the clouds
Test responses
Hope that helps
Nabil Mourad
Feb 22 2021 12:17 PM
My Excel online doesn't display a survey button in the insert tab. I have a paid 365 account. do I need to enable something. thanks
Feb 23 2021 07:27 AM
Feb 23 2021 11:10 AM
@Sergei Baklan thank you for your response. My problem is that the Forms button does not show in the insert tab. Consequently, Excel does not populate in real-time
Feb 26 2021 11:41 AM
That's in Excel Online. You open/create new file on SharePoint site / OneDrive, open it in Excel Online, insert Forms and create survey using Forms, all responses will be collected here. Once it synced with Forms you may open it in desktop version if that's more suitable.
Just in case, that's quite old announcement of this functionality Forms for Excel, new experience for Excel survey in Office 365 - Microsoft Tech Community
Mar 08 2021 12:46 AM
Sorry, but I do not see the option "forms" in Excel online. What am I doing wrong?
Mar 08 2021 03:44 AM
If
- you are Office365 subscriber; and
- you are on business or educational subscription; and
- your Excel file is saved on SharePoint site / OneDrive
when it shall be Forms in Insert section of the ribbon menu.
Sep 08 2021 07:31 PM
Sep 17 2021 10:49 AM
Sep 17 2021 02:40 PM
Nope, that doesn't work.
Oct 01 2021 08:58 AM
Oct 01 2021 01:55 PM
I didn't try, but most probably yes. Power Automate allows you to add row to any table in any file. Dynamic content for row could be taken from data triggered by Microsoft Forms.
Dec 20 2021 06:41 AM - edited Dec 20 2021 06:45 AM
@rinkenpeter I also do NOT see the forms button in the menu. How do I activate this? It would be nice to have an MS form fill into a live worksheet, similar to what google forms and sheets can do.
Dec 20 2021 07:22 AM
@franklinam38 , are you on business or consumer subscription? If business which one?
Dec 20 2021 07:59 AM
Dec 20 2021 08:29 AM
Dec 20 2021 08:44 AM
I think I got it figured out. The form button does not appear on an already active workbook but DOES appear when creating a new workbook. I knew it had to be something simple.