# Questions about export glide to google sheet

**URL:** <https://community.glideapps.com/t/questions-about-export-glide-to-google-sheet/69270>\
**Category:** Ask for Help\
**Created:** [January 5, 2024, 2:23pm UTC](https://community.glideapps.com/t/questions-about-export-glide-to-google-sheet/69270 "2024-01-05T14:23:04Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Stefania\_Oancea](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/stefania_oancea/32/60457_2.png) [@Stefania\_Oancea](https://community.glideapps.com/u/Stefania_Oancea)\
**Post date:** [January 5, 2024, 2:23pm UTC](https://community.glideapps.com/t/questions-about-export-glide-to-google-sheet/69270/1 "2024-01-05T14:23:05Z")

</div>

Hello, it’s me again:)  
I have 3 questions:  
Is possible to export/synchronize data from glide table to google sheet?  
Can i use filter to see only the information specific to a situations? For example i have a table where my employee introduce information about them and i want to apply a filter(same as google sheet) to see the information about one specific person.  
Is possible to use data validation(like google sheet) in glide table?

---

<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:** [January 5, 2024, 2:30pm UTC](https://community.glideapps.com/t/questions-about-export-glide-to-google-sheet/69270/2 "2024-01-05T14:30:56Z")

</div>

> [@Stefania\_Oancea](#):
>
> Is possible to export/synchronize data from glide table to google sheet?

Yes. You can do it manually by using the export function from the Data Editor, or it could be automated using the Glide API.

> [@Stefania\_Oancea](#):
>
> Can i use filter to see only the information specific to a situations? For example i have a table where my employee introduce information about them and i want to apply a filter(same as google sheet) to see the information about one specific person.

Yes.

> **[Conditions, Filtering, and Visibility | Glide Docs](https://www.glideapps.com/docs/use-cases/conditions-filtering-and-visibility)**
>
> Limit the content displayed in your apps.

> [@Stefania\_Oancea](#):
>
> Is possible to use data validation(like google sheet) in glide table?

Not in the same way as you would in a Google Sheet, but you have various validation options available with Glide forms, and it is possible to create more advanced validation logic with custom forms.

---

<div class="post-metadata">

**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\
**Post date:** [January 5, 2024, 2:36pm UTC](https://community.glideapps.com/t/questions-about-export-glide-to-google-sheet/69270/3 "2024-01-05T14:36:10Z")

</div>

> [@Stefania\_Oancea](#):
>
> Is possible to export/synchronize data from glide table to google sheet?

I would say yes, no, maybe. If the data is in a Glide Table, to get it in a Google Sheet you need to get it there somehow. Either it’s done manually by a user using actions, or manually by you with a CSV export, or with the Glide API. But really, I don’t think it’s advisable to have duplicate data in your application. Glide Tables and Google Sheets are two different sources of data, and a given set of data “should” be in one source or another, not duplicated. Unless you have a terribly good reason to do so. If you absolutely need data in Google Sheets, then leave the data in Google Sheets.

> [@Stefania\_Oancea](#):
>
> For example i have a table where my employee introduce information about them and i want to apply a filter(same as google sheet) to see the information about one specific person.

In Glide, the in-app filter, collection filter or custom filter is generally applied at the layout level. You can also apply filtering at the data level with the `query` column. I would recommend you apply filters at the layout level.

> [@Stefania\_Oancea](#):
>
> Is possible to use data validation(like google sheet) in glide table?

There is no data validation in Glide’s Data Editor like the one in Google Sheets. In the Layout Editor, by using a choice component, you can however limit which data will be written to a cell. It’s a type of data validation but it isn’t presented the same way as in the Google Sheets.

---

<div class="post-metadata">

**Author:** ![Stefania\_Oancea](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/stefania_oancea/32/60457_2.png) [@Stefania\_Oancea](https://community.glideapps.com/u/Stefania_Oancea)\
**Post date:** [January 8, 2024, 8:53am UTC](https://community.glideapps.com/t/questions-about-export-glide-to-google-sheet/69270/4 "2024-01-08T08:53:32Z")

</div>

Can you show me an example for data validation, please?

---

<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:** [January 8, 2024, 9:15am UTC](https://community.glideapps.com/t/questions-about-export-glide-to-google-sheet/69270/5 "2024-01-08T09:15:16Z")

</div>

Basic data validation is available with Glide Forms, when data is added to your App.

Examples include:

- you can make inputs required
- you can set the minimum and maximum allowed values for number entries
- you can set the maximum length of text inputs
- you can restrict input from a fixed list of options with a choice component
- you can restrict date inputs to certain ranges

More advanced data validation is possible, however that requires the use of custom forms, and describing the data validation logic inside the Glide Data Editor.

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [January 15, 2024, 9:16am UTC](https://community.glideapps.com/t/questions-about-export-glide-to-google-sheet/69270/6 "2024-01-15T09:16:13Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.
