Title: Importing csv table into database – sort order changes?
Last modified: August 20, 2016

---

# Importing csv table into database – sort order changes?

 *  [harvest101](https://wordpress.org/support/users/harvest101/)
 * (@harvest101)
 * [13 years, 6 months ago](https://wordpress.org/support/topic/importing-csv-table-into-database-sort-order-changes/)
 * Hi,
    I am importing a table into my database via phpMyAdmin, the table populates
   a couple of dropdowns on my site.
 * For some reason even though the table is in the correct order in csv/excel format,
   once it is imported the order changes, so the order of the list on the dropdowns
   on my website is wrong (it should be alphabetical).
 * I can’t see any logic in the way the table is re-sorting itself on import, I 
   import it alphabetically descending, once imported the top 5 or so are sorted
   ascending (correct), and the next ones are in a random order. How can I make 
   it import the table in a specific order?

Viewing 1 replies (of 1 total)

 *  [fonglh](https://wordpress.org/support/users/fonglh/)
 * (@fonglh)
 * [13 years, 6 months ago](https://wordpress.org/support/topic/importing-csv-table-into-database-sort-order-changes/#post-3197220)
 * This isn’t a WordPress question.
 * Anyway you can always use SQL to order the list when you make the query.

Viewing 1 replies (of 1 total)

The topic ‘Importing csv table into database – sort order changes?’ is closed to
new replies.

## Tags

 * [csv](https://wordpress.org/support/topic-tag/csv/)
 * [Import](https://wordpress.org/support/topic-tag/import/)
 * [phpmyadmin](https://wordpress.org/support/topic-tag/phpmyadmin/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 1 reply
 * 2 participants
 * Last reply from: [fonglh](https://wordpress.org/support/users/fonglh/)
 * Last activity: [13 years, 6 months ago](https://wordpress.org/support/topic/importing-csv-table-into-database-sort-order-changes/#post-3197220)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics