Edit Excel Spreadsheet from Forms Responses

%3CLINGO-SUB%20id%3D%22lingo-sub-1584075%22%20slang%3D%22en-US%22%3EEdit%20Excel%20Spreadsheet%20from%20Forms%20Responses%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1584075%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20wondering%20if%20I%20can%20modify%20the%20Excel%20template%20from%20Forms%20responses%3F%26nbsp%3B%20I%20can%20do%20it%20at%20the%20end%20of%20a%20quiz%2C%20but%20if%20I%20want%20to%20use%20Forms%20for%20a%20daily%20record%20I%20have%20to%20delete%20the%20columns%20every%20day%20to%20enable%20the%20spreadsheet%20to%20be%20utilised%20how%20I%20require.%20I%20don't%20need%20the%20columns%20that%20give%20feedback%20responses%20etc%20or%20emails%2C%20ID.%3C%2FP%3E%3CP%3EIt%20can%20be%20done%20every%20time%20I%20update%20the%20Form%20responses%20in%20Excel%20spreadsheet%20but%20it%20becomes%20very%26nbsp%3B%20laborious%20importing%20the%20data%20how%20I%20need%20it%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1584075%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

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