--- title: "How to Update, Insert and Delete data" slug: "how-to-update-insert-and-delete-data" description: "Learn how you can use the SQL Spreads Excel add-in to insert, update and delete data in your SQL Server database table for non-technical users." updated: 2026-11-05T16:29:06Z published: 2026-11-05T16:29:06Z canonical: "sqlspreads.com/how-to-update-insert-and-delete-data" --- > ## Documentation Index > Fetch the complete documentation index at: https://sqlspreads.com/docs/llms.txt > Use this file to discover all available pages before exploring further. # How to Update, Insert and Delete data ### 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](https://cdn.document360.io/ad9d65b3-9cdd-4b28-8cb8-86cb149873bc/Images/Documentation/Update%20Value.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](https://cdn.document360.io/ad9d65b3-9cdd-4b28-8cb8-86cb149873bc/Images/Documentation/Insert%20New%20Row.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](https://cdn.document360.io/ad9d65b3-9cdd-4b28-8cb8-86cb149873bc/Images/Documentation/image%28223%29.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](https://cdn.document360.io/ad9d65b3-9cdd-4b28-8cb8-86cb149873bc/Images/Documentation/Delete%20Row.png) Then click **Save** in the SQL Spreads panel to delete the row in your SQL database.