# What to use the Clear data from a Google Sheet step for
This step clears the contents of the selected cell range while preserving formatting in a Google sheet. Use this step to clear data stored in a Google sheet rather than deleting rows.
You can use this step to:
- Clear values from a Google Sheet
# How to configure the Clear data from a Google Sheet Step
Select a Google Sheet to clear, or paste its URL here. You can also use 'Insert data' to pass spreadsheet URLs into this step.
# Sheet name
Leave blank to use the first sheet or select a sheet name.
# First cell
Enter a column and row number if you wish to start your write operation from a particular cell in your Google Sheet. For example, 'B10' will mean your bot will start reading data from the second column on the 10th row.
# Last Cell
Enter a column and row number combination if you wish to stop the write operation at a particular cell in your Google Sheet. For example, 'B100' will mean your bot will stop reading data at the 100th-row in the second column.