# 500 rows **URL:** \ **Category:** Ask for Help\ **Created:** [April 18, 2021, 11:44pm UTC](https://community.glideapps.com/t/500-rows/25731 "2021-04-18T23:44:28Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![pugmomsf](https://avatars.discourse-cdn.com/v4/letter/p/b19c9b/32.png) [@pugmomsf](https://community.glideapps.com/u/pugmomsf)\ **Post date:** [April 18, 2021, 11:44pm UTC](https://community.glideapps.com/t/500-rows/25731/1 "2021-04-18T23:44:28Z")
I’m trying to see if Glideapps will work for what we need however it says I’ve reached 500 rows and a few things seem to be broken. I really only have maybe a max of 75 data rows so I can’t fathom how I’ve already reached 500. I tried emailing support but it said to just post to this forum. ---
**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\ **Post date:** [April 18, 2021, 11:46pm UTC](https://community.glideapps.com/t/500-rows/25731/2 "2021-04-18T23:46:34Z")
The count is correct. You’re likely using ARRAYFORMULA which is generating rows that look empty in your sheet, but they contain blank values. Delete the empty rows in your sheet. ---
**Author:** ![pugmomsf](https://avatars.discourse-cdn.com/v4/letter/p/b19c9b/32.png) [@pugmomsf](https://community.glideapps.com/u/pugmomsf)\ **Post date:** [April 19, 2021, 12:19am UTC](https://community.glideapps.com/t/500-rows/25731/3 "2021-04-19T00:19:20Z")
Thank you! I didn’t use an arrayformula but with your tip, I did find that my googlesheets was appending records after all these empty rows. Problem solved. ---
**Author:** ![adriasoce](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/adriasoce/32/24153_2.png) [@adriasoce](https://community.glideapps.com/u/adriasoce)\ **Post date:** [April 19, 2021, 8:28am UTC](https://community.glideapps.com/t/500-rows/25731/4 "2021-04-19T08:28:57Z")
Always is a good practice to have the sheets with only and only the rows that are being used and delete the other ones because then you control where Glide is appending the new rows. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [April 19, 2021, 8:59am UTC](https://community.glideapps.com/t/500-rows/25731/5 "2021-04-19T08:59:36Z")
> [@Getting rid of excess rows and/or columns (the easy way)](https://community.glideapps.com/t/getting-rid-of-excess-rows-and-or-columns-the-easy-way/23172): > > Anyone that’s been using Glide for a while will know that it’s generally a good practice to remove excess rows from the bottom of your Google Sheets. But doing so manually can be a bit tedious. This pair of script functions will do the leg work for you. Just run them once in your Google Spreadsheet and they will clean everything up in one quick pass. The following configuration options are available: process.rows : [true|false], whether or not to prune excess rows (default true) process.colu…