# Spreadsheet Editor

**URL:** <https://community.glideapps.com/t/spreadsheet-editor/15030>\
**Category:** Ask for Help\
**Created:** [August 31, 2020, 9:23pm UTC](https://community.glideapps.com/t/spreadsheet-editor/15030 "2020-08-31T21:23:26Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![AugustoMiguel](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/augustomiguel/32/47516_2.png) [@AugustoMiguel](https://community.glideapps.com/u/AugustoMiguel)\
**Post date:** [August 31, 2020, 9:23pm UTC](https://community.glideapps.com/t/spreadsheet-editor/15030/1 "2020-08-31T21:23:26Z")

</div>

Is there a way of edit a spreadsheet data via app ?  
If **Yes**.Is this count as **Sheet edits**?

I have a List of data that i want to edit daily !!

---

<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:** [August 31, 2020, 9:54pm UTC](https://community.glideapps.com/t/spreadsheet-editor/15030/2 "2020-08-31T21:54:03Z")

</div>

Components like text entry, number entry, choice etc. that interacts directly with data do trigger sheet edits, as far as I aware.

---

<div class="post-metadata">

**Author:** ![AugustoMiguel](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/augustomiguel/32/47516_2.png) [@AugustoMiguel](https://community.glideapps.com/u/AugustoMiguel)\
**Post date:** [September 1, 2020, 12:07am UTC](https://community.glideapps.com/t/spreadsheet-editor/15030/3 "2020-09-01T00:07:50Z")

</div>

Thanks for the reply ThinhDinh.  
But if I you those components… would they count as editing the sheet?  
Or not really?

Everytime I edit manually they count…

If not… How could I interact with specif rows in my data base?

---

<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 1, 2020, 12:16am UTC](https://community.glideapps.com/t/spreadsheet-editor/15030/4 "2020-09-01T00:16:41Z")

</div>

As long as you initiate an interaction between Glide and your sheet, it counts as an edit. Glide must take the latest data from your sheet to be able to display it on the app. How would you expect that to work any other way?

---

<div class="post-metadata">

**Author:** ![Ralf](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ralf/32/492_2.png) [@Ralf](https://community.glideapps.com/u/Ralf)\
**Post date:** [January 30, 2021, 11:10am UTC](https://community.glideapps.com/t/spreadsheet-editor/15030/5 "2021-01-30T11:10:09Z")

</div>

@ThinhDinh

Quoting Mark:  
Jul '20 - “Sheet Edits” does not limit data being written to the spreadsheet by Glide, it only limits data being read from the spreadsheet back into Glide. We discussed calling it “Sheet Reloads”, but we thought “Sheet Edits” was more understandable.  
Unquote

I am feeding the spreadsheet from a choice component. Since the component data resides in the spreadsheet the edits count is in play.

Is there a way to put the choice data in the data editor to avoid an interaction with the spreadsheet?

---

<div class="post-metadata">

**Author:** ![Mishta\_P](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mishta_p/32/16900_2.png) [@Mishta\_P](https://community.glideapps.com/u/Mishta_P)\
**Post date:** [January 30, 2021, 12:07pm UTC](https://community.glideapps.com/t/spreadsheet-editor/15030/6 "2021-01-30T12:07:07Z")

</div>

You can host the data in a glide table rather than a sheet that relates/links back to a google sheet.

---

<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:** [January 30, 2021, 12:21pm UTC](https://community.glideapps.com/t/spreadsheet-editor/15030/7 "2021-01-30T12:21:17Z")

</div>

Either the way @Mishta_P suggested above, or you can write the choice component to a user specific column.

---

<div class="post-metadata">

**Author:** ![Ralf](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ralf/32/492_2.png) [@Ralf](https://community.glideapps.com/u/Ralf)\
**Post date:** [January 30, 2021, 1:15pm UTC](https://community.glideapps.com/t/spreadsheet-editor/15030/8 "2021-01-30T13:15:27Z")

</div>

Works fine, thank you!
