# Re-organize/ re-order columns in ODK tables **URL:** \ **Category:** Support\ **Created:** [April 13, 2017, 8:14am UTC](https://forum.odk-x.org/t/re-organize-re-order-columns-in-odk-tables/241 "2017-04-13T08:14:08Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![kamautim](https://odkx.b-cdn.net/letter_avatar_proxy/v4/letter/k/cdc98d/32.png) [@kamautim](https://forum.odk-x.org/u/kamautim)\ **Post date:** [April 13, 2017, 8:14am UTC](https://forum.odk-x.org/t/re-organize-re-order-columns-in-odk-tables/241/1 "2017-04-13T08:14:08Z")
Hi, The columns in ODK tables are organized or ordered alphabetically and I would like to change the ordering according to my needs and to be more user friendly for my users by starting with for example, job number, then name, gender, age, etc. I tried modifying the definition.csv before uploading the survey through application designer but this has no effect. Please help, thanks. ---
**Author:** ![Duncan\_Otieno](https://odkx.b-cdn.net/user_avatar/forum.odk-x.org/duncan_otieno/32/445_2.png) [@Duncan\_Otieno](https://forum.odk-x.org/u/Duncan_Otieno)\ **Post date:** [February 5, 2021, 6:48am UTC](https://forum.odk-x.org/t/re-organize-re-order-columns-in-odk-tables/241/2 "2021-02-05T06:48:53Z")
Hello Team, @kamautim, Did you get help with this? If you did please share. To the community , If someone has a way out of this please share ---
**Author:** ![linl33](https://odkx.b-cdn.net/letter_avatar_proxy/v4/letter/l/b487fb/32.png) [@linl33](https://forum.odk-x.org/u/linl33)\ **Post date:** [February 6, 2021, 3:56am UTC](https://forum.odk-x.org/t/re-organize-re-order-columns-in-odk-tables/241/3 "2021-02-06T03:56:59Z")
If you’re referring to the column order in the spreadsheet view of Tables, you can specify the order on the `properties` sheet. See [app-designer/app/config/tables/agriculture/forms/agriculture/agriculture.xlsx at 051e65580718983745d6697ec277d804d5237fcd · odk-x/app-designer · GitHub](https://github.com/odk-x/app-designer/blob/051e65580718983745d6697ec277d804d5237fcd/app/config/tables/agriculture/forms/agriculture/agriculture.xlsx) for an example. ---
**Author:** ![cmuchuchuti](https://odkx.b-cdn.net/user_avatar/forum.odk-x.org/cmuchuchuti/32/356_2.png) [@cmuchuchuti](https://forum.odk-x.org/u/cmuchuchuti)\ **Post date:** [March 16, 2021, 3:44pm UTC](https://forum.odk-x.org/t/re-organize-re-order-columns-in-odk-tables/241/4 "2021-03-16T15:44:18Z")
Dear team; Has anyone been successful in reordering the column as per the agriculture.xlsx file. @linl33 I have tried to put follow the example but still I seem not to be getting the ordering. Even the **Table** properties they seem not to be effected upon converting the formDef.json and the properties file. Below is my properties sheet in my survey. ![image](https://odkx.b-cdn.net/uploads/default/original/1X/cba0250af7723dd2671370cc6616aca4ec8fc7e9.png) Thank you. ---
**Author:** ![elmps2018](https://odkx.b-cdn.net/user_avatar/forum.odk-x.org/elmps2018/32/105_2.png) [@elmps2018](https://forum.odk-x.org/u/elmps2018)\ **Post date:** [March 16, 2021, 6:46pm UTC](https://forum.odk-x.org/t/re-organize-re-order-columns-in-odk-tables/241/5 "2021-03-16T18:46:43Z")
Did the agriculture order work when you simply replicated that app? If that did and then you change it step-by-step to what you are trying to do, you may be able to identify where the problem is. One issue to check is whether you are editing in tableid==formid, since that governs the properties, if it’s a form that writes to another table nothing will be affected. ---
**Author:** ![cmuchuchuti](https://odkx.b-cdn.net/user_avatar/forum.odk-x.org/cmuchuchuti/32/356_2.png) [@cmuchuchuti](https://forum.odk-x.org/u/cmuchuchuti)\ **Post date:** [March 17, 2021, 7:57am UTC](https://forum.odk-x.org/t/re-organize-re-order-columns-in-odk-tables/241/6 "2021-03-17T07:57:11Z")
Thanks @elmps2018 for your response. After carefully comparing the **properties** sheet from **agriculture** file and **mine** , I noted that the column headings were different. I had included an **underscore** which I had copied from the properties file where the agriculture one does not have.