# \[How To\] Quickly Delete a LARGE number of rows

**URL:** <https://community.glideapps.com/t/how-to-quickly-delete-a-large-number-of-rows/31325>\
**Category:** Ask for Help\
**Created:** [September 3, 2021, 3:26pm UTC](https://community.glideapps.com/t/how-to-quickly-delete-a-large-number-of-rows/31325 "2021-09-03T15:26:26Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![ChaseFlorell](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/chaseflorell/32/30932_2.png) [@ChaseFlorell](https://community.glideapps.com/u/ChaseFlorell)\
**Post date:** [September 3, 2021, 3:26pm UTC](https://community.glideapps.com/t/how-to-quickly-delete-a-large-number-of-rows/31325/1 "2021-09-03T15:26:26Z")

</div>

Ok, so I created an app and made it public with signup. Within 7 days I had over 30,000 people sign up for access. I quickly ran out of row space and began seeing some performance degradation… well, to the point that the app wouldn’t even load. So, after submitting a ticket to support, I was told that I needed to get my row-count down to a manageable level… but here’s the rub. I can’t simply [ctrl] + [a] + [delete] because there are relationships and things in there… I need to preserve users that have input data, but I can safely delete all the lookie-loos and if they come back, they’ll just get a new row.

Ok so… How did I bulk delete 30,000 rows without corrupting my data?

1. In your editor, create a hidden page with a normal list and filter it on only display the records that are safe to delete.  
a. this filter is specific to you and your needs. I claim no liability for lost data.  
b. I can’t believe we live in an age where I have to add a disclaimer ☹
2. set the action on that list to “Delete Row”
3. Install an app like [Auto Mouse Click](http://www.murgaa.com/mac-auto-mouse-click/)
4. Setup a shortcut to start/stop (I used `[cmd]+[z]`)
5. Hover your mouse over the top row delete button and start the auto clicker.

For best results, run this on a separate computer so that your primary machine is free to continue work.

NOTE: This trick can be used to migrate data, or really anything you want to automate when operating against a large number of rows.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [September 4, 2021, 12:01am UTC](https://community.glideapps.com/t/how-to-quickly-delete-a-large-number-of-rows/31325/2 "2021-09-04T00:01:50Z")

</div>

Thanks for sharing!

Here’s an alternative way to do this.

> [@robot Importing data to Glide by use of robot (RPA)](https://community.glideapps.com/t/importing-data-to-glide-by-use-of-robot-rpa/29008/):
>
> Challenge 1 In this moment of time it is not possible to import data (or paste chunks of data) into Glide. @Manu.n has shown a way to import a row at a time from Google sheets to Glide tables which is quite handy if you have not to much data to import. But if you have hundreds or thousands of rows this approach is not the way to go. 
> 
> > **Manu.n's approach - great for a smaller number of rows**
> >
> > \<a href="https://community.glideapps.com/t/import-data-from-excel-sheets-into-glide-table/20184/…