BNS Data Tools

Free privacy-first data and developer utilities. 208 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.

Code

Language-independent code utilities: diff, complexity, comments and whitespace.

Bracket Checker Finds the unclosed bracket, quote or comment and reports where it was opened.
Code Line Counter Separates code lines from comment and blank lines, so the number means something.
Comment Stripper Removes comments from source, leaving anything that only looks like a comment inside a string alone.
Complexity Estimator Estimates cyclomatic complexity per function by counting branch points in real code.
Duplicate Block Finder Finds blocks of code repeated in a file, ignoring comments and indentation.
Identifier Case Converter Converts identifier names between the five common conventions and flags collisions.
Indentation Converter Converts leading tabs to spaces or back, and reports mixed indentation.
Line Ending Converter Converts between CRLF, LF and CR endings and reports mixed or missing ones.
Regex Tester Shows every match of a pattern with its line, position and capture groups.
TODO Extractor Lists every tagged comment with its line number, searching comments only.

JavaScript

Format, inspect and run JavaScript in a sandboxed worker isolated from this site.

JavaScript Beautifier Reformats minified or messy JavaScript into consistently indented code.
JavaScript Benchmark Runner Times a snippet over many iterations and says when the result is too small to believe.
JavaScript Expression Evaluator Evaluates one expression per line and shows the result of each beside it.
JavaScript Minifier Removes comments and whitespace without touching strings or regular expressions.
JavaScript Object to JSON Converts a JavaScript object literal into valid, formatted JSON.
JavaScript Sandbox Runs a snippet in a disposable worker and shows everything it logged and returned.
JavaScript Syntax Checker Says whether a snippet parses, and shows the engine error if it does not.
JSON to JavaScript Object Turns JSON into a readable JavaScript object literal you can paste into source.

Python

Read a traceback, audit imports and type hints, pull out docstrings, parse and diff requirements, and convert between a Python literal and JSON - all without running any Python.

JSON to Python Dict Writes JSON out as a Python dict literal, with True, False, None and your choice of quotes.
Pip Freeze Diff Compares two pip freeze outputs and reports every package that was added, removed, upgraded or downgraded.
Python Dict to JSON Turns a Python literal into valid JSON and names every type that had to change on the way.
Python Docstring Extractor Pulls out every docstring in a module and shows which definitions are missing one.
Python Import Analyser Lists every import in a module, sorts them by origin, and counts how often each name is used.
Python Traceback Parser Turns a wall of traceback text into a table and points at the deepest frame that is your own code.
Python Type Hint Coverage Reports annotation coverage per function and names the parameters and returns that have none.
Requirements.txt Parser Breaks a requirements file into packages, extras, specifiers and markers, and flags the loose ones.

Database

Physical database design: what a row and an index really cost, which key and column order to use, and how types map between engines.

Connection Pool Calculator Sizes a connection pool from throughput and query time, and warns when it is too big.
Data Type Mapper Maps column types between seven database engines, keeping length and precision.
Index Column Order Advisor Reads your WHERE and ORDER BY clauses and puts the index columns in the order that works.
Index Size Estimator Estimates what each index on a table costs on disk, and how deep its tree gets.
Isolation Level Advisor Names the anomaly you are describing and the lowest isolation level that prevents it.
Primary Key Advisor Reviews the primary key on each table and says what it will cost you.
Row Size Calculator Turns a CREATE TABLE into a byte-by-byte row cost, then into a table size.
Sequence Exhaustion Calculator Says when an auto-increment key runs out, at your insert rate and growth.

Data Quality

Completeness, uniqueness, validity, outliers, PII patterns and quality scoring.

Column Classifier Names what each column of a CSV holds, how sure it is, whether it is personal data, and which validators apply to it.
Completeness Calculator Completeness per column against a threshold, with empty, whitespace and N/A counted apart.
CSV Cleaner The safe, explainable half of cleaning: whitespace, invisible characters, null tokens, empty rows and columns.
Missing Value Analyzer Groups rows by which fields are missing, so a broken load shows up as one pattern instead of several sparse columns.
Null Analyzer Lists the actual strings each column uses to mean nothing, so you can write the replacement rule.
Outlier Detector Runs three outlier tests on every numeric column and reports which of them flagged each value.
Pattern Detector Works out what each column holds and lists the rows that do not match it.
PII Detector Finds columns holding personal data, by value and by column name, and masks every example it shows.
Quality Scorecard One score across six weighted dimensions, with what each one measured and what pulled it down.
Validity Rule Checker Checks each column against rules you write and lists every violation with its row number.
Value Validator One value per line, checked against the validator you choose, with check digits verified and personal identifiers masked.

Data Engineering

Cron, partitioning, throughput, retention and pipeline sizing calculators.

Batch Window Calculator Says whether a job fits its window, and how many rows it takes before it stops fitting.
Cron Schedule Builder Plain English in, cron expression and the next three firing times out.
Data Contract Generator Drafts a YAML or Markdown data contract from a sample, leaving the human decisions as TODOs.
DDL to Data Dictionary Turns CREATE TABLE statements into a Markdown data dictionary, one table per section.
Incremental Load SQL Generator Writes a watermark-based incremental extract query from a CREATE TABLE statement.
Partition Size Calculator Compares every partition grain by size per partition and partition count at full retention.
Retention Policy Calculator Prices a hot, warm, cold and archive retention policy tier by tier.
SCD Type 2 Generator Builds a Type 2 dimension table and its load statement from a CREATE TABLE statement.
Storage Growth Calculator Size and monthly cost projected to five years, with compression, indexes, replicas and retention applied.
Throughput Calculator Daily volume in, sustained rate, peak rate, bandwidth and worker count out.

