# How can I generate a CSV file from a filtered search? **URL:** \ **Category:** Ask for Help\ **Created:** [February 27, 2024, 9:19pm UTC](https://community.glideapps.com/t/how-can-i-generate-a-csv-file-from-a-filtered-search/71226 "2024-02-27T21:19:21Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Rimatcom](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rimatcom/32/32285_2.png) [@Rimatcom](https://community.glideapps.com/u/Rimatcom)\ **Post date:** [February 27, 2024, 9:19pm UTC](https://community.glideapps.com/t/how-can-i-generate-a-csv-file-from-a-filtered-search/71226/1 "2024-02-27T21:19:21Z")
For example, I have a table called “operations” with multiple rows, and I know I can convert them into a .CSV file. However, the issue I have is that I don’t want the ENTIRE table to be converted to .CSV, but only the entries between dates that the user has previously chosen. Is this possible? ---
**Author:** ![DarrenHumphries](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darrenhumphries/32/91715_2.png) [@DarrenHumphries](https://community.glideapps.com/u/DarrenHumphries)\ **Post date:** [February 27, 2024, 9:25pm UTC](https://community.glideapps.com/t/how-can-i-generate-a-csv-file-from-a-filtered-search/71226/2 "2024-02-27T21:25:10Z")
You can create a CSV from a relation or query column. If you already have a relation or query set up you will see them as options when you create the action. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/3/53b45ce0f4b5b1d14f0ef763d78751448135e744.png) ---
**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:** [February 27, 2024, 11:44pm UTC](https://community.glideapps.com/t/how-can-i-generate-a-csv-file-from-a-filtered-search/71226/3 "2024-02-27T23:44:16Z")
You can combine the approach I mentioned in another thread with what Darren suggested above. > [@Collection's Filter view](https://community.glideapps.com/t/collections-filter-view/71231/2): > > Do you mean 2 fields where you can add timestamps/datestamps in? That’s a no. For that type of functionality, you would need to create your own filter by on-screen date components writing to user-specific columns, and then use those values to filter your collection. ---
**Author:** ![vedant01](https://avatars.discourse-cdn.com/v4/letter/v/22d042/32.png) [@vedant01](https://community.glideapps.com/u/vedant01)\ **Post date:** [March 1, 2024, 5:40pm UTC](https://community.glideapps.com/t/how-can-i-generate-a-csv-file-from-a-filtered-search/71226/4 "2024-03-01T17:40:46Z")
I am dealing with a similar problem, except I am trying to only show active users from a user table. For each user there is a column indicating if they are active or not, and while I can filter the user table to only show active users in a collection, I am unable to do so with a CSV. How could using a relation help here, since I am referencing the same table, not a relation to another table. ---
**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:** [March 1, 2024, 5:42pm UTC](https://community.glideapps.com/t/how-can-i-generate-a-csv-file-from-a-filtered-search/71226/5 "2024-03-01T17:42:38Z")
Have you tried it? ---
**Author:** ![vedant01](https://avatars.discourse-cdn.com/v4/letter/v/22d042/32.png) [@vedant01](https://community.glideapps.com/u/vedant01)\ **Post date:** [March 1, 2024, 5:52pm UTC](https://community.glideapps.com/t/how-can-i-generate-a-csv-file-from-a-filtered-search/71226/6 "2024-03-01T17:52:12Z")
Oh sorry, I see that I can also do this with a query not just relation. I just tested it with a query and I believe it works as I had wanted it to. ---
**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:** [March 8, 2024, 5:52pm UTC](https://community.glideapps.com/t/how-can-i-generate-a-csv-file-from-a-filtered-search/71226/7 "2024-03-08T17:52:16Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.