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

# GET /v4/spreadsheets/{spreadsheetId}/values:batchGet

`GET /v4/spreadsheets/{spreadsheetId}/values:batchGet`

Returns one or more ranges of values from a spreadsheet. The caller must specify the spreadsheet ID and one or more ranges.

## Path parameters

- `spreadsheetId` string, required

## Query parameters

- `dateTimeRenderOption` 'SERIAL_NUMBER' | 'FORMATTED_STRING'
- `majorDimension` 'DIMENSION_UNSPECIFIED' | 'ROWS' | 'COLUMNS'
- `ranges` string[]
- `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)