Skip to main content

How to Sort a Text File Alphabetically in Batch Script

Managing large text files, such as lists of usernames, server inventories, or log entries, often requires organizing the data to make it searchable or readable. Sorting a file alphabetically is a foundational data-processing task that can be easily automated within a Batch environment without needing expensive database software or complex programming languages.

In this guide, we will demonstrate how to use the built-in sort command to organize your text files efficiently.

Method 1: The Basic Alpha Sort​

The sort command reads a file and outputs the lines in ascending alphabetical order (A to Z).

Implementation​

@echo off
setlocal

set "SourceFile=UnsortedUsers.txt"
set "OutputFile=SortedUsers.txt"

:: Verify the source file exists before attempting to sort
if not exist "%SourceFile%" (
    echo [ERROR] Source file "%SourceFile%" not found.
    pause
    exit /b 1
)

echo Sorting "%SourceFile%"...

:: Use the /o switch to specify the output file
sort "%SourceFile%" /o "%OutputFile%"

if %errorlevel% equ 0 (
    echo [SUCCESS] File sorted and saved to "%OutputFile%".
) else (
    echo [ERROR] Failed to sort file.
)
pause
exit /b 0

For example, consider the following input file UnsortedUsers.txt:

Jane Smith
John Doe
Bob Johnson
Alice Williams

The content of the output file SortedUsers.txt will be:

Alice Williams
Bob Johnson
Jane Smith
John Doe
tip

Always verify that the source file exists before passing it to sort. Without the check, the sort command will write an empty output file and report success, silently destroying your expected output.

Method 2: Reverse Sorting (Z to A)​

If you need the data in descending order, the sort command includes a /r (reverse) switch.

@echo off
setlocal

set "SourceFile=UnsortedUsers.txt"
set "OutputFile=SortedUsersDesc.txt"

if not exist "%SourceFile%" (
    echo [ERROR] Source file "%SourceFile%" not found.
    pause
    exit /b 1
)

:: Sort in reverse order
sort /r "%SourceFile%" /o "%OutputFile%"

if %errorlevel% equ 0 (
    echo [SUCCESS] Reverse-sorted file saved to "%OutputFile%".
) else (
    echo [ERROR] Failed to sort file.
)
pause
exit /b 0

For example, consider the following input file UnsortedUsers.txt:

Jane Smith
John Doe
Bob Johnson
Alice Williams

The content of the output file SortedUsersDesc.txt will be:

John Doe
Jane Smith
Bob Johnson
Alice Williams

Method 3: Sorting by a Specific Column​

Many text files act as simple databases where data is stored in columns. For example, if your file looks like this:

ID001 John
ID002 Alex
ID003 Maria

You might want to sort by the Name (which starts at the 7th character) rather than the ID.

@echo off
setlocal

set "SourceFile=UserList.txt"
set "OutputFile=SortedByName.txt"

if not exist "%SourceFile%" (
    echo [ERROR] Source file "%SourceFile%" not found.
    pause
    exit /b 1
)

echo Sorting by second column (starting at character 7^)...

:: /+n tells sort to start the comparison at character position n
sort /+7 "%SourceFile%" /o "%OutputFile%"

if %errorlevel% equ 0 (
    echo [SUCCESS] Column-sorted file saved to "%OutputFile%".
) else (
    echo [ERROR] Failed to sort file.
)
pause
exit /b 0

The content of the output file SortedByName.txt will be:

ID002 Alex
ID001 John
ID003 Maria
warning

The /+n switch uses a fixed character position, not a delimiter-based column. If your columns are not consistently aligned (for example, if IDs vary in length like ID1 vs ID1000), the sort will compare the wrong characters on some lines. Ensure your data uses fixed-width columns or pad shorter values with spaces before sorting.

Handling Case Sensitivity​

One important feature of the Windows sort command is that it is case-insensitive by default. Apple, apple, and APPLE will be grouped together. This behavior is controlled by the system locale. No additional flags are needed for standard case-insensitive sorting.

Best Practices and Rules​

  1. File Existence Check: Always verify that the source file exists before running sort. The command will not report a meaningful error for a missing input file and may produce an empty output file.
  2. File Size Limits: The sort command is very fast but has limits based on your system's available memory. For extremely large files (gigabytes), you should use a more dedicated tool or split the file first.
  3. Backup Your Data: The /o switch can overwrite your source file if you use the same name (sort "file.txt" /o "file.txt"). Always use a different output name or create a backup before sorting in place.
  4. Special Characters: By default, sort treats symbols and numbers based on their locale-defined collation order. If your file contains complex symbols at the start of lines, verify the results to ensure they meet your specific expectations.
  5. Unique Sorting: The sort command does not remove duplicates. If "John" appears twice, it will remain twice in the sorted result. To remove duplicates after sorting, pipe the output through a deduplication loop or use a tool that supports unique filtering.
  6. Fixed-Width Requirement: When using /+n for column sorting, ensure your data columns are consistently aligned. Variable-width fields will produce incorrect sort results.
info

The sort command can also read from standard input via a pipe. For example, type "file.txt" | sort /r sends the file contents through sort in reverse order and prints the result to the console. This is useful when you want to preview sorted output before writing it to a file.

Conclusion​

Sorting a text file is a simple but powerful way to bring order to raw data. By mastering the sort command and its various switches like /r (reverse) and /+n (column start), you can build robust data-processing pipelines that turn messy logs and lists into structured, organized inventories. This is an essential skill for any system administrator or developer working in the Windows command-line environment.

Table of Contents