Data & Math

Trims cells, normalises headers, fixes number and date formats and reports rows with the wrong column count.

Joins two tables on a key column with inner, left, right or outer semantics and shows unmatched rows.

Opens a large delimited file with type detection, column stats and sorting, without loading it all into memory.

Converts between about thirty currencies at the ECB’s daily reference rates, crossed through the euro, or at a rate you type in.

Counts days, weeks, months and years between two dates, with a D-day view and business-day option.

Works out percentage of, percentage change, discount, markup and reverse percentage in one place.

Converts a moment across timezones and shows a shared-hours grid for scheduling across regions.

Converts length, weight, area, volume, temperature, speed, pressure and data units, including Korean units.

Converts between epoch seconds, milliseconds, ISO 8601 and human dates in any timezone.

Counts working days between dates, or finds the date N working days out, excluding weekends and holidays.

Profiles each column with count, nulls, unique values, min, max, mean, median and distribution.

Projects the value of a lump sum or regular deposits at a given rate, with a year-by-year table.

Removes duplicate rows on all or selected key columns, keeping the first, last or most complete row.

Filters rows with column conditions, sorts on several keys and picks the columns to keep.

Splits a table by row count or by the distinct values of a column, into separate files with the header repeated in each.

Generates CREATE TABLE and INSERT statements from a table, with inferred types and a chosen dialect.

Converts bytes, KB, MB, GB and TB in both decimal and binary conventions, and computes transfer times.

Adds or subtracts days, weeks, months or years from a date, optionally skipping weekends and holidays.

Computes mean, median, mode, variance, standard deviation, quartiles and outliers from pasted numbers.

Factorises an integer and computes GCD, LCM, divisors and primality for one or several numbers.

Converts between binary, octal, decimal, hexadecimal and any base up to 36, with bitwise views.

Adds or removes thousand separators, rounds to a set precision and formats as currency or percent by locale.

Groups rows by one or two columns and aggregates with count, sum, average, min, max or distinct.

Draws a bar, line, area, pie or scatter chart from a table with round-number axes and a legend, and exports it as SVG or PNG.

Runs SQL against dropped CSV or TSV files in the browser — SELECT, WHERE, GROUP BY/HAVING, ORDER BY, LIMIT, CASE and a two-table JOIN — with the grammar on the page.

Compares two tables by a chosen or inferred key column and lists added, removed and changed rows cell by cell, side by side or as a change log.

Adds and subtracts hh:mm:ss durations, totals a column of times and converts to decimal hours.

Runs a two-proportion z-test and a chi-square test on two conversion rates with Wilson confidence intervals, and computes the sample size for a target effect and power.

Performs exact arithmetic on numbers far beyond 64 bits, including power, modulo and factorial.

Solves linear, quadratic and cubic equations with the working shown, finds real roots of other equations numerically, and solves linear systems by elimination.

Adds, subtracts, multiplies and divides fractions, reduces them and converts to and from decimals.

Multiplies, inverts, transposes and row-reduces matrices in exact rational arithmetic, and finds determinant, rank and trace.

Fits a linear, polynomial, exponential, logarithmic or power model to paired data and reports R², Pearson r, Spearman ρ and residuals.

Converts between Roman numerals and Arabic numbers, validating subtractive notation.