# Table data extraction **URL:** \ **Category:** Help\ **Tags:** uiautomation, activities\ **Created:** [August 14, 2019, 10:43am UTC](https://forum.uipath.com/t/table-data-extraction/142089 "2019-08-14T10:43:34Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![shilpa1](https://avatars.discourse-cdn.com/v4/letter/s/8c91f0/32.png) [@shilpa1](https://forum.uipath.com/u/shilpa1)\ **Post date:** [August 14, 2019, 10:43am UTC](https://forum.uipath.com/t/table-data-extraction/142089/1 "2019-08-14T10:43:34Z")
![image](https://global.discourse-cdn.com/uipath/original/3X/d/0/d0a3ffd475436ef2d16d5176d3301fd1856ee107.png) I have table like this I need to extract the values from the table row wise 1 0162564611283 Business 4,91,991.67 4,923.63 12.00% 59,039.00 5,55,954.30 2 0162564611284 Business 4,91,991.67 4,923.63 12.00% 59,039.00 5,55,954.30 3 0162564611285 Economy 1,35,900.00 4,927.30 5.00% 6,795.00 1,47,622.30 4 0162564674314 Business 4,45,991.67 4,923.63 12.00% 53,519.00 5,04,434.30 ---
**Author:** ![Palaniyappan](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/palaniyappan/32/524095_2.png) [@Palaniyappan](https://forum.uipath.com/u/Palaniyappan)\ **Post date:** [August 14, 2019, 10:46am UTC](https://forum.uipath.com/t/table-data-extraction/142089/2 "2019-08-14T10:46:27Z")
Fine we can use DATA SCRAPPING METHOD > **[About Data Scraping](https://docs.uipath.com/studio/v2017.1/docs/about-data-scraping)** > > Data scraping enables you to extract structured data from your browser, application or document to a database, .csv file or even Excel spreadsheet. Structured data is a specific kind of information that is highly organized and is presented in a... –the output of this method will be a datatable variable –we can pass that variable to a for each row activity and we can access the data row by row using assign activity like this **out\_value = row(“yourcolumnname”).ToString** simple isnt it kindly try this and let know for any queries or clarification Cheers @shilpa1 ---
**Author:** ![indra](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/indra/32/34761_2.png) [@indra](https://forum.uipath.com/u/indra)\ **Post date:** [August 14, 2019, 10:47am UTC](https://forum.uipath.com/t/table-data-extraction/142089/3 "2019-08-14T10:47:34Z")
@shilpa1 You can use **Data Scraping** to extract structure data.If you already used can you share what error you are getting. ---
**Author:** ![shilpa1](https://avatars.discourse-cdn.com/v4/letter/s/8c91f0/32.png) [@shilpa1](https://forum.uipath.com/u/shilpa1)\ **Post date:** [August 14, 2019, 10:49am UTC](https://forum.uipath.com/t/table-data-extraction/142089/4 "2019-08-14T10:49:40Z")
data scrapping is for we but this is pdf data ---
**Author:** ![Palaniyappan](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/palaniyappan/32/524095_2.png) [@Palaniyappan](https://forum.uipath.com/u/Palaniyappan)\ **Post date:** [August 14, 2019, 10:50am UTC](https://forum.uipath.com/t/table-data-extraction/142089/5 "2019-08-14T10:50:50Z")
did screen scrapping work on it Cheers @shilpa1 ---
**Author:** ![shilpa1](https://avatars.discourse-cdn.com/v4/letter/s/8c91f0/32.png) [@shilpa1](https://forum.uipath.com/u/shilpa1)\ **Post date:** [August 14, 2019, 11:26am UTC](https://forum.uipath.com/t/table-data-extraction/142089/6 "2019-08-14T11:26:24Z")
to extract each individual value we can’t do scrapping ---
**Author:** ![Palaniyappan](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/palaniyappan/32/524095_2.png) [@Palaniyappan](https://forum.uipath.com/u/Palaniyappan)\ **Post date:** [August 14, 2019, 11:31am UTC](https://forum.uipath.com/t/table-data-extraction/142089/7 "2019-08-14T11:31:08Z")
> [@shilpa1](#): > > to extract each individual i didnt get this statement kindly elaborate a bit more on it Cheers @shilpa1 ---
**Author:** ![shilpa1](https://avatars.discourse-cdn.com/v4/letter/s/8c91f0/32.png) [@shilpa1](https://forum.uipath.com/u/shilpa1)\ **Post date:** [August 16, 2019, 4:42am UTC](https://forum.uipath.com/t/table-data-extraction/142089/8 "2019-08-16T04:42:32Z")
[quote=“shilpa1, post:1, topic:142089”] 1 0162564611283 Business 4,91,991.67 4,923.63 12.00% 59,039.00 5,55,954.30 2 0162564611284 Business 4,91,991.67 4,923.63 12.00% 59,039.00 5,55,954.30 3 0162564611285 Economy 1,35,900.00 4,927.30 5.00% 6,795.00 1,47,622.30 4 0162564674314 Business 4,45,991.67 4,923.63 12.00% 53,519.00 5,04,434.30 I need to extract the individual value and store it in variable and for every time it should loop based on the no of rows ---
**Author:** ![shilpa1](https://avatars.discourse-cdn.com/v4/letter/s/8c91f0/32.png) [@shilpa1](https://forum.uipath.com/u/shilpa1)\ **Post date:** [August 16, 2019, 5:22am UTC](https://forum.uipath.com/t/table-data-extraction/142089/9 "2019-08-16T05:22:47Z")
I’m tying to extract the each value from the table based on the column using loop but its not working