Resource at url contents exceeded maximum size while using IMPORTDATA function with .CSV file

User Support API
,
1

Getting the error “resource at URL contents exceeded maximum size” with Google sheet while using IMPORTDATA function with .CSV file.
Kindly guide me

image
image1488×567 16.4 KB

2

@anand_peters, have you made your data public to see if that works?

3

Yes I have done the same but still getting the same error, I am sure you are talking about “Any one can view …” right

IMG_20231219_081404
IMG_20231219_0814041240×1843 122 KB

4

Does your data has more than 50,000 rows? This error returns when the size is bigger than that. If that’s the case, this link might have the answer you are looking for: Importing CSV into Google Sheets via Google Script – Bionic Teaching

1 Like
5

Hi right now I have only 900 rows and 125 columns, as data collection progresses the rows will increase to 3000.

I have tried to use the code you have provided but getting an error as shown in the

Access related issue
Access related issue2882×1535 158 KB

image

6

another question then, do you need it to be in Google sheet for a specific reason? Is it fine to work with Microsoft excel? It would be much easier for you to work with Excel

1 Like
7

I have got the data from Kobo to google sheet and prepared a dashboard using Looker Studio, and 45 charts are connected to this googlesheet. so its very important to connect this