# Create a new table with user specific column based on imported data

**URL:** https://community.glideapps.com/t/create-a-new-table-with-user-specific-column-based-on-imported-data/73902
**Category:** Ask for Help
**Created:** [June 5, 2024, 7:06pm UTC](https://community.glideapps.com/t/create-a-new-table-with-user-specific-column-based-on-imported-data/73902 "2024-06-05T19:06:31Z")
**Posts on this page:** 8
**Page:** 1

<div class="post-metadata">

### Author: ![Krivo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/krivo/32/5363_2.png) [@Krivo](https://community.glideapps.com/u/Krivo)
#### Post date: [June 5, 2024, 7:06pm UTC](https://community.glideapps.com/t/create-a-new-table-with-user-specific-column-based-on-imported-data/73902/1 "2024-06-05T19:06:31Z")

</div>

Is there any way to create a new table based on imported data where the columns are user specific. The data isn’t actually used but will be replaced as the table is a helper table

This will make creating a new table a lot easier.

---

<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: [June 6, 2024, 12:02am UTC](https://community.glideapps.com/t/create-a-new-table-with-user-specific-column-based-on-imported-data/73902/2 "2024-06-06T00:02:41Z")

</div>

How would you import the data?

---

<div class="post-metadata">

### Author: ![Krivo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/krivo/32/5363_2.png) [@Krivo](https://community.glideapps.com/u/Krivo)
#### Post date: [June 6, 2024, 5:12am UTC](https://community.glideapps.com/t/create-a-new-table-with-user-specific-column-based-on-imported-data/73902/3 "2024-06-06T05:12:42Z")

</div>

@ThinhDinh i would use the import function in the data editor. And there I would select an excel sheet xlxs

---

<div class="post-metadata">

### Author: ![Pratik\_Shah](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pratik_shah/32/12416_2.png) [@Pratik\_Shah](https://community.glideapps.com/u/Pratik_Shah)
#### Post date: [June 6, 2024, 8:29am UTC](https://community.glideapps.com/t/create-a-new-table-with-user-specific-column-based-on-imported-data/73902/4 "2024-06-06T08:29:45Z")

</div>

I think there is no way to have columns as user specific unless we add it one by one.

In fact, I also want to create Helper table by duplicating existing table but I think it is not possible in that way. Even when you duplicate existing helper table with all User specific fields, it will still be normal fields.

---

<div class="post-metadata">

### Author: ![Krivo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/krivo/32/5363_2.png) [@Krivo](https://community.glideapps.com/u/Krivo)
#### Post date: [June 6, 2024, 3:06pm UTC](https://community.glideapps.com/t/create-a-new-table-with-user-specific-column-based-on-imported-data/73902/5 "2024-06-06T15:06:43Z")

</div>

It would be beneficial if it was possible to change a column to user specific - a warning would though be appropriate as the data in the column was be left unrelated to a user. But I have too many times been redoing columns in order to get them user specific

---

<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: [June 6, 2024, 11:48pm UTC](https://community.glideapps.com/t/create-a-new-table-with-user-specific-column-based-on-imported-data/73902/6 "2024-06-06T23:48:16Z")

</div>

> [@Pratik\_Shah](#):
>
> Even when you duplicate existing helper table with all User specific fields, it will still be normal fields.

This is incorrect now. When you duplicate a Glide table with USCs, USCs stay as USCs.

> [@Krivo](#):
>
> i would use the import function in the data editor. And there I would select an excel sheet xlxs

Then this won’t make your original statement possible. Why do you need them to be user-specific if you’re importing it from a xlsx file though?

---

<div class="post-metadata">

### Author: ![Pratik\_Shah](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pratik_shah/32/12416_2.png) [@Pratik\_Shah](https://community.glideapps.com/u/Pratik_Shah)
#### Post date: [June 7, 2024, 1:37am UTC](https://community.glideapps.com/t/create-a-new-table-with-user-specific-column-based-on-imported-data/73902/7 "2024-06-07T01:37:25Z")

</div>

> [@ThinhDinh](#):
>
> This is incorrect now. When you duplicate a Glide table with USCs, USCs stay as USCs.

That’s good. I only tried it once few months ago but it did not work. Thank you for this.

---

<div class="post-metadata">

### Author: ![Krivo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/krivo/32/5363_2.png) [@Krivo](https://community.glideapps.com/u/Krivo)
#### Post date: [June 7, 2024, 10:32am UTC](https://community.glideapps.com/t/create-a-new-table-with-user-specific-column-based-on-imported-data/73902/8 "2024-06-07T10:32:38Z")

</div>

> [@ThinhDinh](#):
>
> Then this won’t make your original statement possible. Why do you need them to be user-specific if you’re importing it from a xlsx file though?

@ThinhDinh  
If you have the attributes described and defined outside glide it would be beneficial to be able to import the attributes to avoid a lot of copy/paste. So it is only attributes/columns. Not rows with data
