# Create Editable Table **URL:** \ **Category:** Ask the community\ **Tags:** wix-stores, code, question\ **Created:** [August 31, 2017, 4:14pm UTC](https://forum.wixstudio.com/t/create-editable-table/24248 "2017-08-31T16:14:38Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![marcelo-salazar](https://avatars.discourse-cdn.com/v4/letter/m/ebca7d/32.png) [@marcelo-salazar](https://forum.wixstudio.com/u/marcelo-salazar)\ **Post date:** [August 31, 2017, 4:14pm UTC](https://forum.wixstudio.com/t/create-editable-table/24248/1 "2017-08-31T16:14:38Z")
I would like to create a table that can be populated with data from the database, but can be edited similar to an excel spreadsheet. Googlesheets is not an option. Objective is to create user-specific page with table where user can modify the data on the table and have the data stored in a database. Each record in the database would be a row in the table. User should simply open the page and, see the table and enter any data into any cell in the table and then press save. The next time the user enters that page, he/she would see the same data on the table and can edit it again. I know how to limit the page to a specific user so that the data is specific to that user. I would also use one database per user/page (only a few users). Any ideas/help? Thanks! ---
**Author:** ![andreas-kviby](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/andreas-kviby/32/790_2.png) [@andreas-kviby](https://forum.wixstudio.com/u/andreas-kviby)\ **Post date:** [August 31, 2017, 5:23pm UTC](https://forum.wixstudio.com/t/create-editable-table/24248/2 "2017-08-31T17:23:53Z")
Hey There is no native component to accomplish this in WIX except coding and tricks. You could call on a iframe where the actual table is populated using some script and when edited it calls back to wix and stores it. Otherwise you could just give the user the permission to add / edit and work with your collections through WIX directly? ---
**Author:** ![tomer-wix](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/tomer-wix/32/676_2.png) [@tomer-wix](https://forum.wixstudio.com/u/tomer-wix)\ **Post date:** [August 31, 2017, 10:09pm UTC](https://forum.wixstudio.com/t/create-editable-table/24248/3 "2017-08-31T22:09:35Z")
You can also add input elements next to the table, so the user can select a row in the table, and edit the data using the input elements. Another (maybe crazy?) idea is to have a lot of text inputs, imitating a spreadsheet. That could be an interesting experiment ☺ Please give it a try, we’d love to see what you come up with. ---
**Author:** ![marcelo-salazar](https://avatars.discourse-cdn.com/v4/letter/m/ebca7d/32.png) [@marcelo-salazar](https://forum.wixstudio.com/u/marcelo-salazar)\ **Post date:** [August 31, 2017, 11:34pm UTC](https://forum.wixstudio.com/t/create-editable-table/24248/4 "2017-08-31T23:34:32Z")
Thanks To both for these ideas! ---
**Author:** ![ron-girard](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/ron-girard/32/943_2.png) [@ron-girard](https://forum.wixstudio.com/u/ron-girard)\ **Post date:** [January 29, 2018, 6:40pm UTC](https://forum.wixstudio.com/t/create-editable-table/24248/5 "2018-01-29T18:40:21Z")
EDITABLE TABLES I REALLY LOVE IT ! Someone have add it into request features Forum!? ---
**Author:** ![pankaj-patel](https://avatars.discourse-cdn.com/v4/letter/p/c6cbf5/32.png) [@pankaj-patel](https://forum.wixstudio.com/u/pankaj-patel)\ **Post date:** [February 5, 2018, 3:42am UTC](https://forum.wixstudio.com/t/create-editable-table/24248/6 "2018-02-05T03:42:41Z")
Ron, Me too! Editability of table along with ability to (a) insert a blank row and (b) delete selected row(s) or delete a row-at-a-time to begin with, would be a nice. In the website I am working on, just in the first draft I have a need to have 4 editable tables. And then I will need one more very soon. (For now i am using Tomer’s suggestion of having input elements next to the table.) ---
**Author:** ![mickael-coat](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/mickael-coat/32/1343_2.png) [@mickael-coat](https://forum.wixstudio.com/u/mickael-coat)\ **Post date:** [June 12, 2018, 7:00pm UTC](https://forum.wixstudio.com/t/create-editable-table/24248/7 "2018-06-12T19:00:36Z")
I would like as well the possibility to build a UI to access data from the data base from a table with possibility to modify add date and delete data. ---
**Author:** ![doughammack](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/doughammack/32/108659_2.png) [@doughammack](https://forum.wixstudio.com/u/doughammack)\ **Post date:** [June 20, 2019, 6:24pm UTC](https://forum.wixstudio.com/t/create-editable-table/24248/8 "2019-06-20T18:24:32Z")
How would this work? You have a table and you want a user to be able enter or edit an item in the table, so you put a user input and save button next to it. How do you communicate that when the user clicks on X row and inputs something into the user input, it adds it to the collection? I really like this id but how would you go about that? ---
**Author:** ![greenmango318](https://avatars.discourse-cdn.com/v4/letter/g/919ad9/32.png) [@greenmango318](https://forum.wixstudio.com/u/greenmango318)\ **Post date:** [June 24, 2019, 4:52am UTC](https://forum.wixstudio.com/t/create-editable-table/24248/9 "2019-06-24T04:52:06Z")
I am able to do this with a table and required number of input fields. When user lists a row in the table, same data will be displayed in the input fields for edit. After edit, use a button to save data into the collections. ---
**Author:** ![mohdhassanmh2](https://avatars.discourse-cdn.com/v4/letter/m/eb9ed0/32.png) [@mohdhassanmh2](https://forum.wixstudio.com/u/mohdhassanmh2)\ **Post date:** [January 30, 2020, 10:02am UTC](https://forum.wixstudio.com/t/create-editable-table/24248/10 "2020-01-30T10:02:12Z")
Great i used and succeeds, Thanks Man ---
**Author:** ![givemeawhisky](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/givemeawhisky/32/5383_2.png) [@givemeawhisky](https://forum.wixstudio.com/u/givemeawhisky)\ **Post date:** [January 31, 2020, 3:18pm UTC](https://forum.wixstudio.com/t/create-editable-table/24248/11 "2020-01-31T15:18:13Z")
Old post reappearing, closed.