In the Settings tab of the SQL Spreads Designer, you decide for each table whether users can delete rows, insert new rows, or only add new rows. The settings are saved in the Excel document, so they apply wherever you share it.

You find the Designer Setting in the right most Settings tab in the SQL Spreads Designer.
Allow Delete Rows
Uncheck the Allow Delete Rows to prevent users from being able to delete rows in the table.
Allow Insert new rows
Uncheck the Allow Insert new rows to prevent users from being able to insert new rows in the table.
Only allow inserting new rows
To only allow users to insert new rows, check the Only allow inserting new rows checkbox.
This setting will clear the spreadsheet after new rows have been saved to the database, and will prevent users from modifying or deleting any existing rows in the table.
Related settings
To lock single columns, hide them, or set them to read-only in Setting up your columns. To decide which rows each user sees, see the fixed setup in Filtering rows, or Row-wise user access for a user access table. For an overview of both roles, see The Designer and Data Editor roles.