#Online data validation tools

Calculate the exact age from a birth date (years, months, days), in your browser.

Validate a card number with the Luhn algorithm and detect the network.

Change a CSV’s column separator (comma, semicolon, tab, pipe), in your browser.

Select and export one or more columns from a CSV, right in your browser.

Convert a CSV into a ready-to-paste HTML table (with header), right in your browser.

Convert a CSV into SQL INSERT statements (custom table name), in your browser.

Convert a CSV into an indented XML document, right in your browser.

Convert a CSV into YAML (list of objects) right in your browser.

Swap the rows and columns of a CSV (transpose), right in your browser.

Check a CSV for consistency: constant column count and well-formed rows.

Compute the duration between two dates (days, weeks, months, years), right in your browser.

Find the day of the week, day of the year and ISO week number of a date, in your browser.

Check an email address format (syntax, domain) right in your browser.

Simplify a fraction, or convert a decimal to a fraction, with decimal and percentage.

Compute the GCD (greatest common divisor) and LCM (least common multiple) of several numbers.

Validate an IBAN with the mod-97 checksum and show the country code.

Check an .ics file structure: VCALENDAR, VEVENT and required fields.

Convert an INI or .properties file into JSON, right in your browser.

Validate an ISBN-10 or ISBN-13 number using its check digit.

Compare two JSON documents and spot additions, deletions and changes, in your browser.

Escape or unescape a string to embed it in JSON, right in your browser.

Flatten nested JSON into dot-notation keys, or do the reverse (unflatten), in your browser.

Merge two JSON objects (deep merge), the second overriding the first, in your browser.

Generate a JSON Schema (draft 2020-12) from a JSON example, right in your browser.

Sort the keys of a JSON object alphabetically (recursive), right in your browser.

Convert JSON into a .env file (environment variables), right in your browser.

Convert a JSON array (list of objects) into a ready-to-paste HTML table, in your browser.

Convert JSON into TOML right in your browser, with no data uploaded.

Test a JSONPath expression on JSON and see the matching values, in your browser.

Convert a list (one item per line) into a JSON array (strings or numbers), in your browser.

Evaluate a math expression (operators, parentheses, functions) directly in your browser.

Compute the transpose, determinant and inverse of a matrix, right in your browser.

Generate fake JSON data (users: name, email, id…) for testing, in your browser.

Convert NDJSON (JSON Lines) into a JSON array and back, right in your browser.

Compute percentages: X% of Y, proportion, percentage change, in your browser.

Factor an integer into primes and test its primality, right in your browser.

Solve ax² + bx + c = 0: discriminant, real or complex roots, vertex.

Validate a French SIREN (9 digits) or SIRET (14 digits) number via Luhn.

Convert a list of values into a SQL IN ('a', 'b', 'c') clause, right in your browser.

Compute mean, median, mode, standard deviation, variance and quartiles of a set of numbers.

Check a SWIFT / BIC code format (8 or 11 characters) and break it down.

Convert a time from one timezone to another (DST-aware), in your browser.

Convert TOML to JSON and check its validity, right in your browser.

Convert TSV (tab-separated, e.g. copied from Excel) to JSON and back, in your browser.

Check the format of an EU intra-community VAT number (per country).

Indent and beautify XML, or minify it, right in your browser.

Indent and normalize a YAML file (beautify), right in your browser.

Check that a YAML file is syntactically valid and pinpoint the error line, in your browser.