Forum Discussion

Gemma_Hamer's avatar
Gemma_Hamer
Copper Contributor
Mar 31, 2021

Import historic excel data into new forms

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

microsoft forms
Survey
  • ryan12's avatar
    ryan12
    Brass Contributor
    Feb 02, 2025

    I am using the "formlinker word to form" tool to import data from Excel into Microsoft Forms with one click. You can Google it. However, this requires a question number field, so I'm not sure if your Excel file is suitable.

  • RobElliott's avatar
    RobElliott
    Silver Contributor
    Mar 31, 2021

    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

Resources