Using forms to populate an existing Excel file

Laurens2207 

In teams:

1. I would personal create a teams channel for yourself called Forms data or something like this, you can add people to this as admin if there is someone else assisting with the data ...

2. in that channel add a tab for forms

3. this gives you option to add an existing form ( I would create from scratch tbh thinking of all the stuff you may require on the form) (do not be afraid of testing the forms branching options as this can be really useful tool)

4. this then stores the forms excel in your teams channel files tab.

5. this excel you can edit loads on that will not show on the form, even make dashboards etc. 

6. this enables the form to be edited in that teams channel if you require it too... each edit will add an extra column on excel to end but you can drag the excel columns around without affecting your form

You can add the data from your other workbook to this workbook, as a one off then it will be there but not show on form  

if you was to ever leave business with it been in a teams channel if it had a 2nd and 3rd admin they would still be able to keep this form current in the company.