# Bulk data update

**URL:** <https://community.glideapps.com/t/bulk-data-update/53233>\
**Category:** Ask for Help\
**Created:** [November 3, 2022, 2:59pm UTC](https://community.glideapps.com/t/bulk-data-update/53233 "2022-11-03T14:59:40Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![jcmaad](https://avatars.discourse-cdn.com/v4/letter/j/ba8739/32.png) [@jcmaad](https://community.glideapps.com/u/jcmaad)\
**Post date:** [November 3, 2022, 2:59pm UTC](https://community.glideapps.com/t/bulk-data-update/53233/1 "2022-11-03T14:59:40Z")

</div>

My client would have to add and remove big chunks of data every now and then. It looks like only Excel or Google Sheets is the only option for me, because Glide Tables doesn’t have that functionality. Am I correct in my assessment?

---

<div class="post-metadata">

**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:** [November 3, 2022, 3:32pm UTC](https://community.glideapps.com/t/bulk-data-update/53233/2 "2022-11-03T15:32:38Z")

</div>

If your client has a Pro Team account or higher, then the Glide Tables API is available.

> **[Glide Tables API](https://www.glideapps.com/docs/reference/data-sources/glide-table-api)**
>
> Explore what you can do with the Glide Tables API

---

<div class="post-metadata">

**Author:** ![jcmaad](https://avatars.discourse-cdn.com/v4/letter/j/ba8739/32.png) [@jcmaad](https://community.glideapps.com/u/jcmaad)\
**Post date:** [November 10, 2022, 1:52pm UTC](https://community.glideapps.com/t/bulk-data-update/53233/3 "2022-11-10T13:52:29Z")

</div>

Thanks. I guess it’s a solution, but not ideal because of the cost and I dont really know how to use APIs.

I tried loading 499 records from Excel data source and the app is extremely slow now, beyond usable. That’s why I hoping to use Glide tables.

---

<div class="post-metadata">

**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:** [November 10, 2022, 1:58pm UTC](https://community.glideapps.com/t/bulk-data-update/53233/4 "2022-11-10T13:58:34Z")

</div>

500 rows is nothing, and certainly shouldn’t cause any slow down.

Do you have any formulas in your Excel sheet?  
If you do, that could explain the slowness. Wherever possible, you should replace any spreadsheet formulas with Glide Computed Columns.

---

<div class="post-metadata">

**Author:** ![jcmaad](https://avatars.discourse-cdn.com/v4/letter/j/ba8739/32.png) [@jcmaad](https://community.glideapps.com/u/jcmaad)\
**Post date:** [November 11, 2022, 3:07am UTC](https://community.glideapps.com/t/bulk-data-update/53233/5 "2022-11-11T03:07:41Z")

</div>

I have an Excel sheet without any formulas. I am pulling three sheets. Two sheets contain foreign IDs. Here is the link: [All About Tire & Wheel](https://allabouttireandwheel.glide.page/dl/dcc150)

its pretty slow, its not snail slow, but slow enough to be annoying.

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [November 11, 2022, 3:11am UTC](https://community.glideapps.com/t/bulk-data-update/53233/6 "2022-11-11T03:11:19Z")

</div>

it should be almost instant… in GS… i did over 150k rows… not a problem

---

<div class="post-metadata">

**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:** [November 11, 2022, 3:11am UTC](https://community.glideapps.com/t/bulk-data-update/53233/7 "2022-11-11T03:11:47Z")

</div>

![Screen Shot 2022-11-11 at 11.09.23 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/f/ff1b573a8d6db587efec0aa5a8790e597e37fb0d.png)

Are the above filter choices writing to [User Specific Columns](https://www.glideapps.com/docs/reference/basic-columns/user-specific-columns)?  
If they are not (and I suspect they are not), then that explains the slowness.  
Change those to use User Specific Columns, and your filter results will be instant.

---

<div class="post-metadata">

**Author:** ![jcmaad](https://avatars.discourse-cdn.com/v4/letter/j/ba8739/32.png) [@jcmaad](https://community.glideapps.com/u/jcmaad)\
**Post date:** [November 11, 2022, 9:49pm UTC](https://community.glideapps.com/t/bulk-data-update/53233/8 "2022-11-11T21:49:37Z")

</div>

There were not connected to anything, I was just playing around with the design. But you are right. I removed and it works faster. Thats good to know. Thank you.
