Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 11:00 AM (PST)
Microsoft Tech Community

Edit Excel Spreadsheet from Forms Responses

Copper Contributor

I am wondering if I can modify the Excel template from Forms responses?  I can do it at the end of a quiz, but if I want to use Forms for a daily record I have to delete the columns every day to enable the spreadsheet to be utilised how I require. I don't need the columns that give feedback responses etc or emails, ID.

It can be done every time I update the Form responses in Excel spreadsheet but it becomes very  laborious importing the data how I need it

0 Replies