BNS Data Tools

Free privacy-first data and developer utilities. 112 utilities, each one page, each doing one thing. Processing happens locally in your browser.

JSON

Format, validate, convert and inspect JSON in your browser. No upload, no account.

JSON Analyser Measures a document — size, depth, node counts, type breakdown and the largest values it contains.
JSON Diff Compares two JSON documents by structure and lists every path that was added, removed or changed.
JSON Flattener Flattens nested JSON into single-level dotted keys, and rebuilds the nesting from them.
JSON Formatter Turns minified or inconsistently indented JSON into readable, consistently indented text.
JSON Key Sorter Sorts every object key in a document alphabetically, recursively, so diffs stay stable.
JSON Minifier Removes all insignificant whitespace from JSON and reports the byte reduction.
JSON Path Finder Lists every leaf path in a document with its value and type, so you can copy the accessor you need.
JSON Schema Generator Infers a draft JSON Schema from a sample document, including types, required keys and array item shapes.
JSON String Escaper Escapes text for embedding inside a JSON string, and unescapes a JSON string back to plain text.
JSON to CSV Converts an array of JSON objects into CSV, flattening nested objects into dotted column names.
JSON to XML Converts JSON into well-formed XML, with control over the root and repeated element names.
JSON to YAML Converts JSON into equivalent YAML with the quoting rules YAML actually requires.
JSON Validator Checks a document against the JSON grammar and reports exactly where parsing fails.
JSONL to JSON Converts newline-delimited JSON into a single array, and back again.

CSV

Convert, clean, profile and analyse CSV files locally in your browser.

CSV Column Profiler Profiles each column for inferred type, completeness, distinct values and numeric range.
CSV Column Selector Keeps or drops named columns, returning them in the order you listed.
CSV Delimiter Converter Rewrites a delimited file with a different separator, re-quoting fields as needed.
CSV Diff Compares two files on a key column and reports added, removed and changed values.
CSV Duplicate Remover Removes repeated rows, matching either on the whole row or on named key columns.
CSV Header Cleaner Rewrites column names to a consistent naming convention and resolves duplicates.
CSV Join Joins two delimited files on a shared column, with a left or inner join.
CSV Row Filter Keeps only the rows where one column matches the condition you set.
CSV Sorter Sorts rows by a named column, treating numeric columns as numbers rather than text.
CSV Splitter Splits a file into fixed-size chunks, repeating the header on every part.
CSV to HTML Table Converts delimited rows into semantic HTML table markup with escaped values.
CSV to JSON Converts delimited rows into an array of JSON objects keyed by the header row.
CSV to Markdown Table Converts delimited rows into a GitHub-flavoured Markdown table.
CSV to SQL Insert Generates INSERT statements from delimited rows, quoted for the dialect you pick.
CSV to XML Converts delimited rows into well-formed XML with one element per row.
CSV Transposer Swaps rows and columns so a wide layout becomes a tall one, or the reverse.
CSV Validator Finds ragged rows, duplicate column names and unnamed columns, and reports where they are.
CSV Viewer Renders a delimited file as a readable table, including quoted fields and embedded line breaks.
TSV to CSV Converts tab-separated text to comma-separated, quoting values that need it.

SQL

Format, parse, analyse and convert SQL and DDL across dialects, in the browser.

CSV Header to CREATE TABLE Generates a CREATE TABLE skeleton from a CSV header row, with cleaned identifier names.
DDL to ERD Generates Mermaid ER diagram source from CREATE TABLE statements and their declared foreign keys.
Schema Diff Compares two DDL scripts and lists every structural difference between them.
SQL Comment Remover Strips line and block comments without disturbing comment characters inside string literals.
SQL DDL Parser Reads CREATE TABLE statements and lists every column with its type, nullability, key role and default.
SQL Formatter Re-prints a query with one clause per line, consistent keyword case and readable indentation.
SQL IN Clause Builder Turns a pasted list of values into a quoted, de-duplicated, line-wrapped IN clause.
SQL Lineage Extractor Reads write statements and lists which source tables feed which target tables.
SQL Merge Generator Builds an upsert statement from a table definition and the key columns you nominate.
SQL Minifier Collapses a statement to a single line and removes comments, keeping literals intact.
SQL String Escaper Escapes text as a SQL string literal for standard SQL or MySQL quoting rules.
SQL Table Extractor Lists every table a statement references and whether it is read from or written to.

