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

# POST /v4/spreadsheets/{spreadsheetId}/values:batchClear

`POST /v4/spreadsheets/{spreadsheetId}/values:batchClear`

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

## Path parameters

- `spreadsheetId` string, required

## Request body

- BatchClearValuesRequest — The request for clearing more than one range of values in a spreadsheet.
  - `ranges` string[] — The ranges to clear, in [A1 notation or R1C1 notation](https://developers.google.com/workspace/sheets/api/guides/concepts#cell).

## 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)