To Update a value
Change the values in the cells in Excel and then click “Save” in the SQL Spreads user panel to save the changes back to your SQL database.

To Insert a new row
Add the new row in Excel just after the last row of data. Then click “Save” in the SQL Spreads user panel to save the new row back to your SQL database.

To Delete a row
There are two ways to delete a row:
- Right-click the row header (row number) and select Delete:

- Select all the columns in the row, including the ID/Key column(s), and press Delete to clear the row:

Then click Save in the SQL Spreads panel to delete the row in your SQL database.