Schema inferrer and data dictionary generator
Load a CSV, JSON or JSONL file and get a schema inferred from the data: the type of each field, how often it is filled, ranges, distinct counts, top values and an example. Export it as JSON Schema, a Markdown data dictionary or a SQL CREATE TABLE statement. It runs entirely in your browser.
How to use it
- 01Load a file, or try the sample with nested customer records.
- 02Read the field table: type, fill rate, distinct values, range, top values and an example.
- 03Check the flags for mixed types, identifiers and free text.
- 04Switch between JSON Schema, Markdown, ANSI SQL and Postgres SQL, then copy or download.
What it does not do
- Types are inferred from the values present. A field that happens to hold only whole numbers is reported as an integer. Review before you rely on it.
- Dates are recognized in ISO 8601 form and as month/day/year. Other spellings are reported as text.
- SQL covers top-level fields. Nested objects and arrays become one JSONB column in Postgres and a CLOB in ANSI SQL.
- Files are read into memory, so the limit is 50 MB.
Questions
About the schema inferrer and data dictionary.
Is my data uploaded anywhere?
What types can it detect?
What does the mixed types flag mean?
Why does a data buyer want a data dictionary?
Is it really free?
More free tools
Personal data scrubber
Strip names, emails, phones, cards, keys and addresses from text and files.
Dataset profiler
Rows, columns, tokens, date span, duplicates and personal-data columns in one report.
Column hasher and remover
Drop sensitive columns or replace them with salted hashes that still join.
CSV, JSON and JSONL converter
Convert between CSV, TSV, JSON and JSONL without breaking quoted cells.
JSONL validator
Find the broken lines in a JSONL file and see which keys are missing.
Duplicate remover
Remove repeated rows, records or log lines, keeping the first of each.
Token counter
Size text the way AI labs do: tokens, words, characters and lines.
Data card generator
Write the one-page description every data buyer asks for.
Data rights pre-check
A tailored checklist of the contracts and questions to clear before a sale.
Slack export parser
Turn a Slack workspace export into clean thread JSONL with pseudonymized users.
Email thread parser
Convert .mbox and .eml files into threaded JSONL without quoted replies.
Ticket export parser
Map help desk exports to customer and agent turns in conversation JSONL.
Chat dataset format converter
Convert and validate OpenAI, ShareGPT, Alpaca and prompt/completion datasets.
Log parser
Turn web server, syslog, logfmt and JSON logs into structured JSONL or CSV.
HTML and document text extractor
Extract clean text from HTML, Markdown, XML and JSON files in batches.
Re-identification risk checker
Measure k-anonymity and l-diversity, then preview fixes that lower the risk.
Secrets scanner
Find API keys, tokens, passwords and private keys in a repo or export before you share it.
Delivery manifest builder
Create a SHA-256 checksum manifest for a dataset delivery, with one hash to compare.
Delivery verifier
Check received files against a manifest: match, changed, missing or extra.
File checksum calculator
SHA-256 of any file, with a compare box that turns green or red.
Train, validation and test splitter
Split a dataset into train, validation and test files without leaking related rows across splits.
Dataset sampler
Pull a random, stratified or first-N sample from a file, including files too large to open.
Text chunker
Split documents into overlapping chunks for retrieval or training, with heading context.
Dataset diff
Compare two versions of a dataset: added, removed and changed records, plus schema changes.
Encoding and mojibake fixer
Repair garbled characters, convert files to UTF-8 and strip invisible characters.
Column toolkit
Rename, split, merge, clean, filter and sort columns with a reusable pipeline of steps.
Cleaned it up? Sell it to Outrich.
Outrich Data buys company data directly. Check in five minutes whether yours qualifies, with no call.