Skip to main content

Extract

Use the Extract bulk tool to extract relevant data from each cell of a given column.

For example, you can extract email addresses, company names, or specific entities.

Prerequisites
  • You have installed GPT for Sheets.
  • You have opened a spreadsheet with data in a single column from which to extract data.
  1. Select Extensions > GPT for Sheets and Docs > Open.

  2. Click Extract entities from the Bulk tools tab.


  3. If you open the Bulk tools for the first time, you are prompted to grant additional permissions. These permissions are required for GPT for Sheets to write in your spreadsheets.
    1. Click Sign-in with Google. A Sign in with Google window opens.
    2. Select the Google account with which you have installed GPT for Sheets.
    3. Click Allow to grant GPT for Sheets the required permissions.

  4. Configure the extract tool to match the data in your sheet:
    1. Enter the data to Extract.
    2. Select the column From which to extract.
    3. Select the column to Put results in.

    4. The image shows steps to select a column to translate, optionally set or auto-detect the source language, specify the target language, and choose a results column.

  5. Note: Using gpt-3.5-turbo models may result in less accurate results. To achieve enhanced accuracy in following instructions, select the gpt-4o model. Learn more.

  6. Select if you want to run a specific number of rows or All rows. Then, click Run rows.

The data is extracted in the selected column.