Data Architecture

Data dictionaries, lineage, classification, RTO/RPO and architecture matrices.

Data Architecture Checklist Your table of contents against the twenty-one sections a data architecture document is expected to cover.
Data Classification Helper Column names in, suggested classification tier and the handling it requires out.
Naming Convention Checker Paste names, pick a case convention, and get the ones that break it with the rename already written.
Naming Standards Validator Checks names against the rules that have a reason behind them, with the reason stated for each finding.
Normalisation Checker Reads your DDL and raises the shapes that usually accompany a first, second or third normal form problem.
RTO and RPO Calculator Backup interval, volume and restore rate in; achievable RTO and RPO out, against the targets you claim.
Source to Target Mapping Generator Two column lists in, a draft STM out with the gaps and the dropped columns called out explicitly.

Cloud & Platform

Storage sizing, capacity helpers and cloud resource identifier parsing.

AWS ARN Parser Splits ARNs into their six fields and flags the ones that will silently match nothing.
Bucket Name Validator Checks names against the provider rules before the create call does it for you.
CIDR Subnet Calculator Subnet arithmetic for VPC planning, counting the five addresses each cloud reserves rather than the traditional two.
Cloud Storage Cost Calculator Storage, requests and retrieval costed across four tiers, with the minimum-duration trap made explicit.
Cloud Storage URI Parser Bucket, prefix, object and Hive partitions from any object-storage URI, plus the equivalent HTTPS and CLI forms.
Connection String Parser Parses any of the three common connection string styles and never puts the password in the output.
Data Egress Cost Calculator The same bytes costed to six destinations, with roughly a factor of nine between the cheapest and the dearest.
Warehouse Credit Calculator Monthly and annual cost by warehouse size, with the break-even runtime for every size above and below yours.

Charts

Render CSV and JSON as charts, and generate diagram source, in the browser.

Bar Chart Generator Paste a table, get an SVG bar chart you can download, edit and scale to any size.
Box Plot Generator Quartiles, whiskers and outliers for one group or many, drawn as a downloadable SVG box plot.
Heatmap Generator A grid of numbers coloured by value, with a sequential or a zero-centred diverging scale.
Histogram Generator A distribution chart from a column of numbers, with the bin width chosen for you or by you.
Line Chart Generator A line or area chart from any CSV, drawn as SVG in the page and downloadable as a file.
Pie Chart Generator A pie or donut chart with percentages worked out and the long tail folded into one slice.
Scatter Plot Generator An XY scatter plot with a least-squares trend line and the correlation coefficient stated.
Sparkline Generator A small inline trend line sized to sit in a table cell, with high, low and latest marked.

Files

Inspect the structure, encoding and contents of a local file in your browser. Nothing is uploaded.

CSV File Inspector Reports what a CSV file actually contains, and where the rows that break it are.
File Encoding Detector Tells you whether a text file is plain ASCII, clean UTF-8, or already damaged.
File Head and Tail Viewer Shows the first and last lines of a file with their line numbers, and nothing in between.
Fixed Width File Inspector Infers the column layout of a fixed width file when nobody can find the copybook.
Invisible Character Finder Finds the characters you cannot see, and gives each one a line and column.
JSON File Inspector Says whether a JSON file is valid, where it breaks, and what shape it is.
Log File Summarizer Turns a wall of log lines into level counts, a time span and the messages that repeat.
NDJSON File Inspector Validates every line of a JSON Lines file and finds the keys that drift between records.

Web Security

Review cookies, CORS, JWTs, SPF, DMARC, security.txt and secrets by pasting them in. These tools never contact, scan or attack any site.

Cookie Security Analyzer Audits Set-Cookie headers for the flags and prefixes that decide whether a cookie can be stolen or over-shared.
CORS Policy Analyzer Reads the Access-Control response headers together and flags the origin and credentials combinations that leak data.
DMARC Record Explainer Explains each DMARC tag and flags the monitor-only p=none policy and a missing report address.
JWT Security Auditor Audits a JWT for alg none, missing or excessive expiry and sensitive claims - without verifying the signature.
Mixed Content Scanner Finds http:// and protocol-relative resources in HTML and separates the active loads a browser blocks from passive ones.
Password Strength Estimator Estimates password entropy and a rough offline crack time locally - the password is never sent or stored.
Secret Leak Scanner Scans pasted code, config or logs for committed secrets and shows any matches truncated. Heuristic, runs locally.
security.txt Validator Checks a security.txt against RFC 9116 - mandatory Contact and Expires, plus the recommended fields.
SPF Record Explainer Explains each SPF mechanism and counts the DNS lookups against the limit of ten that makes a record fail.
SRI Hash Generator Generates a Subresource Integrity hash and the full integrity attribute from pasted file contents, using Web Crypto.
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.