webutilities.tools

CSV Pivot

Create a cross-tabulation (pivot table) from flat CSV data. Specify row key, column key, aggregation field, and function (count, sum, mean).

In: csvOut: csvTask: transform

CSV Pivot

Create a cross-tabulation (pivot table) from flat CSV data. Specify row key, column key, aggregation field, and aggregation function.

Shareable input links

You can prefill this tool by adding ?input=... to the URL. Tip: URL-encode JSON/text values before sharing.

JSON Envelope (CSV + Pivot Config)

Provide JSON with 'csv' (CSV text), 'rowKey' (row grouping column), 'colKey' (column grouping column), 'value' (value column), and 'agg' (count|sum|mean).

Pivot Table (CSV)

Cross-tabulated CSV with rows, columns, and aggregated values.

region,Feb,Jan
North,120,100
South,140,150

Workspace actions

Use this to reshape data into a summary table. Similar to Excel pivot tables or SQL cross-joins with aggregation. Mean aggregation handles floating-point precision internally.

Split editor

Example input and output

Example CSV

{
  "csv": "region,month,sales\nNorth,Jan,100\nSouth,Jan,150\nNorth,Feb,120",
  "rowKey": "region",
  "colKey": "month",
  "value": "sales",
  "agg": "sum"
}

Example CSV

region,Jan,Feb
North,100,120
South,150,

Related tools

CSV to JSON Converter

csv-tools

Convert CSV rows with headers into a clean JSON array.

In: csvOut: json

JSON to CSV Converter

csv-tools

Convert a JSON array of objects into CSV with generated headers.

In: jsonOut: csv

CSV Validator

csv-tools

Validate CSV syntax and structure — checks column consistency, unclosed quotes, and empty headers.

In: csvOut: text

CSV Formatter

csv-tools

Normalize CSV by parsing and re-emitting with consistent quoting and proper cell escaping.

In: csvOut: csv

CSV Viewer (Table View)

csv-tools

Render CSV data as an interactive table for quick visual inspection.

In: csvOut: table

CSV Column Extractor

csv-tools

Keep only the columns you need. Specify column names and get a slimmed-down CSV.

In: csvOut: csv

CSV Column Remover

csv-tools

Drop unwanted columns from a CSV. Specify which columns to remove and get a cleaned result.

In: csvOut: csv

CSV Deduplicator

csv-tools

Remove duplicate rows from a CSV, keeping the header and the first occurrence of each unique row.

In: csvOut: csv

CSV Cleaner

csv-tools

Trim whitespace and normalize CSV records before conversion.

In: csvOut: csv

CSV to XML Converter

csv-tools

Convert CSV rows into XML records. Each row becomes a record element inside a records root.

In: csvOut: xml

CSV to HTML Converter

csv-tools

Convert CSV content into a standalone HTML table document for browser-friendly sharing.

In: csvOut: html

XML to CSV Converter

xml-tools

Convert a structured XML document with repeating record elements into CSV rows.

In: xmlOut: csv

CSV to YAML Converter

csv-tools

Convert CSV rows into YAML arrays of objects.

In: csvOut: yaml

YAML to CSV Converter

yaml-tools

Convert YAML arrays of records into CSV rows.

In: yamlOut: csv

CSV Sorter

csv-tools

Sort CSV rows by one or more columns.

In: csvOut: csv

CSV Filter

csv-tools

Filter CSV rows by column conditions.

In: csv, queryOut: csv

CSV Join/Merge Tool

csv-tools

Join two CSV datasets on a shared key.

In: csvOut: csv

CSV Splitter

csv-tools

Split CSV content into smaller row chunks.

In: csvOut: csv

CSV Transpose

csv-tools

Transpose CSV rows and columns.

In: csvOut: csv

CSV Header Editor

csv-tools

Rename, add, or remove CSV headers.

In: csvOut: csv

CSV Delimiter Converter

csv-tools

Convert CSV between comma, semicolon, tab, and pipe delimiters.

In: csvOut: csv

CSV Statistics

csv-tools

Compute row/column stats and numeric summaries for CSV data.

In: csvOut: json

CSV Formula Applier

csv-tools

Add computed CSV columns with basic arithmetic formulas.

In: csvOut: csv

CSV Encoding Converter

csv-tools

Convert CSV text between UTF-8, Latin-1, and Windows-1252 encodings.

In: csvOut: csv

Excel to CSV Converter

csv-tools

Convert a base64-encoded XLSX workbook sheet into CSV.

In: xlsxOut: csv

CSV to Excel Converter

csv-tools

Convert CSV text into an XLSX base64 output envelope.

In: csvOut: xlsx

CSV Column Profiler

csv-tools

Profile CSV columns with inferred type, emptiness, uniqueness, top values, and numeric percentiles.

In: csvOut: json

Universal Converter

json-tools

Auto-detect sources and convert across supported JSON, XML, YAML, CSV, and Excel pairs, including structured JSON input and Excel base64 envelopes.

In: textOut: json, xml, yaml, csv, xlsx

Data Generator

json-tools

Generate deterministic mock records for JSON/CSV/XML/YAML testing.

In: jsonOut: json, csv, xml, yaml

CSV Row Transformer

csv-tools

Apply per-column transformation rules to CSV data. Chain operations like trim, uppercase, lowercase, rounding, date conversion, and find-replace.

In: csvOut: csv

CSV Data Generator

csv-tools

Generate mock CSV with configurable columns including uuid, email, integer, float, date, boolean, enum, and name.

In: jsonOut: csv

CSV Chart Viewer

csv-tools

Plot numeric CSV columns as a bar or line chart. Choose axes and chart type; runs 100% in the browser.

In: csvOut: rendered-chart

CSV Heatmap Viewer

csv-tools

Render CSV as a color-graded table where numeric cells are colored from cool (low) to warm (high) within each column.

In: csvOut: rendered-table

Scroll horizontally to view all related tools.

Reverse tools

No reverse tool detected for this format pair

Next steps

No mapped next steps yet

Included in workflows

Pivot CSV for Reporting

Create a cross-tabulation of CSV data with aggregated metrics.

Intermediate~3 min

Pivot CSV and Validate

Create a pivot table from CSV data, then validate the output.

Intermediate~3 min

Pivot CSV Then Analyze

Create a pivot table from CSV, then profile the output columns.

Intermediate~4 min