Delim Converter

Convert lists between comma, pipe, tab, and custom delimiters with advanced options.

Input 0 items

Output 0 items

⚙️ Settings

Tidy Up Remove newlines

Attack clones Remove duplicates

Explode

Quotes

None Double " " Single ' '

Delimiter

Alphabetical Sorter — Sort a List A-Z, Z-A, or by Length

The Alphabetical Sorter organizes any list of text into order — A to Z, Z to A, or by line length. It's built for anyone who needs to sort a list alphabetically online — organizing names, tags, or file lists — without opening a spreadsheet. Paste your list, choose a sort order, and get the organized result instantly.

⚡ Key Takeaways

Sorts alphabetically A→Z or Z→A, or by line length instead.
Sorting is case-sensitive by default, which can affect ordering of mixed-case lists.
Doesn't remove duplicates — pair with the Duplicate Remover if you need both.
Length-based sorting is a quick way to spot unusually short or long entries.

What, Who, When & Why

What it's for	Sorts a list alphabetically (A→Z or Z→A) or by line length.
Who it's for	Anyone organizing names, tags, keywords, or file lists that need a consistent order.
When to use it	Before publishing a reference list, reviewing a dataset, or preparing options for a dropdown or filter.
Why it's needed	Manually reordering more than a handful of items is slow, and it's easy to make a mistake sorting by eye.
Best way to use it	Normalize capitalization first with the Case Converter if your list has mixed casing, since sorting is case-sensitive by default.

How to Use the Alphabetical Sorter

Paste your list into the Input box, one item per line.
Click A→Z to sort alphabetically ascending, or Z→A for descending.
Alternatively, sort by line length to organize by size rather than alphabetically.
Click Copy to grab the sorted list.

Example

Given an unsorted list:

cherry
apple
banana

Sorting A→Z produces:

apple
banana
cherry

Sorting the same list by length (shortest first) would instead give apple, cherry, banana — grouped by character count rather than alphabetical position, which is useful for spotting unusually short or long entries in a dataset.

Key Features

A→Z (ascending) and Z→A (descending) alphabetical sorting.
Sort by line length as an alternative to alphabetical order.
Works on lists of any size, sorted instantly.
One-click copy of the sorted result.

Practical Use Cases

Organizing names or tags: alphabetize a customer list, keyword list, or file directory listing.
Preparing reference lists: sort terms for a glossary or index before publishing.
Sorting by length: organize entries from shortest to longest, useful for spotting outliers, checking data quality, or formatting fixed-width columns.
Cleaning up exports: alphabetize a list pulled from a database before sharing or reviewing it.
Preparing dropdown options: sort a list of category or tag names before using them in a form or filter menu.

Tips for Best Results

Normalize capitalization first with the Case Converter if your list has inconsistent casing, since sorting is typically case-sensitive.
Remove duplicate entries before sorting if you only need unique values in your final list.
Use length-based sorting as a quick data-quality check — unusually short or long entries often indicate a data entry error.

Related Terminology

Alphabetical (lexicographic) sorting orders text character by character, comparing letters (and numbers, symbols) based on their standard character order. This means numbers and capital letters may sort differently than expected compared to a purely alphabetical or case-insensitive sort, depending on the exact values in your list. Ascending order (A→Z) starts from the beginning of the alphabet, while descending order (Z→A) starts from the end.

Important Considerations

Sorting is generally case-sensitive by default in most implementations, which can place capitalized entries before lowercase ones depending on character encoding — if your results look oddly ordered, check whether mixed capitalization in your list is affecting the sort order. Numbers and symbols at the start of a line also sort according to their character values, which may not match how you'd expect them to rank alongside letters.

Related Tools

Need to remove repeated entries before or after sorting? Use the Duplicate Remover, which also includes its own sort options. To standardize capitalization first, try the Case Converter. Once sorted, add reference numbers with the Line Number Stamper.

Frequently Asked Questions

How do I sort a list alphabetically?

Paste your list into the Input box and click A→Z — the list is sorted instantly in alphabetical order.

Can I sort by length instead of alphabetically?

Yes, there's a sort-by-length option that organizes your list from shortest to longest line instead of alphabetically.

