Forum Discussion
Using forms to populate an existing Excel file
Hi everyone, I have a question related to forms. I work in Teams on a excel file (name: File A) that I need my team to populate with data. Now File A is quite big (and for outsiders a bit messy :...
I was looking into this same issue and found an alternative solution. Forms for Excel.
In the appropriate Sharepoint (or OneDrive) folder online create a new file called Forms for Excel (using the New button). It will be tied to the created Form and live updated based on the form submissions. Unfortunately, I believe Forms for Excel can only be added to a new Excel file but you can copy over any old info from your current Excel file.
More info about creating Forms for Excel on this video. They talk about Microsoft Forms vs Forms for Excel. The Forms for Excel part starts at 3:00 if you want to skip ahead. This is not my video, just the simplest most to the point one I could find quickly.
https://www.youtube.com/watch?v=qbvjYjZyQBY