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

# GET /v4/spreadsheets/{spreadsheetId}/values/{range}

`GET /v4/spreadsheets/{spreadsheetId}/values/{range}`

Returns a range of values from a spreadsheet. The caller must specify the spreadsheet ID and a range.

## Path parameters

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

## Query parameters

- `dateTimeRenderOption` 'SERIAL_NUMBER' | 'FORMATTED_STRING'
- `majorDimension` 'DIMENSION_UNSPECIFIED' | 'ROWS' | 'COLUMNS'
- `valueRenderOption` 'FORMATTED_VALUE' | 'UNFORMATTED_VALUE' | 'FORMULA'

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