Linking multiple Forms to one Excel file

Question

I would need to link three Forms in one Excel file -- is there any way of doing this? I thought of just creating a new Form linked to a different Excel document, so then I can sync that new sheet to the original Excel document, but I believe that's not an option in Excel online (Office 365). 

Thanks in advance!

Answer 1

Hi Soledad Olguin,

Here is a related thread for your reference: Multiple Forms Depositing Data into the Same Sheet?

You can refer to the steps mentioned by Rena to link the results of your three forms into one workbook using data connection.

Data tab> Get Data> From File> From Workbook>Select the workbook that you want to connect the data from>Import>Select the sheet that you want to import data from

(Data connection in not available in Excel Online)

In addition, I would suggest you vote for this suggestion in Forms UserVoice:

Allow multiple forms to be assigned to single workbook as separate sheets.

Thanks for your understanding.

Best Regards,

Gloria