Skip to main content

Extract

Use the Extract bulk tool to extract multiple entities at once from a column.

For example, you can extract email addresses, company names, phone numbers, and any other specific entities.

Prerequisites
  1. Click GPT for Excel Word in the Home tab. If you don't see it, go to Home > Add-ins > My add-ins > GPT for Excel Word.

  2. Click Extract entities from the Bulk tools tab.



  3. 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. The image shows steps to configure the extract tool

  4. (Optional) Add extraction instructions to provide context or guidance for more accurate results.


  5. Note: Using gpt-3.5-turbo models may result in less accurate results. To achieve enhanced accuracy in following instructions, select the gpt-4 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).