# Importing data from CSV- Broken **URL:** \ **Category:** General\ **Tags:** tables\ **Created:** [October 19, 2023, 1:02pm UTC](https://community.tulip.co/t/importing-data-from-csv-broken/9612 "2023-10-19T13:02:40Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![don.feeney](https://avatars.discourse-cdn.com/v4/letter/d/54ee81/32.png) [@don.feeney](https://community.tulip.co/u/don.feeney)\ **Post date:** [October 19, 2023, 1:02pm UTC](https://community.tulip.co/t/importing-data-from-csv-broken/9612/1 "2023-10-19T13:02:40Z")
Now why does an import, even with mapping, the rows are out of order, some rows aren’t even showing. Might have to bring this up today at tutor, its pretty frustrating. Any direction would be helpful. Thank you. ---
**Author:** ![Beth](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/beth/32/5987_2.png) [@Beth](https://community.tulip.co/u/Beth)\ **Post date:** [October 19, 2023, 6:40pm UTC](https://community.tulip.co/t/importing-data-from-csv-broken/9612/2 "2023-10-19T18:40:14Z")
Hi Don - I’m sorry you’re frustrated by the csv import. Could you provide a little more context and/or screenshots of your issue so the community can help? Some things I can think off off the bat that might cause problems: 1. duplicate IDs 2. trailing spaces in ID column 3. mismatch in the data type the tulip table is expecting and the actual data in a cell/rows This link may also help - it has some tips for check CSVs for errors [https://support.tulip.co/docs/how-to-import-a-spreadsheet-into-a-table](https://support.tulip.co/docs/how-to-import-a-spreadsheet-into-a-table) ---
**Author:** ![don.feeney](https://avatars.discourse-cdn.com/v4/letter/d/54ee81/32.png) [@don.feeney](https://community.tulip.co/u/don.feeney)\ **Post date:** [October 23, 2023, 1:14pm UTC](https://community.tulip.co/t/importing-data-from-csv-broken/9612/3 "2023-10-23T13:14:40Z")
Hi Beth thank you for reaching out with your input. This is an example of the screen sizes that aren’t in order. ![image](https://us1.discourse-cdn.com/flex020/uploads/agilemfg/original/2X/5/5c5d122f6a5726baf7a5110511eb9cfe0ecc563f.png) Some rows are being sent to the very end of the table. ![image](https://us1.discourse-cdn.com/flex020/uploads/agilemfg/original/2X/b/b80c77304059560b3092b7b02a4f08dad23c47a2.png) Thank you for your time. -Don ---
**Author:** ![Beth](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/beth/32/5987_2.png) [@Beth](https://community.tulip.co/u/Beth)\ **Post date:** [October 23, 2023, 2:56pm UTC](https://community.tulip.co/t/importing-data-from-csv-broken/9612/4 "2023-10-23T14:56:19Z")
Hey Don Couple more questions from me to try and understand the situation - What order should the screen sizes be in? Is there any type of filtering or sort that is happening in the table that could be causing this? ![image](https://us1.discourse-cdn.com/flex020/uploads/agilemfg/original/2X/4/4345b6bca26a4cbfae9185aa0f74b85985e3c6b7.png) Thanks! ---
**Author:** ![don.feeney](https://avatars.discourse-cdn.com/v4/letter/d/54ee81/32.png) [@don.feeney](https://community.tulip.co/u/don.feeney)\ **Post date:** [October 23, 2023, 3:08pm UTC](https://community.tulip.co/t/importing-data-from-csv-broken/9612/5 "2023-10-23T15:08:11Z")
Hi Beth thank you for reaching back out. The arrow sorting a-z worked well. I would like TBC and Mesh to be grouped separately, the sizes from smallest to largest. Would be great if this is possible. ---
**Author:** ![Tim\_Reblitz](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/tim_reblitz/32/8342_2.png) [@Tim\_Reblitz](https://community.tulip.co/u/Tim_Reblitz)\ **Post date:** [October 23, 2023, 4:10pm UTC](https://community.tulip.co/t/importing-data-from-csv-broken/9612/6 "2023-10-23T16:10:30Z")
Don, please note that you can add multiple sorts to a table in a couple ways: - When creating a Table Query, see the ‘Sort’ feature. You can set the sorting to occur by one column Then by another column. (This sorting should then be carried over to the values you may see when applying a Unique Values Aggregation.) - Sorting by multiple columns can also be applied in the Tulip App Editor on the Interactive Table Widget. ---
**Author:** ![don.feeney](https://avatars.discourse-cdn.com/v4/letter/d/54ee81/32.png) [@don.feeney](https://community.tulip.co/u/don.feeney)\ **Post date:** [October 23, 2023, 4:26pm UTC](https://community.tulip.co/t/importing-data-from-csv-broken/9612/7 "2023-10-23T16:26:25Z")
Thank you Tim for your input and advice, appreciate your time. My issue is that my import is not lining up exactly esp. with these screen sizes. I guess I can use some type of sorting, just disappointed that the upload is causing issues and trying to figure out why. ---
**Author:** ![Tim\_Reblitz](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/tim_reblitz/32/8342_2.png) [@Tim\_Reblitz](https://community.tulip.co/u/Tim_Reblitz)\ **Post date:** [October 23, 2023, 4:39pm UTC](https://community.tulip.co/t/importing-data-from-csv-broken/9612/8 "2023-10-23T16:39:53Z")
Don, keep in mind that any newly-imported rows will appear at the bottom of the table - however the only sorting that is visible to an operator using Tulip Apps are via the sorting methods I described. I hope this is of some help. ---
**Author:** ![don.feeney](https://avatars.discourse-cdn.com/v4/letter/d/54ee81/32.png) [@don.feeney](https://community.tulip.co/u/don.feeney)\ **Post date:** [October 23, 2023, 5:09pm UTC](https://community.tulip.co/t/importing-data-from-csv-broken/9612/9 "2023-10-23T17:09:47Z")
Thank you it is good information, appreciate it. I just wish that this csv file would import correctly, row for row. Would make a particular app- a search for equipment- a lot smoother.