# REST Resource: spreadsheets.values

- [Resource: ValueRange](https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets.values#ValueRange)
  - [JSON representation](https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets.values#ValueRange.SCHEMA_REPRESENTATION)
- [Methods](https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets.values#METHODS_SUMMARY)

## Resource: ValueRange

Data within a range of the spreadsheet.

| JSON representation |
|---|
| ``` { "range": string, "majorDimension": enum (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/Dimension`), "values": [ array ] } ``` |

| Fields ||
|---|---|
| `range` | `string` The range the values cover, in [A1 notation](https://developers.google.com/workspace/sheets/api/guides/concepts#cell). For output, this range indicates the entire requested range, even though the values will exclude trailing rows and columns. When appending values, this field represents the range to search for a table, after which values will be appended. |
| `majorDimension` | ``enum (`https://developers.google.com/workspace/sheets/api/reference/rest/v4/Dimension`)`` The major dimension of the values. For output, if the spreadsheet data is: `A1=1,B1=2,A2=3,B2=4`, then requesting `range=A1:B2,majorDimension=ROWS` will return `[[1,2],[3,4]]`, whereas requesting `range=A1:B2,majorDimension=COLUMNS` will return `[[1,3],[2,4]]`. For input, with `range=A1:B2,majorDimension=ROWS` then `[[1,2],[3,4]]` will set `A1=1,B1=2,A2=3,B2=4`. With `range=A1:B2,majorDimension=COLUMNS` then `[[1,2],[3,4]]` will set `A1=1,B1=3,A2=2,B2=4`. When writing, if this field is not set, it defaults to ROWS. |
| `values[]` | ``array (`https://protobuf.dev/reference/protobuf/google.protobuf#list-value` format)`` The data that was read or to be written. This is an array of arrays, the outer array representing all the data and each inner array representing a major dimension. Each item in the inner array corresponds with one cell. For output, empty trailing rows and columns will not be included. For input, supported value types are: bool, string, and double. Null values will be skipped. To set a cell to an empty value, set the string value to an empty string. |

| ## Methods ||
|---|---|
| ### `https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets.values/append` | Appends values to a spreadsheet. |
| ### `https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets.values/batchClear` | Clears one or more ranges of values from a spreadsheet. |
| ### `https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets.values/batchClearByDataFilter` | Clears one or more ranges of values from a spreadsheet. |
| ### `https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets.values/batchGet` | Returns one or more ranges of values from a spreadsheet. |
| ### `https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets.values/batchGetByDataFilter` | Returns one or more ranges of values that match the specified data filters. |
| ### `https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets.values/batchUpdate` | Sets values in one or more ranges of a spreadsheet. |
| ### `https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets.values/batchUpdateByDataFilter` | Sets values in one or more ranges of a spreadsheet. |
| ### `https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets.values/clear` | Clears values from a spreadsheet. |
| ### `https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets.values/get` | Returns a range of values from a spreadsheet. |
| ### `https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets.values/update` | Sets values in a range of a spreadsheet. |