# Extracting Data from Tables in Word and Excel

Let's consider the operation of the "Extract Data" button using the Word or Excel applications as an example.

Open Word, create a table, and enter some data into the cells.

![](https://sherparpa.ru/wp-content/uploads/2024/02/ris.1.png)

Click the "Extract Data" button.

![](https://sherparpa.ru/wp-content/uploads/2024/02/ris.2.png)

You are prompted to specify a sample of the data to be extracted. In this case, it is sufficient to point to a cell in the table and press CTRL.

![](https://sherparpa.ru/wp-content/uploads/2024/02/ris.3.png)

The robot extracted all the data from the table. Note: when clicking the "Extract Data" button while working with a browser, the block in the diagram is added in blue. When working with the application, the block is dark blue.

![](https://sherparpa.ru/wp-content/uploads/2024/02/ris.4.png)

The robot understands that the work was performed with different types of applications and different methods of data extraction, and it takes the block from the appropriate data palette. Let us remind you that such blocks are available in the palette for working with desktop applications and for working with browsers.
