Import historic excel data into new forms

%3CLINGO-SUB%20id%3D%22lingo-sub-2246865%22%20slang%3D%22en-US%22%3EImport%20historic%20excel%20data%20into%20new%20forms%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2246865%22%20slang%3D%22en-US%22%3E%3CP%3EHey%20Community%26nbsp%3B%3CIMG%20class%3D%22lia-deferred-image%20lia-image-emoji%22%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Fhtml%2F%408341BD79091AF36AA2A09063B554B5CD%2Fimages%2Femoticons%2Fsmile_40x40.gif%22%20alt%3D%22%3Asmile%3A%22%20title%3D%22%3Asmile%3A%22%20%2F%3E%3C%2FP%3E%3CP%3EWe%20have%20previously%20used%20smartsurvey%20to%20collect%20responses%20to%20questionnaires%2C%20we%20are%20now%20using%20MS%20Forms.%20Does%20anyone%20know%20if%20you%20can%20import%20historic%20data%20in%20an%20excel%20into%20our%20new%20Forms%20so%20we%20can%20have%20a%20collective%20view%20on%20all%20the%20data%3F%20Many%20thanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2246865%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Forms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Esurvey%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Hey Community :smile:

We have previously used smartsurvey to collect responses to questionnaires, we are now using MS Forms. Does anyone know if you can import historic data in an excel into our new Forms so we can have a collective view on all the data? Many thanks

2 Replies

@Gemma_Hamer unfortunately Forms will ignore the data you have imported into the backend spreadsheet, at least as far as the ID numbers are concerned and will not include them in the graphs & charts. We always use a flow in Power Automate to copy the responses into a SharePoint list. And if you then paste in historic data the list can still process it from within SharePoint.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

@RobElliott thank you very much for your reply :)