# How to bulk add user-specific column data?
**URL:** https://community.glideapps.com/t/how-to-bulk-add-user-specific-column-data/33793
**Category:** Ask for Help
**Created:** [October 31, 2021, 7:56am UTC](https://community.glideapps.com/t/how-to-bulk-add-user-specific-column-data/33793 "2021-10-31T07:56:20Z")
**Posts on this page:** 5
**Page:** 1
### Author:  [@0xlukekim](https://community.glideapps.com/u/0xlukekim)
#### Post date: [October 31, 2021, 7:56am UTC](https://community.glideapps.com/t/how-to-bulk-add-user-specific-column-data/33793/1 "2021-10-31T07:56:20Z")
GSheets backed. For general data, can obviously just post it in. User-specific data does not seem to propagate back to the Google sheet. What’s the easiest way to bulk add?
Related - is there an API for Glide Tables (where I assume the user-specific data is stored)?
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [October 31, 2021, 8:03am UTC](https://community.glideapps.com/t/how-to-bulk-add-user-specific-column-data/33793/2 "2021-10-31T08:03:15Z")
> [@0xlukekim](#):
>
> GSheets backed. For general data, can obviously just post it in. User-specific data does not seem to propagate back to the Google sheet. What’s the easiest way to bulk add?
User Specific Columns are computed columns. They only exist in the Glide backend, and on each users device. As far as I’m aware, there is no way to transfer or bulk add user specific data.
> [@0xlukekim](#):
>
> Related - is there an API for Glide Tables (where I assume the user-specific data is stored)?
No, there isn’t. Many of us would love to see that.
---
### Author:  [@Mark\_Turrell](https://community.glideapps.com/u/Mark_Turrell)
#### Post date: [October 31, 2021, 8:03am UTC](https://community.glideapps.com/t/how-to-bulk-add-user-specific-column-data/33793/3 "2021-10-31T08:03:48Z")
User specific column values do not exist in GS.
The only way to write them into GS is to have a button/action and set basic columns in GS with your usc-column values.
And bulk is not possible…… as these are all personal values. You could go into the GDE and manually pretend to be your users, but that does not scale.
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [October 31, 2021, 8:29am UTC](https://community.glideapps.com/t/how-to-bulk-add-user-specific-column-data/33793/4 "2021-10-31T08:29:25Z")
Use join colum to join data from user specific column separated by some character that doesn’t exist in that data…
Then use button to write that joined column to Google sheets… and split them back using split transposed formula
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [October 31, 2021, 2:49pm UTC](https://community.glideapps.com/t/how-to-bulk-add-user-specific-column-data/33793/5 "2021-10-31T14:49:59Z")
Below is an excerpt from another post that explains how I believe user specific columns work. I believe the values are stored in a separate hidden glide table. Not directly in the table that contains the user specific column…although it may visually appear that way and you can work with it like it is. I think it’s just a special type of relation with direct access to the value in that hidden table.
If you want to periodically access user specific data, you can manually export the app data as a CSV file that’s emailed to you.
> [@Why can't I create a form for User-Specific columns?](https://community.glideapps.com/t/why-cant-i-create-a-form-for-user-specific-columns/11347/5):
>
> User specific columns require a row id so an underlying hidden relation can be created to a separate underlying hidden table (containing row id, user email, and column value) to store those user specific values and properly link it back to the correct row.