Data & CSV
tools and calculators.
55 practical tools with clear inputs and explanations. Choose a tool below, or explore a role-based toolbox for a collection that fits your day.
CSV dataset diff
Compare two keyed datasets and export exact record and cell changes.
CSV rule validator
Check required fields and declared column types without uploading records.
CSV calculated column
Apply a safe mathematical expression to a numeric column and append the result.
CSV rank and percentile
Rank rows with clear tie rules and retain the original record order.
Grouped CSV rolling window
Add trailing moving summaries while keeping groups and input order intact.
Grouped CSV fill down
Carry previous non-empty values forward separately within each group.
CSV value recoder
Apply an explicit whole-cell value map without substring replacements.
CSV identifier padding
Pad textual IDs to a fixed minimum width without losing leading zeros.
CSV date reformatter
Reformat a column of strict ISO dates without locale guessing.
CSV numeric string cleaner
Remove declared grouping and currency wrappers while preserving decimal digits.
CSV split cells into rows
Expand list-valued cells into separate records using a literal separator.
CSV group and concatenate
Collect text values into one ordered list per group.
CSV side-by-side combiner
Combine tables by row position with strict or blank-padded alignment.
CSV missingness map
Visualise empty-cell patterns and compare completeness across columns.
CSV record card maker
Turn table rows into printable cards with a safe local HTML preview.
CSV to SQL INSERT statements
Build quoted INSERT statements while retaining text identifiers and values.
CSV file splitter
Split a table into a ZIP of grouped or fixed-size CSV files.
CSV points to GeoJSON
Build a GeoJSON FeatureCollection from latitude and longitude columns.
JSON observed-shape summary
Inspect path types and occurrence counts across a nested JSON document.
JSON array & NDJSON converter
Convert between an array and one JSON value per line while preserving numeric tokens.
NDJSON record filter
Filter private line-delimited records using a JSON Pointer and typed equality.
CSV heatmap builder
Explore a numeric matrix as a labelled heatmap, with readable values and SVG export.
CSV chart builder
Turn a local CSV into a bar, line or scatter chart with editable columns and SVG export.
CSV viewer
Open a CSV as a readable table, without uploading it.
CSV to JSON
Turn CSV rows into a JSON array of objects.
JSON to CSV
Convert a JSON array of objects into a downloadable CSV.
CSV crosstab
Cross-tabulate categories with counts, sums or averages.
Simple linear regression
Fit a straight line to paired numeric observations.
Text list to CSV
Turn one item per line into a safely quoted single-column CSV.
Transpose CSV
Swap a small CSV’s rows and columns.
Select CSV columns
Keep chosen columns and put them in a different order.
Filter CSV rows
Keep rows matching a literal text or numeric condition.
Sort CSV rows
Sort an export by one column while retaining its header.
Join two CSV tables
Match rows across two tables using a shared identifier.
CSV grouped summary
Summarise a numeric column separately for each category.
Remove duplicate CSV rows
Keep the first row for each complete record or chosen key.
Fill empty CSV cells
Replace empty values across a table or in one column.
CSV column profile
Inspect missing values, distinct values and numeric summaries by column.
Rename CSV columns
Apply an explicit heading map while preserving cell contents.
CSV wide to long
Turn measurement columns into variable/value rows.
CSV long to wide
Turn identifier/variable/value records into a wider table.
Combine CSV tables
Append two tables with matching headings or align a union of their columns.
Add CSV row numbers
Add a sequential identifier column without changing the original cells.
Split a CSV column
Separate a cell into several columns using a literal separator.
Combine CSV columns
Join selected cells into a new column with your chosen separator.
Clean CSV cell whitespace
Trim cell edges or collapse internal whitespace without changing headings.
Find & replace in CSV cells
Replace literal text inside selected cells while keeping the table structure.
Round a CSV numeric column
Round decimal values with exact half-away-from-zero ties.
Extract unique CSV values
Export one column’s distinct values in first-seen or sorted order.
Sample CSV rows
Choose a random subset of complete rows without replacement.
CSV category frequency table
Count exact categories and compare their shares of a selected column.
CSV percentage of total
Append each numeric value’s share of its column total.
CSV running total
Append a cumulative numeric total in the table’s current order.
CSV lagged change
Compare each numeric value with an earlier row in the current order.
Extract CSV date parts
Add calendar fields from a strict ISO date column.