Forum Discussion

fcosta1029's avatar
fcosta1029
Copper Contributor
May 16, 2024

Gathering Data from Excel Fillable Form into One Master Spreadsheet

Hello,

 

I am not sure if this has been done or if even possible, but I figured I'd ask. We sent out a fillable form that was created in excel for multiple people to fill out. They then email this form back. The issue I am having is trying to find a way to pull data from these forms into one master spreadsheet. Currently, we manually enter this data into a master spreadsheet, but I wasn't sure if there was a way to make this less painful. In short, wanting to gather data from multiple forms (same format, different answers) and compile it into a single spreadsheet. 

  • peiyezhu's avatar
    peiyezhu
    Bronze Contributor
    Ms Form is an online form for collecting information.

    Alternatively,you can consolidate multiple excel files to one sheet by sql or VBA coding.

Resources