add the title of form in a column to excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1155719%22%20slang%3D%22en-US%22%3Eadd%20the%20title%20of%20form%20in%20a%20column%20to%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1155719%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20I%20new%20in%20this%20of%20Microsoft%20Forms%20and%20i%20wonder%20if%20%3CSPAN%3EIs%20there%20any%20way%20to%20add%20the%20title%20of%20a%20survey%20in%20a%20column%20to%20the%20excel%20file%20when%20generating%20it%3F%26nbsp%3Bor%20something%20like%20add%20an%20invisible%20question%20and%20filled%20by%20default%3F%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EI%20hope%20someone%20could%20help%20me%20please.%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1155719%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESurvey%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1156499%22%20slang%3D%22en-US%22%3ERe%3A%20add%20the%20title%20of%20form%20in%20a%20column%20to%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1156499%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F547466%22%20target%3D%22_blank%22%3E%40Juan_Ignacio%3C%2FA%3E%26nbsp%3Bif%20you%20open%20the%20results%20in%20Excel%20the%20spreadsheet%20name%20is%20the%20name%20of%20the%20form.%20But%20I%20don't%20think%20that's%20what%20yo%20want.%20Alternatively%20you%20could%20use%20Power%20Automate%20to%20get%20each%20form%20response%20as%20it%20arrives%20and%20save%20it%20to%20an%20Excel%20spreadsheet%20with%20the%20name%20of%20the%20survey%2Fform%20in%20one%20of%20the%20columns.%20This%20will%20help%20if%20you%20have%20multiple%20surveys%20all%20populating%20the%20final%20spreadsheet%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Frequent Visitor

Hi I new in this of Microsoft Forms and i wonder if Is there any way to add the title of a survey in a column to the excel file when generating it? or something like add an invisible question and filled by default?

I hope someone could help me please. 

1 Reply
Highlighted

@Juan_Ignacio if you open the results in Excel the spreadsheet name is the name of the form. But I don't think that's what yo want. Alternatively you could use Power Automate to get each form response as it arrives and save it to an Excel spreadsheet with the name of the survey/form in one of the columns. This will help if you have multiple surveys all populating the final spreadsheet

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User