# Need Help Arranging Google Sheets Data From A Web API Into Local Table

**URL:** <https://community.thunkable.com/t/need-help-arranging-google-sheets-data-from-a-web-api-into-local-table/3029494>\
**Category:** Web API's\
**Tags:** beginner, help, google-sheets\
**Created:** [May 28, 2024, 2:49pm UTC](https://community.thunkable.com/t/need-help-arranging-google-sheets-data-from-a-web-api-into-local-table/3029494 "2024-05-28T14:49:06Z")\
**Posts on this page:** 1\
**Showing post:** 7

<div class="post-metadata">

**Author:** ![8bitretrofishep](https://avatars.discourse-cdn.com/v4/letter/8/7feea3/32.png) [@8bitretrofishep](https://community.thunkable.com/u/8bitretrofishep)\
**Post date:** [May 30, 2024, 3:30pm UTC](https://community.thunkable.com/t/need-help-arranging-google-sheets-data-from-a-web-api-into-local-table/3029494/7 "2024-05-30T15:30:32Z")

</div>

It has been converted to a CSV to bring the data in as a WebAPI. With the idea of taking that data in some way to put into a local table.

I saw this thread with a similar problem to myself, but they are working with variables and the project example is unviewable for myself.

I’ve also tried implementing the list block as you said but not sure how it fits.

> [@\[Solved\] Stuck with formatting csv elements](https://community.thunkable.com/t/solved-stuck-with-formatting-csv-elements/545961):
>
> Hye all I’m building an app where I read data from my online database. Data is exported as csv so the app can read it. I’m able tot get all the rows and read them as row. Also able to select 1 row from the result list. But I’m stuck when I want to split this row into pieces. So, started with reading and used delimiter “newline”. Selected a row (testing purpose atm) tryed to format this row with delimiter “,”. But that gives no result at all. Not with data from database, not with testlist…

---

_[View the full topic](https://community.thunkable.com/t/need-help-arranging-google-sheets-data-from-a-web-api-into-local-table/3029494)._
