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

Case Converter — Convert Text to UPPERCASE, lowercase, Title Case & Sentence Case

The Case Converter instantly changes the letter casing of any text — switch between UPPERCASE, lowercase, Title Case, and Sentence case with one click. It's built for anyone who needs to convert text to uppercase online for a heading, fix inconsistent capitalization in a data export, or clean up names typed in ALL CAPS. Paste your text, pick a case, and copy the result — no need to retype anything by hand or fight with a word processor's autocorrect.

⚡ Key Takeaways

Four case modes in one tool: UPPERCASE, lowercase, Title Case, Sentence case.
Converts every line of multi-line text at once — no need to fix names one by one.
Won't fix unusual brand capitalization (like "iPhone") automatically — spot-check the result.
Pairs well with the Whitespace Trimmer for a full data cleanup pass.

What, Who, When & Why

What it's for	Instantly converts text between UPPERCASE, lowercase, Title Case, and Sentence case.
Who it's for	Writers, editors, and anyone cleaning up inconsistently-typed names or headings in a document or spreadsheet.
When to use it	When you've pasted text with the wrong capitalization — like a heading typed in all caps, or names entered inconsistently across a dataset.
Why it's needed	Retyping text just to fix its casing wastes time and risks introducing new typos; a dedicated converter changes case instantly without touching the actual words.
Best way to use it	Use Title Case for headings and product names, Sentence case for body text, and always spot-check the result for brand names or acronyms that need manual correction.

How to Use the Case Converter

Paste or type your text into the Input box.
Click one of the four case buttons: UPPERCASE, lowercase, Title Case, or Sentence case.
The converted text appears instantly in the Output box.
Click Copy to copy the result to your clipboard.

What Each Case Option Does

Case	Example	Typical use
UPPERCASE	HELLO WORLD	Headings, emphasis, acronyms
lowercase	hello world	Normalizing data, usernames, tags
Title Case	Hello World	Titles, product names, headings
Sentence case	Hello world	Paragraphs, descriptions, first letter of sentences

Example

Paste in a messy, inconsistently-cased list like:

john SMITH
mary o'Brien
DAVID lee

Click Title Case and every entry becomes properly capitalized: John Smith, Mary O'brien, David Lee — ready to drop into a report or spreadsheet without manual retyping. This kind of inconsistent capitalization is extremely common in data collected from multiple sources, like combining a CRM export with a spreadsheet where different people entered names differently.

Key Features

Four case conversion modes in one tool: UPPERCASE, lowercase, Title Case, Sentence case.
Works on multi-line text, converting every line at once.
Instant conversion with no page reload.
One-click copy of the converted result.
Runs fully in your browser — nothing you paste is sent anywhere.

Practical Use Cases

Cleaning up data entry: normalize names or addresses that were typed with inconsistent capitalization.
Writing headlines: quickly convert a sentence to Title Case for a blog post or page heading.
Fixing Caps Lock accidents: instantly fix text that was accidentally typed in all caps.
Preparing display labels: convert database values (often lowercase) into Title Case for user-facing display.
Standardizing imported data: normalize casing across records pulled from multiple different sources before merging them.

Tips for Best Results

Review Title Case output for brand names or acronyms that need manual correction, since the tool applies a consistent capitalization rule to every word.
Use lowercase conversion before comparing two text values, if your comparison needs to be case-insensitive but your comparison tool isn't.
Combine with the Whitespace Trimmer if your text also has inconsistent spacing alongside inconsistent capitalization.

Related Terminology

Title Case capitalizes the first letter of most words, commonly used for titles and headings. Sentence case capitalizes only the first letter of the first word (plus proper nouns), matching how a normal sentence is written. Note that automated Title Case conversion capitalizes every word, including short words like "a" or "the" that some style guides leave lowercase — review the result if you're following a strict editorial style guide.

Important Considerations

Because this is a straightforward, rule-based conversion, it doesn't know about proper nouns or brand names with unusual capitalization (like "iPhone" or "eBay") — those may need manual adjustment after conversion. Apostrophes within words (like "O'Brien") are treated as word boundaries in Title Case, which can affect capitalization after the apostrophe.

Related Tools

Need to reverse the order of characters or words instead of changing case? Try the Text Reverser. For counting words and characters after converting, use Text Statistics. If your text has extra spaces to clean up too, the Whitespace Trimmer pairs well with this tool.

Frequently Asked Questions

How do I convert text to uppercase online?

Paste your text into the Input box and click the UPPERCASE button — the converted text appears instantly and can be copied with one click.

What's the difference between Title Case and Sentence case?

Title Case capitalizes the first letter of most words (e.g. "The Quick Brown Fox"), while Sentence case only capitalizes the first letter of the sentence (e.g. "The quick brown fox").

Can I convert multiple lines of text at once?

Yes, the tool converts every line in the Input box at once — there's no need to convert text line by line.

Will this tool fix capitalization on brand names correctly?

Not automatically — since it applies a consistent rule to every word, names with unusual internal capitalization (like "iPhone") may need a manual fix after conversion.

Does apostrophe placement affect Title Case results?

Yes, apostrophes within a word (like in "O'Brien") are treated as word boundaries, which can affect how the letters after the apostrophe are capitalized.

Duplicate Line Remover

Remove duplicate lines, optionally sort alphabetically or by length.

Input

Output

Number Extractor

Extract all integers, decimals, and percentages from text.

Input

Output

Character Counter

Count characters, words, and lines with detailed stats.

Input

Stats

Text Reverser

Reverse strings, words, or the order of lines.

Input

Output

Find & Replace

Bulk replace multiple strings at once — add as many find/replace conditions as you need.

Input

Output

Find & Replace Conditions

Prefix / Suffix Stamper

Add custom prefix and suffix to every line.

Input

Output

Whitespace Trimmer

Strip, collapse, or remove all whitespace. "Clean All" does both trim and collapse in one click.

Input

Output

Column Extractor

Extract specific columns from CSV/TSV data.

Input (CSV/TSV)

Output

Split by Chunk

Split a long string into fixed-width chunks.

Input

Output

Alphabetical Sorter

Sort lines A→Z, Z→A, or by line length.

Input

Output

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

Case Converter — Convert Text to UPPERCASE, lowercase, Title Case & Sentence Case

⚡ Key Takeaways

What, Who, When & Why

How to Use the Case Converter

What Each Case Option Does

Example

Key Features

Practical Use Cases

Tips for Best Results

Related Terminology

Important Considerations

Related Tools

Frequently Asked Questions

How do I convert text to uppercase online?

What's the difference between Title Case and Sentence case?

Can I convert multiple lines of text at once?

Will this tool fix capitalization on brand names correctly?

Does apostrophe placement affect Title Case results?

Archived Notes

Tools for analysts, developers & QA engineers

For Analysts

For Developers

For QA Engineers

Core Tools

SQL Tools

Productivity

Analysis

Design