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

• You have installed GPT for Excel Word.
• You have opened a workbook containing text for extraction in a column.

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


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