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

Column Extractor — Pull Specific Columns from CSV or Tab-Separated Data

The Column Extractor pulls specific columns out of CSV or tab-separated data by column number, without needing spreadsheet software. It's built for analysts who need to extract a column from CSV data quickly — isolating just the email column from an export, or pulling two specific fields out of a wider dataset — by pasting the data directly instead of opening it in Excel.

⚡ Key Takeaways

Pulls specific columns from CSV or tab-separated data by column number.
Works directly from pasted text — no spreadsheet software required.
Assumes a consistent column count across rows — irregular rows may extract unexpectedly.
Handles both comma-separated and tab-separated data without needing to convert first.

What, Who, When & Why

What it's for	Extracts specific columns from CSV or tab-separated data by column number.
Who it's for	Analysts who need just a few fields from a wider dataset without opening spreadsheet software.
When to use it	When you have a CSV export with more columns than you need and want to isolate just one or two.
Why it's needed	Opening a full spreadsheet application just to pull two columns is slower than pasting the data directly into a focused tool.
Best way to use it	Confirm every row in your source data has the same number of columns first, since inconsistent rows can shift which values get extracted.

How to Use the Column Extractor

Paste your CSV or tab-separated data into the Input box.
Specify which column number(s) you want to extract.
Click Extract to pull just those columns into the Output box.
Click Copy to grab the extracted columns.

Example

Given this CSV data:

a,b,c
1,2,3

Extracting columns 1 and 3 produces:

a,c
1,3

This lets you quickly isolate just the fields you need from a wider dataset without opening a spreadsheet application — useful when a full export has far more columns than you actually need for a specific task.

Key Features

Extract one or multiple columns by number.
Works with both comma-separated and tab-separated data.
Preserves row order from the original data.
No spreadsheet software required — works directly from pasted text.

Practical Use Cases

Isolating specific fields: pull just the email or ID column out of a wider CSV export.
Reducing data for sharing: extract only the relevant columns before sharing a dataset with a colleague, avoiding exposure of unrelated fields.
Preparing data for another tool: extract just the columns another system expects before importing.
Quick data review: check the values in a specific column without scrolling through a wide spreadsheet.
Building a simplified report: pull only the columns relevant to a specific analysis from a larger source export.

Tips for Best Results

Check that every row in your data has a consistent number of columns before extracting, since inconsistent rows can shift which values get pulled.
If your data is tab-separated rather than comma-separated, the tool handles both — no need to convert first.
Combine with the CSV ⇄ JSON Converter afterward if you need the extracted columns in JSON format instead of CSV.

Related Terminology

In tabular data, a column refers to a single field or attribute repeated across every row (like "email" or "date"), as opposed to a row, which represents one full record. Column numbering typically starts at 1 for the first (leftmost) column, matching how most spreadsheet applications reference columns by position.

Important Considerations

The extractor assumes consistent delimiters throughout your data — if some rows have a different number of columns than others (a common issue with messy exports, especially from systems that don't consistently quote or escape values), extraction may produce unexpected results for those rows. It's worth spot-checking the output against your original data for consistency, particularly with irregular or hand-edited source files.

Related Tools

Need the full dataset in JSON instead? Try the CSV ⇄ JSON Converter. To reformat the delimiter used in your data first, use the Delim Converter. Once extracted, sort the results with the Alphabetical Sorter.

Frequently Asked Questions

How do I extract a specific column from CSV data?

Paste your CSV data into the Input box, specify the column number you want, and click Extract — that column's values appear in the Output box.

Can I extract multiple columns at once?

Yes, specify multiple column numbers to extract more than one column in a single pass.

Does it work with tab-separated data, not just commas?

Yes, the tool works with both comma-separated and tab-separated data without needing to convert the delimiter first.

What happens if some rows have a different number of columns?

Extraction may produce unexpected results for those specific rows, since the tool assumes a consistent column structure — it's worth spot-checking the output if your source data is irregular.

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

Column Extractor — Pull Specific Columns from CSV or Tab-Separated Data

⚡ Key Takeaways

What, Who, When & Why

How to Use the Column Extractor

Example

Key Features

Practical Use Cases

Tips for Best Results

Related Terminology

Important Considerations

Related Tools

Frequently Asked Questions

How do I extract a specific column from CSV data?

Can I extract multiple columns at once?

Does it work with tab-separated data, not just commas?

What happens if some rows have a different number of columns?

Archived Notes

Tools for analysts, developers & QA engineers

For Analysts

For Developers

For QA Engineers

Core Tools

SQL Tools

Productivity

Analysis

Design