### Author:  [@Mark\_Bailey](https://community.glideapps.com/u/Mark_Bailey)
#### Post date: [February 14, 2024, 10:15am UTC](https://community.glideapps.com/t/export-filtered-data/70815/1 "2024-02-14T10:15:39Z")
Hi there,
I’m looking to export filtered table data on a page.
The issue I’m facing is that the export functionality only exports the full table (from the backend) and not the filtered data that’s shown on the UI.
Can anyone provide exact steps,
Cheers
Mark
---
### Author:  [@Lucas\_Malguy1](https://community.glideapps.com/u/Lucas_Malguy1)
#### Post date: [February 14, 2024, 1:39pm UTC](https://community.glideapps.com/t/export-filtered-data/70815/2 "2024-02-14T13:39:04Z")
In your CSV action you can choose the source, meaning the data you’re to going to export as CSV. Even if you have filters applied, they are only applied in the front end, the entire data set will be downloaded as a CSV.
You would need, in your glide table, to add a query column, and filter only the desired element, the in the CSV action, use your query as source. Then the CSV will only have data from the query.
If it’s not a static export, meaning your criteria for the export change in time, you will need to use a custom filter. Robert Petitto made some great videos about it, Ill see if I can find them.
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [February 14, 2024, 2:50pm UTC](https://community.glideapps.com/t/export-filtered-data/70815/3 "2024-02-14T14:50:19Z")
It’s most likely not a “static export” per Lucas’ definition above, since you allow users to filter them on the front end. You can get started with this.
> [@tornado Use Multiple Choice Components to Filter an Inline List](https://community.glideapps.com/t/use-multiple-choice-components-to-filter-an-inline-list/16932):
>
> [[Glide: Filter an Inline List with Choice Components] ](https://www.youtube.com/watch?v=NOYFsVUWQXw) Updated July 2022
>
> > **Version 1**
> >
> > \https://www.youtube.com/watch?v=rtbFccDKuH0\
---
### Author:  [@albertoalfaro](https://community.glideapps.com/u/albertoalfaro)
#### Post date: [June 7, 2024, 3:25pm UTC](https://community.glideapps.com/t/export-filtered-data/70815/4 "2024-06-07T15:25:39Z")
did you manage to do it @Mark_Bailey ? I so, could I get help from you?
I am looking to do the same with my app. My problem is that my data base is large and a lot of filters.
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [June 8, 2024, 12:08am UTC](https://community.glideapps.com/t/export-filtered-data/70815/5 "2024-06-08T00:08:04Z")
How many filters are we talking about here?
---
### Author:  [@albertoalfaro](https://community.glideapps.com/u/albertoalfaro)
#### Post date: [June 9, 2024, 4:37pm UTC](https://community.glideapps.com/t/export-filtered-data/70815/6 "2024-06-09T16:37:38Z")
I am using 6 filters, created with the in-app functionality
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [June 9, 2024, 4:53pm UTC](https://community.glideapps.com/t/export-filtered-data/70815/7 "2024-06-09T16:53:52Z")
In-app filtering only applies to the collection itself on the front end. You can’t use it to filter anything in the back end for export. You would have to build your own custom filters.
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [June 9, 2024, 11:40pm UTC](https://community.glideapps.com/t/export-filtered-data/70815/8 "2024-06-09T23:40:15Z")
As long as you build your custom filter correctly, you will be able to generate a CSV through a query with those filters, and allow the user to download that file.
> [@eyes Multiple Custom Filters in Glide Pages (How to)](https://community.glideapps.com/t/multiple-custom-filters-in-glide-pages-how-to/53035):
>
> How to Add Multiple Custom Filters to Glide Pages 0:00 How to Filter Collections & Lists in Glide 2:25 How to Add Custom Filters in Glide 7:25 How to Add a Custom Search Box in Glide [[How to Add Custom Filters to @glideapps Pages] ](https://www.youtube.com/watch?v=6C5pfmEzb8o) Also bookmark it in Glide University point_down
---
### Author:  [@Darren\_Alderman](https://community.glideapps.com/u/Darren_Alderman)
#### Post date: [June 12, 2024, 1:03pm UTC](https://community.glideapps.com/t/export-filtered-data/70815/9 "2024-06-12T13:03:15Z")
@ThinhDinh Recently I was unsuccessful with trying to export a subset of data stored in a Big Table. Do you know if that’s a known limitation?
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [June 12, 2024, 2:14pm UTC](https://community.glideapps.com/t/export-filtered-data/70815/10 "2024-06-12T14:14:42Z")
I haven’t found anything that can cause the problem. Does it not export at all or there’s missing data?
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [June 13, 2024, 7:24am UTC](https://community.glideapps.com/t/export-filtered-data/70815/11 "2024-06-13T07:24:28Z")
What method were you using?
The Generate CSV integration isn’t supported with Big Tables, but there are other approaches that can be used. Three separate methods that I’ve had success with:
- The traditional joined list via a relation/query. Works okay but could be limited to 100 rows depending on any computed column types involved.
- A joined list of joined lists, then use JavaScript to generate the CSV.
- Use the Glide API to run a query from Make, then generate the CSV on the Make side. This is a pretty robust method, but can only be used if you are filtering on non-computed columns. I helped Jack make a video that describes this method, see below:
[ ](https://www.youtube.com/watch?v=Wr2Zk6k4YSw)
---
### Author:  [@l3oy8231](https://community.glideapps.com/u/l3oy8231)
#### Post date: [August 3, 2024, 9:07am UTC](https://community.glideapps.com/t/export-filtered-data/70815/12 "2024-08-03T09:07:35Z")
> [@Darren\_Murphy](#):
>
> Use the Glide API to run a query from Make
Do you have detailed instructions for setting up scenarios on [Make.com](http://Make.com)? I watched a video, but I didn’t quite understand how to set up scenarios in [Make.com](http://Make.com)
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [August 3, 2024, 9:49am UTC](https://community.glideapps.com/t/export-filtered-data/70815/13 "2024-08-03T09:49:55Z")
That video that I linked to in my previous reply describes how it’s done. Where exactly did you get stuck?
Here is a screen shot of one of my scenarios that does a CSV export:
The essential pieces of it are:
- The webhook that comes from Glide and contains the Query JSON, and what ever other information is required. In my case, the email address of the user that triggered the action in Glide.
- A HTTP module to Query the Big Table via the API
- An Iterator to process the returned rows one by one
- A CSV module to map the columns to appropriate CSV fields
- An Array Aggregator to bundle the CSV rows up into a single text string
- And then some sort of email module to send the CSV to the user (in my case I’m using Office365)
---
### Author:  [@rayo](https://community.glideapps.com/u/rayo)
#### Post date: [March 6, 2025, 8:22am UTC](https://community.glideapps.com/t/export-filtered-data/70815/14 "2025-03-06T08:22:40Z")
What was the update cost approx of such a scenario considering the final csv had 1000 rows of data?
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [March 6, 2025, 9:23am UTC](https://community.glideapps.com/t/export-filtered-data/70815/15 "2025-03-06T09:23:05Z")
It’s just a single API call, so it would be 1 update.