Gathering Data from Excel Fillable Form into One Master Spreadsheet

Copper Contributor



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. 

1 Reply
Ms Form is an online form for collecting information.

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