Does sorting remove duplicate entries?

No, sorting only reorders your list — use the Duplicate Remover if you also need to strip repeated entries.

Is alphabetical sorting case-sensitive?

Yes, by default capitalization affects sort order — normalize your list's case with the Case Converter first if you need a purely case-insensitive alphabetical sort.

Escape / Unescape

Escape to HTML entities or JSON strings, or unescape back.

Input

Output

Line Number Stamper

Add incremental line numbers (001, 002, 003...) to each row.

Input

Output

SQL Value Generator

Wrap each line in quotes and join → ('a','b','c')

Input

Output

Date Range Generator

Generate a list of dates between two dates with custom intervals.

Start Date

End Date

Interval

Format

Output

Epoch Converter

Convert Unix timestamps to human-readable dates and vice versa.

Unix Timestamp

Human Date

Result

SQL Formatter

Beautify or minify SQL queries with proper indentation.

Input SQL

Output

CASE Statement Builder

Build SQL CASE WHEN statements one condition at a time — no special syntax to remember.

Column / Expression

Conditions

Else (default value)

Generated SQL

Query Sanitizer

Strip comments, SET statements, and trailing semicolons from SQL.

Input SQL

Output

📌 Sticky Notes

Organize your thoughts, tasks, and ideas with drag-and-drop sticky notes.

📌

Click "+ Add Note" to create your first sticky note.

Text Comparator

Compare two texts and see the differences highlighted.

Text A

Text B

Ignore case Ignore whitespace

Differences

Click "Compare" to see differences highlighted.

Ready to compare

Text Statistics

Get detailed statistics about your text: words, characters, paragraphs, sentences, and more.

Input Text

📝 Words

🔤 Characters

📏 Characters (no spaces)

📄 Sentences

📑 Paragraphs

📃 Lines

📊 Avg word length

📊 Avg sentence length

Detailed Results

SQL Query Templates

Ready-to-use boilerplate for common query patterns — CTEs, joins, date rollups, window functions, and stored procedures. Click Copy and adapt the table/column names.

CTE

Basic CTE (Common Table Expression)

Break a query into a readable, reusable named block.

WITH recent_orders AS (
    SELECT
        customer_id,
        order_id,
        order_date,
        total_amount
    FROM orders
    WHERE order_date >= DATEADD(day, -30, GETDATE())
)
SELECT
    customer_id,
    COUNT(order_id)   AS order_count,
    SUM(total_amount) AS total_spent
FROM recent_orders
GROUP BY customer_id
ORDER BY total_spent DESC;

Recursive CTE (hierarchy / org chart)

Walk a parent-child tree, e.g. an employee/manager hierarchy.

WITH RECURSIVE employee_hierarchy AS (
    -- Anchor: top-level rows (no manager)
    SELECT
        employee_id,
        manager_id,
        employee_name,
        1 AS level
    FROM employees
    WHERE manager_id IS NULL

    UNION ALL

    -- Recursive: join children to their parent's result
    SELECT
        e.employee_id,
        e.manager_id,
        e.employee_name,
        eh.level + 1
    FROM employees e
    INNER JOIN employee_hierarchy eh
        ON e.manager_id = eh.employee_id
)
SELECT *
FROM employee_hierarchy
ORDER BY level, employee_name;
-- Note: SQL Server / Oracle: drop the RECURSIVE keyword (just WITH employee_hierarchy AS (...))

Joins

INNER / LEFT JOIN across multiple tables

Combine orders with customers and line items in one query.

SELECT
    o.order_id,
    c.customer_name,
    o.order_date,
    p.product_name,
    oi.quantity
FROM orders o
INNER JOIN customers c
    ON o.customer_id = c.customer_id
LEFT JOIN order_items oi
    ON o.order_id = oi.order_id
LEFT JOIN products p
    ON oi.product_id = p.product_id
WHERE o.order_date >= '2026-01-01'
ORDER BY o.order_date DESC;

GROUP BY / Dates

Monthly rollup with GROUP BY on a date

Aggregate a date column by month (swap the truncation line for your engine).

