ToolDox
๐Ÿ“Š Data

Data Dictionary Generator

Upload a CSV and auto-generate a full data dictionary with types, nulls, unique counts, and sample values. Export as CSV or Markdown.

Drop your CSV or Excel file to generate a data dictionary
Types ยท nulls ยท uniques ยท min/max ยท samples โ€” all auto-detected ยท Never uploaded
[ Ad ยท 728ร—90 ]

Related Tools

CSV Cleaner
Upload a CSV and remove duplicates, blank rows, and whitespa...
JSON to CSV Converter
Paste JSON and instantly convert to CSV. Handles nested obje...
CSV to JSON Converter
Paste CSV data and instantly convert to a clean JSON array. ...
Remove Duplicate Lines
Paste any text and instantly remove duplicate lines. Case-se...

What is a data dictionary?

A data dictionary is a reference document that describes every column in a dataset โ€” its name, data type, what it means, example values, and quality metrics. It is the first document a new analyst should create when working with an unfamiliar dataset.

Why generate one automatically?

Writing a data dictionary manually for a 50-column dataset takes hours. This tool does it in seconds by scanning your CSV and extracting type, completeness, uniqueness, and sample values for every column automatically. You can then add your own descriptions before exporting.

What gets exported?

The CSV export contains one row per column: name, detected type, row count, null count, null percentage, unique count, unique percentage, min, max, and three sample values. The Markdown export formats everything as a table ready to paste into a README, Notion page, or Confluence doc.

Frequently asked questions

Can I edit the descriptions before exporting? Yes โ€” click the description field on any row to add your own notes before downloading.

Is my data uploaded anywhere? No. All processing happens in your browser. Your file never leaves your device.