XML

Format, validate and convert XML and XSD in your browser.

XML Escape and Unescape Escapes text so it can be dropped into XML content or a quoted attribute, and decodes entity references back to plain text.
XML Formatter Re-indents XML so its structure is readable, keeping text-only elements on one line so no whitespace enters a value.
XML Minifier Removes comments and the whitespace between elements, and reports how many bytes that saved.
XML Path Finder Lists every distinct element and attribute path in a document, with an occurrence count and the first value found at each.
XML Statistics Counts elements by name, distinct attributes, text nodes and nesting depth so you can size a document before writing code against it.
XML to CSV Finds the repeated element in an XML document, treats it as a row, and flattens its children and attributes into columns.
XML to JSON Converts an XML document to JSON, stating plainly which shape decisions it made and why they matter.
XML Validator Checks that XML is well-formed — every tag closed, closed in the right order, one root — and names the line and column of the first failure.

YAML

Format, validate, merge and convert YAML in your browser.

YAML Formatter Re-prints a YAML document with consistent indentation and quoting, and is honest that comments do not survive the trip.
YAML Key Sorter Sorts mapping keys alphabetically at every level, leaving sequence order alone, so two configurations can be diffed meaningfully.
YAML Merge Merges an overlay document onto a base document and lists every value the overlay replaced.
YAML Path Finder Lists every leaf path in a configuration with its type and value, so a single setting can be named exactly.
YAML to JSON Converts YAML to JSON, and points out the type surprises that conversion exposes.
YAML to XML Converts YAML to XML, letting you name the root and the element used for sequence items.
YAML Validator Checks that a YAML document parses, and names the line where it stopped making sense.

Text

Diff, count, sort, de-duplicate and transform text without leaving the page.

Case Converter Converts text between the nine cases people actually need, including the four identifier conventions.
Character Frequency Counter Counts every distinct character with its share and its Unicode code point, which is how you find the invisible one.
Duplicate Line Remover Removes repeated lines while keeping the original order, or shows you only the duplicates instead.
Find and Replace Replaces every match across a block of text, by plain string, whole word or regular expression.
Line Numberer Adds a number to the front of every line, starting wherever you like, with optional zero padding.
Line Sorter Sorts lines alphabetically or in natural numeric order, so item2 comes before item10.
Slug Generator Turns a list of titles into URL slugs, folding accents and flagging any two that would collide.
Text Diff Compares two blocks of text line by line and lists exactly what was added and removed.
Whitespace Cleaner Strips trailing whitespace, collapses runs of spaces, converts tabs and tidies blank lines.
Word Counter Counts words, characters, UTF-8 bytes, lines, sentences and paragraphs, and estimates reading time.

Security

Hashing, encoding, token generation and defensive inspection, computed locally.

Base64 Decoder Decodes standard or URL-safe Base64 back to text, and shows binary payloads as hex rather than as damaged text.
Base64 Encoder Encodes text as standard or URL-safe Base64, and is clear that this is encoding rather than encryption.
Hash Comparison Hashes the same input with all five algorithms at once, which is how you work out which one produced a checksum you were given.
Hash Generator Produces an MD5, SHA-1, SHA-256, SHA-384 or SHA-512 digest of your text, computed on this page.
Hex Converter Converts text to its hexadecimal bytes and back, which is how you see what a string is actually made of.
HMAC Generator Signs a message with a shared secret using HMAC-SHA, so you can reproduce the signature a webhook sender computed.
HTML Escaper Escapes the five characters that matter for safe HTML, and decodes entities back the other way.
JWT Decoder Decodes a token’s header and payload, translates the time claims, and does not pretend to verify the signature.
Password Generator Generates random passwords from your browser’s cryptographic random source and reports the entropy of each.
Random String Generator Generates random strings in the alphabet you choose — hex, Base58, digits or alphanumeric — with an optional prefix.
URL Encoder Percent-encodes a value for a query string, or a whole URL, and decodes either direction back again.
UUID Generator Generates version 4 UUIDs in bulk from your browser’s cryptographic random source.

