Home

Is it possiable to automate exporting form results

%3CLINGO-SUB%20id%3D%22lingo-sub-750739%22%20slang%3D%22en-US%22%3EIs%20it%20possiable%20to%20automate%20exporting%20form%20results%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-750739%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20there%20a%20way%20to%20either%20export%20or%20query%20form%20results%20using%20some%20form%20of%20automation%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThanks%2C%3C%2FP%3E%0A%3CP%3EJeffrey%20J.%20Timmerman%3C%2FP%3E%0A%3CP%3ESite%20Reliability%20Engineer%3C%2FP%3E%0A%3CP%3EMicrosoft%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-750739%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAutomation%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Eexport%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExport%20Results%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Forms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EQuiz%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ERemote%20Query%20Results%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-751436%22%20slang%3D%22en-US%22%3ERe%3A%20Is%20it%20possiable%20to%20automate%20exporting%20form%20results%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-751436%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F335087%22%20target%3D%22_blank%22%3E%40jetimmer%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20your%20form%20is%20a%20Group%20form%20then%20there%20should%20be%20an%20Excel%20file%20in%20SharePoint%20under%20the%20Documents%20library.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20the%20Excel%20file%20isn't%20there%2C%20try%20opening%20your%20results%20in%20Microsoft%20Forms%20and%20then%20try%20again.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECould%20be%20automated%20using%20MS%20Flow%20from%20there%20as%20an%20example.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20that%20makes%20sense%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3CP%3EDamien%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-753835%22%20slang%3D%22en-US%22%3ERe%3A%20Is%20it%20possiable%20to%20automate%20exporting%20form%20results%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-753835%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F335087%22%20target%3D%22_blank%22%3E%40jetimmer%3C%2FA%3E%2C%20if%20you%20don't%20want%20to%20use%20the%20built-in%20excel%20spreadsheet%20of%20results%20in%20Forms%2C%20you%20can%20use%20Flow%20to%20send%20each%20response%20to%20a%20new%20row%20in%20a%20spreadsheet.%20Make%20sure%20you've%20formatted%20your%20spreadsheet%20as%20a%20table%2C%20and%20then%20the%20flow%20is%20quite%20simple%20as%20shown%20in%20the%20image%20below.%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-left%22%20style%3D%22width%3A%20716px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F123247i37762D14002BA65C%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Flow.png%22%20title%3D%22Flow.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1039227%22%20slang%3D%22en-US%22%3ERe%3A%20Is%20it%20possiable%20to%20automate%20exporting%20form%20results%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1039227%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F89704%22%20target%3D%22_blank%22%3E%40Damien%20Rosario%3C%2FA%3E%26nbsp%3B%20Hi%20Damien%2C%20I%20would%20have%20to%20have%20an%20export%20in%20a%20.csv%20file%20and%20not%20an%20.xlsx%20file.%20Is%20there%20any%20way%20to%20do%20that%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1039290%22%20slang%3D%22en-US%22%3ERe%3A%20Is%20it%20possiable%20to%20automate%20exporting%20form%20results%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1039290%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F472411%22%20target%3D%22_blank%22%3E%40Daniel2019%3C%2FA%3E%26nbsp%3B%20you%20could%20just%20export%20it%20as%20an%20excel%20file%20then%20in%20Excel%26nbsp%3B%3CEM%3Esave%20as%3C%2FEM%3E%20a%20csv.%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1041387%22%20slang%3D%22en-US%22%3ERe%3A%20Is%20it%20possiable%20to%20automate%20exporting%20form%20results%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1041387%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F472411%22%20target%3D%22_blank%22%3E%40Daniel2019%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20Rob%20said%20is%20correct.%26nbsp%3BThere's%20a%20few%20CSV%20formats%20to%20choose%20from%20such%20Comma%20delimited.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3CP%3EDamien%3C%2FP%3E%3C%2FLINGO-BODY%3E
jetimmer
Microsoft

Is there a way to either export or query form results using some form of automation?

 

Thanks,

Jeffrey J. Timmerman

Site Reliability Engineer

Microsoft

5 Replies
Highlighted

Hi @jetimmer 

 

If your form is a Group form then there should be an Excel file in SharePoint under the Documents library.

 

If the Excel file isn't there, try opening your results in Microsoft Forms and then try again.

 

Could be automated using MS Flow from there as an example.

 

Hope that makes sense?

 

Cheers

Damien

Highlighted

Hi @jetimmer, if you don't want to use the built-in excel spreadsheet of results in Forms, you can use Flow to send each response to a new row in a spreadsheet. Make sure you've formatted your spreadsheet as a table, and then the flow is quite simple as shown in the image below.

Rob
Los Gallardos

Flow.png

 

Highlighted

@Damien Rosario  Hi Damien, I would have to have an export in a .csv file and not an .xlsx file. Is there any way to do that?

Highlighted

@Daniel2019  you could just export it as an excel file then in Excel save as a csv.

Rob
Los Gallardos

 

Highlighted

Hi @Daniel2019 

 

What Rob said is correct. There's a few CSV formats to choose from such Comma delimited.

 

Cheers

Damien

Related Conversations
How can I delete a quick form in teams???
Nigel_Christian in Microsoft Teams on
3 Replies
Apostrophes in my spreadsheet :-(
Brian Donnelly in Microsoft Forms on
3 Replies
Specific Form
Wanen in Access on
0 Replies
A problem with the Zoom level of a Tab
Tavory in Discussions on
9 Replies