# Raw data for GetAllRows or Extract data from string

**URL:** <https://community.thunkable.com/t/raw-data-for-getallrows-or-extract-data-from-string/114371>\
**Category:** Questions about Thunkable X\
**Created:** [June 20, 2019, 2:43pm UTC](https://community.thunkable.com/t/raw-data-for-getallrows-or-extract-data-from-string/114371 "2019-06-20T14:43:36Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![sysads](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/sysads/32/44975_2.png) [@sysads](https://community.thunkable.com/u/sysads)\
**Post date:** [June 20, 2019, 2:43pm UTC](https://community.thunkable.com/t/raw-data-for-getallrows-or-extract-data-from-string/114371/1 "2019-06-20T14:43:36Z")

</div>

I was wondering how I can see how the actual data from a spreadsheet looks like when using the “GetAllRows” component without having to convert it to json to display as a text.

At the moment, when I try to view it, it shows as [object Object],[object Object] if its 2 rows

or

How do I extract both “lon” and “lat” data from this string:

lat:xxxxxxxxx,lon:xxxxxxxxxxxxx

---

<div class="post-metadata">

**Author:** ![jane](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/jane/32/27575_2.png) [@jane](https://community.thunkable.com/u/jane)\
**Post date:** [June 20, 2019, 3:29pm UTC](https://community.thunkable.com/t/raw-data-for-getallrows-or-extract-data-from-string/114371/2 "2019-06-20T15:29:16Z")

</div>

‘GetAllRows’ returns row objects.  
You need to convert the objects to JSON to view the data stored in the rows.  
You can get specific properties from an object using the [objects](https://docs.thunkable.com/objects) blocks.

---

<div class="post-metadata">

**Author:** ![ioannis](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/ioannis/32/146956_2.png) [@ioannis](https://community.thunkable.com/u/ioannis)\
**Post date:** [November 8, 2024, 12:13pm UTC](https://community.thunkable.com/t/raw-data-for-getallrows-or-extract-data-from-string/114371/3 "2024-11-08T12:13:22Z")

</div>