# Column not sorted in alphabetical order

**URL:** <https://forum.seatable.com/t/column-not-sorted-in-alphabetical-order/2324>\
**Category:** Views\
**Tags:** sorting\
**Created:** [April 28, 2023, 10:47am UTC](https://forum.seatable.com/t/column-not-sorted-in-alphabetical-order/2324 "2023-04-28T10:47:45Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Tomtsl](https://forum.seatable.com/letter_avatar_proxy/v4/letter/t/da6949/32.png) [@Tomtsl](https://forum.seatable.com/u/Tomtsl)\
**Post date:** [April 28, 2023, 10:47am UTC](https://forum.seatable.com/t/column-not-sorted-in-alphabetical-order/2324/1 "2023-04-28T10:47:45Z")

</div>

![image](https://forum.seatable.io/uploads/default/original/2X/e/e18bb6c0f8318f0bb768f7858cb2d4f6bd24ef0b.png)

Hi,

I have a table of local community organisations. Much of the data is imported from spreadsheets.

As you can see, the organisation nickname column is not in the correct order. The Chess Club comes before, and after Art Week or Food & Drink Festival.

Also, when I run the Deduplication plug-in on organisation nickname it says ‘no duplicates’, when there are clearly three ‘Holmfirth Chess Club’ entries.

---

<div class="post-metadata">

**Author:** ![webdienste](https://forum.seatable.com/letter_avatar_proxy/v4/letter/w/977dab/32.png) [@webdienste](https://forum.seatable.com/u/webdienste)\
**Post date:** [April 28, 2023, 3:40pm UTC](https://forum.seatable.com/t/column-not-sorted-in-alphabetical-order/2324/2 "2023-04-28T15:40:24Z")

</div>

Hi Tom, couple of questions - please forgive me if they seem so simple it’s almost an insult and also so obviously not:

- Which column did you apply the sort to?
- Re: deduplicates: The deduplicates is case sensitive, so would not see two entries as being the same if there are any differences in case. Also double check that you actually chose the nickname column. also check if there are any leading/trailing spaces in the names (normally, when you enter a name directly it will delete any leading/trailing spaces, but seeing as you imported from a spreadsheet, there could be artefacts there - sometimes I only see them when I view the table on a smartphone). Try entering the names twice manually and then run the deduplicates plugin on that column

---

<div class="post-metadata">

**Author:** ![Tomtsl](https://forum.seatable.com/letter_avatar_proxy/v4/letter/t/da6949/32.png) [@Tomtsl](https://forum.seatable.com/u/Tomtsl)\
**Post date:** [May 1, 2023, 9:29pm UTC](https://forum.seatable.com/t/column-not-sorted-in-alphabetical-order/2324/3 "2023-05-01T21:29:53Z")

</div>

Thanks for replying. No insults received!

Yes, it’s the right column sorted.

I typed over the data for an organisation nickname directly into the table and the sort order changed. The retyped entries also showed up deduplicate plugin.

So, it seems you are right that there are other characters in the cell, that are not visible but which affect sort order.

Is there a way to clean it up easily and remove these ‘artefacts’?  
Please don’t suggest I type everything in manually!

Thanks again.

---

<div class="post-metadata">

**Author:** ![rdb](https://forum.seatable.com/user_avatar/forum.seatable.com/rdb/32/1869_2.png) [@rdb](https://forum.seatable.com/u/rdb)\
**Post date:** [May 2, 2023, 7:19am UTC](https://forum.seatable.com/t/column-not-sorted-in-alphabetical-order/2324/4 "2023-05-02T07:19:56Z")

</div>

Save your spreadsheets in a different format and reimport them. If you imported them as CSV, then save them as XLSX. If you imported them as XLSX, save them as CSV.

Then try again.

---

<div class="post-metadata">

**Author:** ![Tomtsl](https://forum.seatable.com/letter_avatar_proxy/v4/letter/t/da6949/32.png) [@Tomtsl](https://forum.seatable.com/u/Tomtsl)\
**Post date:** [May 4, 2023, 9:32pm UTC](https://forum.seatable.com/t/column-not-sorted-in-alphabetical-order/2324/5 "2023-05-04T21:32:12Z")

</div>

Thanks, I’ll give that a go.

I have columns with links to other tables, so I’ll need to think about how to do it.

---

<div class="post-metadata">

**Author:** ![system](https://forum.seatable.com/uploads/default/original/1X/04603423fe81a46c321283663086c475429e8ccb.png) [@system](https://forum.seatable.com/u/system)\
**Post date:** [May 10, 2023, 7:15am UTC](https://forum.seatable.com/t/column-not-sorted-in-alphabetical-order/2324/6 "2023-05-10T07:15:07Z")

</div>

Closed on May 10, 2023, 7:15am UTC

This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.