SELECT
    DATE_TRUNC('month', order_date) AS order_month,     -- PostgreSQL
    -- FORMAT(order_date, 'yyyy-MM')  AS order_month,    -- SQL Server
    -- DATE_FORMAT(order_date, '%Y-%m') AS order_month,  -- MySQL
    COUNT(*)          AS order_count,
    SUM(total_amount) AS revenue
FROM orders
GROUP BY DATE_TRUNC('month', order_date)
ORDER BY order_month;

Window Functions

ROW_NUMBER + running total

Rank each customer's orders and compute a running total.

SELECT
    customer_id,
    order_id,
    order_date,
    total_amount,
    ROW_NUMBER() OVER (
        PARTITION BY customer_id
        ORDER BY order_date DESC
    ) AS order_rank,
    SUM(total_amount) OVER (
        PARTITION BY customer_id
        ORDER BY order_date
        ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW
    ) AS running_total
FROM orders;

Stored Procedures

Parameterized stored procedure

A basic proc with optional date-range filters (T-SQL syntax).

CREATE PROCEDURE GetCustomerOrders
    @CustomerId INT,
    @StartDate  DATE = NULL,
    @EndDate    DATE = NULL
AS
BEGIN
    SET NOCOUNT ON;

    SELECT
        order_id,
        order_date,
        total_amount
    FROM orders
    WHERE customer_id = @CustomerId
        AND (@StartDate IS NULL OR order_date >= @StartDate)
        AND (@EndDate   IS NULL OR order_date <= @EndDate)
    ORDER BY order_date DESC;
END;
-- Call it: EXEC GetCustomerOrders @CustomerId = 101, @StartDate = '2026-01-01';

Upsert / Merge

MERGE (upsert) from a staging table

Insert new rows and update matching ones in a single statement.

MERGE INTO customers AS target
USING staging_customers AS source
    ON target.customer_id = source.customer_id
WHEN MATCHED THEN
    UPDATE SET
        target.customer_name = source.customer_name,
        target.email         = source.email,
        target.updated_at    = GETDATE()
WHEN NOT MATCHED THEN
    INSERT (customer_id, customer_name, email, created_at)
    VALUES (source.customer_id, source.customer_name, source.email, GETDATE());

🎨 Color Picker & Converter

Pick a color (or type a value) and get HEX, RGB, HSL, HSV, and CMYK instantly — copy any format with one click.

HEX

#FACC15

RGB

rgb(250, 204, 21)

RGB Percent

rgb(98%, 80%, 8%)

HSL

hsl(46, 96%, 53%)

HSV / HSB

hsv(46, 92%, 98%)

CMYK

cmyk(0%, 18%, 92%, 2%)

CSV ⇄ JSON Converter

Paste CSV or JSON and convert between them. Handles quoted fields, embedded commas, and nested-safe escaping.

Input

Output

SQL Query Explainer

Paste a SQL query and get a plain-English, structured breakdown of what it does. Pattern-based — works fully offline, no AI involved.

SQL Query

Plain-English Breakdown

Unit Converter

Convert data sizes and time durations. Pick a category, enter a value, and see it converted to every other unit.

Tools for analysts, developers & QA engineers

33 free, browser-based utilities — text and list tools, SQL helpers, converters, and small productivity apps. Everything runs locally; nothing you type or paste is ever uploaded.

📊

For Analysts

Clean lists, build SQL fragments, and reshape data without opening a spreadsheet.

💻

For Developers

Format SQL, convert data formats, and handle everyday text and encoding tasks.

🧪

For QA Engineers

Generate test data, compare text output, and sanitize queries before sharing them.

⚙️ Settings

Alphabetical Sorter — Sort a List A-Z, Z-A, or by Length

⚡ Key Takeaways

What, Who, When & Why

How to Use the Alphabetical Sorter

Example

Key Features

Practical Use Cases

Tips for Best Results

Related Terminology

Important Considerations

Related Tools

Frequently Asked Questions

How do I sort a list alphabetically?

Can I sort by length instead of alphabetically?

Does sorting remove duplicate entries?

Is alphabetical sorting case-sensitive?

Archived Notes

Tools for analysts, developers & QA engineers

For Analysts

For Developers

For QA Engineers

Core Tools

SQL Tools

Productivity

Analysis

Design