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
  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 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.

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

  4. 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.

What's next