Restore deleted column in Web Excel, which is connected to MS Forms

Copper Contributor

I have a MS Forms created from the Excel Spreadsheet in Sharepoint group and while playing with stuff I have deleted the "ID" column in the spreadsheet, thinking it will re-add it after the new response. Unfortunately, it didn't happen and now I am missing "ID" column, which I needed a lot. Is there any workaround or should I build the Forms and Excel from scratch?

1 Reply
I was experimenting with Forms and wanted to know what can be done in similar case. Here's the solution that worked during my tests ("Sync all responses to a new workbook"):
https://support.microsoft.com/en-us/office/how-to-get-missing-data-in-forms-9fb98299-4dcc-41a4-bb29-...

I'm aware that OP might not need answer anymore, but I stumbled upon this thread before finally finding a solution, so I guess it might help someone else.