Hi,
thanks for your question, and sorry for the trouble.
Unfortunately, I’ll have to disappoint you here. I don’t really see a possibility to achieve this with TablePress.
While it should be manageable to import that spreadsheet into TablePress, and to make it look the same as the actual spreadsheet (at least to some degree, by using CSS code to change the font size and styling, etc.), it is not possible to edit TablePress tables from the frontend.
There’s also no such thing in TablePress like user logins or forms from which a user can submit new data that is then added to a table.
TablePress is more like a static table display plugin, but not a full-featured database replacement system. For your idea, you will therefore need to find a different solution, maybe based on “Google Forms” and the spreadsheet, or maybe with a totally custom PHP/mySQL solution.
Sorry for not having better news.
Regards,
Tobias
