# CSV import and export tables

**URL:** <https://community.glideapps.com/t/csv-import-and-export-tables/68354>\
**Category:** Ask for Help\
**Created:** [December 4, 2023, 7:42pm UTC](https://community.glideapps.com/t/csv-import-and-export-tables/68354 "2023-12-04T19:42:19Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![MattGlides](https://avatars.discourse-cdn.com/v4/letter/m/53a042/32.png) [@MattGlides](https://community.glideapps.com/u/MattGlides)\
**Post date:** [December 4, 2023, 7:42pm UTC](https://community.glideapps.com/t/csv-import-and-export-tables/68354/1 "2023-12-04T19:42:19Z")

</div>

If I wanted to move a subset of my users into their own seperate table, so I do a query to get that subset then export a csv, firstly would that work to then import that csv into a new table? And secondly if there’s 18 columns that I’ve exported but I only need their name, address and number, can I only make those 3 columns then import? Or will I need to make all 18 for the importing to be successful and then delete from there?

---

<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:** [December 4, 2023, 11:41pm UTC](https://community.glideapps.com/t/csv-import-and-export-tables/68354/2 "2023-12-04T23:41:38Z")

</div>

> [@MattGlides](#):
>
> If I wanted to move a subset of my users into their own seperate table

May I ask why you do this instead of using a column to filter them?

---

<div class="post-metadata">

**Author:** ![MattGlides](https://avatars.discourse-cdn.com/v4/letter/m/53a042/32.png) [@MattGlides](https://community.glideapps.com/u/MattGlides)\
**Post date:** [December 5, 2023, 3:51am UTC](https://community.glideapps.com/t/csv-import-and-export-tables/68354/3 "2023-12-05T03:51:51Z")

</div>

Row limit and they have no need to be in Users table in the first place they have no interaction with the app, all I need to pull is their photo + phone no. Hence why I’m curious about how CSV importing works exactly in regards to columns

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [December 5, 2023, 4:17am UTC](https://community.glideapps.com/t/csv-import-and-export-tables/68354/4 "2023-12-05T04:17:24Z")

</div>

I’m not sure, but I would have to think that the columns have to match between the export and the import. I think it would be pretty easy to just test it out and see what works and what doesn’t work.

---

<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:** [December 5, 2023, 11:57pm UTC](https://community.glideapps.com/t/csv-import-and-export-tables/68354/5 "2023-12-05T23:57:36Z")

</div>

> [@MattGlides](#):
>
> Row limit and they have no need to be in Users table in the first place they have no interaction with the app

Please be careful since if you still use those rows somewhere in the app, it would still count against your quota.

Regarding the import part, if you create a new table with just 3 columns, I believe the import file only needs to have 3 columns, otherwise Glide might try to add columns that don’t exist yet. Make sure the names match.