---
title: "Search and replace data"
slug: "searching-and-replacing-data"
updated: 2026-06-02T13:36:04Z
published: 2026-06-02T13:36:04Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://help.quickbase.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Search and replace data

Often you'll want to replace a field's value or an instance of a term across many records at once.

To search and replace data:

1. Create (or open) a [table report](/v1/docs/what-is-a-table-report) that contains all the records you want to modify.
2. Choose **More > Find/Replace in these records** from the Page bar. ![Find/Replace option in the More menu on the page bar](https://cdn.document360.io/dd260e4e-10bb-4b66-8fb3-5504c272b904/Images/Documentation/19036569784596.png)
3. From the **In the field** dropdown, select the field that you want to search.
4. Tell Quickbase what term or value you want to find. Depending on the type of field you selected in the previous step, do one of the following:
  - In the **Change** field, enter the text you want to find.
  - In the **Change** field, select **Select Value**. A list of items displays. Pick the one you want to find and select **OK**.
5. Tell Quickbase what should replace the found value. Depending on the type of field you selected in the previous step, do one of the following:

![Find and Replace dialog showing Change and To fields](https://cdn.document360.io/dd260e4e-10bb-4b66-8fb3-5504c272b904/Images/Documentation/4572831563028.png)
  - In the **To** field, enter the text you want to appear in place of the text Quickbase finds.
  - In the **To** field, select **Select Value**. A list of items displays. Pick the one that you want to replace the found value and select **OK**.
6. Select **Next**.

Quickbase displays a message telling you how many records the operation will change.
7. Select **Replace**.

To see the results of this action, you must refresh or reload the page in your browser window.

> [!NOTE]
> Note: If you don't have permission to modify all the records in a specific report, then only those records that you do have permission to modify will be changed.

> [!NOTE]
> Note: You can remove a term by searching for it and replacing it with nothing (leave the **To** box blank)