# List of Column names in a Table with type

**URL:** https://community.glideapps.com/t/list-of-column-names-in-a-table-with-type/75005
**Category:** Ask for Help
**Created:** [July 18, 2024, 7:21pm UTC](https://community.glideapps.com/t/list-of-column-names-in-a-table-with-type/75005 "2024-07-18T19:21:18Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![MattLB](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mattlb/32/41284_2.png) [@MattLB](https://community.glideapps.com/u/MattLB)
#### Post date: [July 18, 2024, 7:21pm UTC](https://community.glideapps.com/t/list-of-column-names-in-a-table-with-type/75005/1 "2024-07-18T19:21:18Z")

</div>

A year ago I asked this question when I had to convert google sheets to Glide tables. Now I need to convert Glide Tables to Glide Big Tables - does this capability exist? Or is there a way to pull the column names/types from Glide via API or some other nuanced way (AI Compute Column 🙂 )

TIA

> [@List of Column names and types for each table in App](https://community.glideapps.com/t/list-of-column-names-and-types-for-each-table-in-app/59416):
>
> I am migrating a bunch of tables from Google to Glide. Anyway to create a list of columns/fields with types for each table? For example below would look something like this: Table: ( W CRUD Baant ) Columns: –\>Budgets - Text –\>Approved - Text –\>… –\>@ Creator - email … for all Glide types such as Templates, LookUps etc Thanks

---

<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: [July 18, 2024, 11:09pm UTC](https://community.glideapps.com/t/list-of-column-names-in-a-table-with-type/75005/2 "2024-07-18T23:09:34Z")

</div>

1. `GET ` `https://functions.prod.internal.glideapps.com/api/apps/APP_ID/tables` gets you all tables for an app
2. `GET ` `https://functions.prod.internal.glideapps.com/api/apps/APP_ID/tables/TABLE_ID/schema` gets all columns for a table

---

<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: [July 19, 2024, 12:14am UTC](https://community.glideapps.com/t/list-of-column-names-in-a-table-with-type/75005/3 "2024-07-19T00:14:42Z")

</div>

@Darren_Alderman I think you asked for this a month ago.

---

<div class="post-metadata">

### Author: ![Darren\_Alderman](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_alderman/32/66660_2.png) [@Darren\_Alderman](https://community.glideapps.com/u/Darren_Alderman)
#### Post date: [July 22, 2024, 2:38pm UTC](https://community.glideapps.com/t/list-of-column-names-in-a-table-with-type/75005/4 "2024-07-22T14:38:41Z")

</div>

Yes! Thanks… Cool project in the works with this. 👍