Raw data for GetAllRows or Extract data from string

[sysads]

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

[jane]

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