Date & Time

Timestamps, timezones, durations and business-day calculations.

Add or Subtract Time Shifts a whole list of dates forward or back, and says where a month end had to be clamped.
Age Calculator Turns a list of dates of birth into exact ages, as at today or any date you name.
Business Day Calculator Counts working days between dates, or adds business days to one, using your holidays and your weekend.
Cron Explainer Translates cron expressions into English and shows the next runs in the timezone you choose.
Date Difference Measures the gap between pairs of dates in calendar terms and in plain totals, both at once.
Date Format Converter Reformats a list of dates into one consistent form, and flags the ones that were ambiguous.
Duration Formatter Reads a duration in any of the four common notations and shows it in all of them.
ISO Week Calculator Gives the ISO 8601 week number, weekday, day of year and quarter for every date you paste.
Timestamp Converter Converts epoch and ISO timestamps into readable dates, in bulk, with the timezone spelled out.
Timezone Converter Converts a list of times between two IANA zones, applying daylight saving as it stood on each date.

Math & Statistics

Descriptive statistics, growth calculations and number-base conversion.

Correlation Calculator Measures how strongly two columns move together, with Pearson and Spearman side by side.
Data Size Converter Converts data sizes and shows the decimal and binary conventions side by side, because they are not the same.
Descriptive Statistics Summarises a column of numbers with the full set of descriptive measures, sample and population both.
Frequency Distribution Bins numbers into a frequency table with counts, percentages and a text histogram.
Growth Rate Turns a series into period-on-period change, cumulative change and a compound growth rate.
Number Base Converter Converts a list of numbers between bases and refuses to silently truncate a value that is invalid in the base you chose.
Percentage Calculator Handles the four percentage questions people actually ask, over a whole list at once.
Percentile Calculator Calculates percentiles both ways — interpolated and nearest-rank — so you can see where the two definitions disagree.
Sample Size Calculator Works out how many records you need to sample for a stated confidence and margin of error.
Weighted Average Calculates a weighted mean and shows what each row contributed, next to the unweighted mean.

API & Web

Parse URLs and headers, look up status codes and convert cURL commands.

CSP Analyzer Breaks a CSP into directives, flags the parts that weaken it and names the ones that are missing.
cURL Converter Converts a curl command into fetch, Python requests or PowerShell, with the shell quoting handled properly.
HTTP Header Analyzer Explains a block of HTTP headers, checks cookie flags and lists the security headers that are absent.
HTTP Status Codes Looks up status codes by number or name and says what to do about each, not just what it is called.
MIME Type Lookup Maps file extensions to Content-Type values and back, with notes on the ones people get wrong.
Query String Parser Breaks a query string into parameters, or builds an encoded one, with repeated keys called out.
robots.txt Validator Checks a robots.txt line by line and tests a path against it using the real longest-match rule.
Sitemap Generator Turns a list of URLs into a valid sitemap.xml, resolving relative paths and catching duplicates.
URL Parser Breaks a URL into its parts with the browser’s own parser, so the answer matches what a browser would do.
User Agent Parser Parses user agent strings into browser, version and platform, and names the bots.
Processing happens locally in your browser. What you paste or load is processed by this page and is not uploaded to a server. Nothing is stored unless you use a control that says it stores something, and you can clear anything this site has kept from the privacy page.