Extract

Use the Extract bulk tool to extract relevant information 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 containing a single column with text.

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 entity names with the text in your sheet:
   1. Enter the name of an entity to Extract.
   2. (Optional) Click the + button to add more entity names if needed.
   3. Select the column From which to extract.
   4. Select the column(s) to Put results in.
   
   
   
   
5. (Optional) Add extraction instructions to provide context or guidance for more accurate results.



Note: 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 entities are extracted in the selected column(s).

What's next

Check our extraction best practices.