---
title: "POST /v4/spreadsheets/{spreadsheetId}/values/{range}:clear"
method: POST
path: "/v4/spreadsheets/{spreadsheetId}/values/{range}:clear"
tags: ["spreadsheets"]
---

# POST /v4/spreadsheets/{spreadsheetId}/values/{range}:clear

`POST /v4/spreadsheets/{spreadsheetId}/values/{range}:clear`

Clears values from a spreadsheet. The caller must specify the spreadsheet ID and range. Only values are cleared -- all other properties of the cell (such as formatting, data validation, etc..) are kept.

## Path parameters

- `spreadsheetId` string, required
- `range` string, required

## Request body

- ClearValuesRequest — The request for clearing a range of values in a spreadsheet.

## Response `200`

Successful response

---

[API](https://skmtc.dev/google/apis/sheets.md) · [All operations](https://skmtc.dev/google/apis/sheets/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/google/sheets/revisions/89de4914a876/schema)