Hi @Scott_Wightman,
Hopefully I can help with this somewhat.
Firstly, in your Excel data source, I assume you have a sheet with a table, and that table has headers relating to each column.
From here, in your app you need to go to Insert > Forms > Edit.
You will see an empty square, and a prompt saying that it needs to be connected to a data source. This is where you connect it to your excel table. If you have not connected your app to your table, you can do so here. On the right side of the screen, there is the properties panel. You can select a data source from a drop down here, or add a new one.
You will be prompted to add fields. Add in the fields you want to populate using your app by selecting them from the Fields menu. The form will now have data cards, and each data card relates to a field from your table. You can add controls in to the data cards which will in-turn update that particular column. For example, you can add a text input control to your Name data card which will update that column when submitted. There will be one by default in your data cards.
On a side note, if you want to do this and have the form collect the user's name automatically without their input, set the Default value of this text input to Users().FullName, or something of that nature.
The Update property of any data cards should point to the relevant control in that data card. You could also, if using checkboxes or toggles, have the update property depend on that value. For example If(Checkbox1.Value=true,"Yes","No").
From there, if you change the Default Mode to New, the form will be ready to add new data to your data source.
Once you have added your controls to your form, the submit button should have an OnSelect property of SubmitForm().
