Spreadsheet data source rows limit / Free (2025)

Ask for Help
1

Hello everyone,

I know there’s a few posts about this topic already but back 2024 and earlier, and what I encounter now is a bit different so please allow me to create a now post;

  • I have created a free plan in March 2025, and understood that the row limit when importing a google sheet is 500 per table. (even if the pricing page says 25,000).

it’s been working great until … now;

  • my tables are automatically cut off after 99 rows (I have 12 tables and not all of them have more than 99 rows, and none of them have more than 500).

So basically, has the limitation of the Free plan now been increased (from 500 rows / table to 99) ? Or is there something I’ve missed?

note: I’ve tried importing twice to double check, and same results.

Thanks,
Regards,
RL

2

Can you try creating a brand new app and upload the same file? Please let us know how it works on the new app.

3

Alright Thanks, I created a new app, only did the google sheet import so far and yes, all the rows in all the tables are now here.

Thanks,

4

But then, I did an import for a 2nd time (because sometimes I add new info) and the tables are back to being limited at 99 rows :frowning: … sooo, every time I do a google sheet update (re-importing it), I need to create a new app ? or it is a bug and it may be solved ?

Thanks,

5

Does the table you are importing into have a RowID column?
And more importantly, does the data you are attempting to import contain any RowID values?

6

None of them have an RowID column.
So, I added one to 1 table that has more than 99 rows (in fact, 526, just to try its limits).
Their values start from 1 until 525.
I did the import again, and same; it shows the data only up to row 99.

Note; if I manually add a row, i.e. 100, 101 etc.. , then it will show up in the App.
So, it’s really just an import problem.

7

Interesting. I just did a test using a Free Plan, and it works as expected. I started with a Google Sheet that contained 500 rows. Saved it as a CSV file. Imported the CSV into a Glide Table, I got 500 rows. Imported the same file again, and I had 1000 rows. Repeated once again - 1500 rows.

Question - are you importing as CSV?

8

mmmh interesting, no I import a Google Sheet directly.

I tried with saving into an CSV, and importing it. (although it looks like I will have to do it for each table) and well… even with 1150 rows, all of them are shown :scream:

and when I add a table into the layout, it looks like I can see all 1150 rows! (I haven’t published it but I hope it would be the same)…

So, in that case, your suggestion has resolved 2 of my issues :slight_smile:

  • importing won’t limit my table to 99 rows
  • I can show more than 500 rows in my app per table

Thanks sir :man_bowing:

1 Like
9

Okay. The thing about importing a Google Sheet directly is that every time you do that Glide will create a new table. So if you want the data to be added to an existing table, then you do need to import from CSV.

Anyway, glad your problem is sorted :+1:

1 Like