---
title: "Find and replace values in a sheet"
method: POST
path: "/dataset/{handle}/find-and-replace"
tags: ["data"]
---

# Find and replace values in a sheet

`POST /dataset/{handle}/find-and-replace`

This endpoint will return a new column with original column's name and updated 'found' values while updating original column's name to ‘Original Values - [column name]

## Path parameters

- `handle` string, required

## Request body

- FilesFindAndReplaceRequest
  - `caseSensitive` boolean — Parameters
  - `colIDs` string[], required — Core fields
  - `find` string, required
  - `language` string — e.g 'es' for spanish, default is english
  - `replace` string, required
  - `wholeCellMatch` boolean — default is false

## Response `200`

OK

- unknown

## Other responses

- `400` — Bad Request
- `401` — Unauthorized
- `403` — Forbidden
- `500` — Internal Server Error

---

[API](https://skmtc.net/freshdesk/apis/gigasheet-api.md) · [All operations](https://skmtc.net/freshdesk/apis/gigasheet-api/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/freshdesk/gigasheet-api/versions/d1e5cbb24557/schema)