---
title: "Sort Rows from SQL Server in Excel"
slug: "sorting-rows-from-sql-server"
description: "Sort the rows loaded into Excel by choosing columns in the Sort tab, reordering them by drag and drop, and removing a sort with the trash icon."
updated: 2022-04-06T09:57:23Z
published: 2022-04-06T09:57:23Z
canonical: "sqlspreads.com/sorting-rows-from-sql-server"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://sqlspreads.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# Sorting rows from SQL Server

## Add sorting

To sort your rows, select one or several columns to use for sorting in the Sort tab in the SQL Spreads Designer.

![Last name.png](https://cdn.document360.io/ad9d65b3-9cdd-4b28-8cb8-86cb149873bc/Images/Documentation/Last%20name.png)

## Switch column sort order

You can switch the column sort order, by using “drag and drop” to move the sort columns up and down in the list.

![Drag and drop.png](https://cdn.document360.io/ad9d65b3-9cdd-4b28-8cb8-86cb149873bc/Images/Documentation/Drag%20and%20drop.png)

## Remove sorting

To remove the sorting for a column, click the **Trash can** symbol on the right side in the sort columns list.

![Trashcan.png](https://cdn.document360.io/ad9d65b3-9cdd-4b28-8cb8-86cb149873bc/Images/Documentation/Trashcan.png)