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

Whitespace Trimmer — Trim, Collapse & Remove Extra Spaces from Text

The Whitespace Trimmer fixes messy spacing in pasted text — trimming leading and trailing spaces, collapsing repeated spaces and tabs into one, or stripping all whitespace entirely. It's built for anyone who needs to remove extra spaces from text copied from a spreadsheet or PDF, where inconsistent whitespace often causes hidden formatting problems. Paste your text, pick a mode, and get clean output instantly.

⚡ Key Takeaways

Four modes: Trim Edges, Collapse, Clean All (both at once), and Remove All.
Collapse correctly handles mixed tab-and-space sequences, not just repeated plain spaces.
Hidden whitespace is a common, invisible cause of failed exact-match lookups.
Clean All is the safest default for most everyday cleanup tasks.

What, Who, When & Why

What it's for	Trims, collapses, or removes whitespace from text — fixing spacing issues from spreadsheets, PDFs, or copy-paste.
Who it's for	Anyone working with pasted data where invisible extra spaces cause formatting or comparison problems.
When to use it	When text looks fine visually but behaves oddly — like a lookup failing to match values that appear identical.
Why it's needed	Extra whitespace is invisible on screen but breaks exact-match comparisons in spreadsheets, databases, and scripts.
Best way to use it	Use Clean All as your default choice, and treat unexplained 'value not found' errors as a cue to check for hidden whitespace first.

How to Use the Whitespace Trimmer

Paste your text into the Input box.
Click Trim Edges to remove leading/trailing whitespace from each line.
Click Collapse to reduce repeated spaces and tabs down to a single space.
Click ✨ Clean All to do both trim and collapse in one step.
Click Remove All to strip every whitespace character, including line breaks.

Example

Given text copied from a spreadsheet with inconsistent spacing:

  hello    world  
   line two

Clicking Clean All trims the edges and collapses internal gaps, producing:

hello world
line two

This kind of hidden extra whitespace is a common, hard-to-spot cause of bugs when comparing strings or importing data — two values that look identical on screen can fail an exact-match comparison if one has a trailing space the other doesn't.

Key Features

Trim Edges — removes leading and trailing whitespace from every line.
Collapse — reduces multiple spaces or tabs (including mixed sequences) to a single space.
Clean All — combines trimming and collapsing in one click for a full cleanup.
Remove All — aggressively strips every whitespace character for a fully compact result.

Practical Use Cases

Cleaning spreadsheet exports: fix inconsistent spacing that often appears when copying from Excel or Google Sheets.
Preparing text for comparison: normalize whitespace before running a diff so formatting differences don't obscure real changes.
Cleaning PDF-copied text: fix the irregular spacing that frequently results from copying text out of PDF documents.
Preparing code or data for import: strip stray whitespace that could cause parsing errors elsewhere.
Fixing failed exact-match lookups: resolve mysterious "value not found" issues caused by invisible trailing whitespace.

Tips for Best Results

If two values that look identical fail to match in a spreadsheet formula or database query, trimming whitespace is one of the first things worth checking.
Use Clean All as your default choice unless you specifically need to preserve internal spacing for formatting reasons.
Run text through this tool before using the Text Comparator, so whitespace differences don't create false "changes" in your diff.

Related Terminology

Whitespace refers to any non-printing character used for spacing, including regular spaces, tabs, and line breaks. Trimming removes whitespace from the start and end of a line without touching internal spacing, while collapsing reduces internal runs of whitespace (including mixed tabs and spaces) down to a single space.

Important Considerations

The "Remove All" mode strips line breaks along with spaces, which merges all your text onto effectively one continuous block — use "Clean All" instead if you want to preserve line structure while still fixing spacing issues within each line. Whitespace differences are invisible on screen but can break exact-match comparisons, so this is often a useful first troubleshooting step when two seemingly identical values don't match in a spreadsheet or script.

Related Tools

After cleaning whitespace, the Text Comparator can more accurately show real content differences without whitespace noise. To also fix inconsistent capitalization, pair this with the Case Converter. For a character count that reflects the cleaned text, check Character Counter.

Frequently Asked Questions

How do I remove extra spaces from text?

Paste your text and click Collapse to reduce repeated spaces to one, or Clean All to also trim leading/trailing whitespace at the same time.

What's the difference between Collapse and Clean All?

Collapse only reduces internal repeated whitespace within each line. Clean All does that plus trims leading and trailing whitespace from each line in a single step.

Does Remove All delete line breaks too?

Yes, Remove All strips every whitespace character including line breaks, merging your text into one continuous block — use Clean All instead if you want to keep your line structure.

Can hidden whitespace really cause a lookup or comparison to fail?

Yes — a trailing space or tab is invisible on screen but will cause an exact-match comparison (like a spreadsheet VLOOKUP or a database WHERE clause) to fail even when two values look identical.

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

Whitespace Trimmer — Trim, Collapse & Remove Extra Spaces from Text

⚡ Key Takeaways

What, Who, When & Why

How to Use the Whitespace Trimmer

Example

Key Features

Practical Use Cases

Tips for Best Results

Related Terminology

Important Considerations

Related Tools

Frequently Asked Questions

How do I remove extra spaces from text?

What's the difference between Collapse and Clean All?

Does Remove All delete line breaks too?

Can hidden whitespace really cause a lookup or comparison to fail?

Archived Notes

Tools for analysts, developers & QA engineers

For Analysts

For Developers

For QA Engineers

Core Tools

SQL Tools

Productivity

Analysis

Design