How to Update, Insert and Delete data

Prev Next

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.

Update Value.png

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.

Insert New Row.png

To Delete a row

There are two ways to delete a row:

  1. Right-click the row header (row number) and select Delete:
    image.png
  2. Select all the columns in the row, including the ID/Key column(s), and press Delete to clear the row:
    Delete Row.png

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