Bin Column in JSON Files Online
Bucket a numeric column in JSON files into labelled ranges — equal-width bins or custom edges. Runs entirely in your browser.
About this tool
Convert a numeric column in a JSON file into labelled categorical ranges. Choose equal-width bins (specify how many) or define your own breakpoints. The tool adds a new column with the bin label for each row — ready for grouping, filtering, or charting. Everything runs locally in your browser.
Frequently Asked Questions
What is the difference between equal-width and custom bins?
Equal-width bins divide the full range of values into N intervals of identical size — for example, 0–20, 20–40, 40–60. Custom bins let you specify exact breakpoints that match your domain — for example, age groups 0–18, 18–35, 35–65, 65+.
What happens to null values in the column I am binning?
Null values are not matched by any CASE WHEN condition and result in a null in the bin column. You can fill nulls before binning using the Fill Empty Values tool if you need every row to have a bin label.
Can I bin a JSON file column with negative numbers?
Yes. Equal-width bins handle negative numbers correctly — the range spans from the minimum to the maximum value in the column regardless of sign. For custom edges, include negative values in your comma-separated edge list.
Is my data private?
Yes — completely. Your file is never uploaded to any server. Everything runs locally in your browser using WebAssembly — processing happens entirely inside your tab. Once you close the tab, nothing is retained.
What is the maximum file size?
The free limit is 50 MB. For larger files, performance depends on your device's available memory — most modern machines handle 500 MB to 1 GB comfortably.
Related Tools
Add Percent of Total to JSON Files Online
Add a percentage-of-total column to JSON files directly in your browser. Show each row's share of the grand total, or the share within each group — no upload required.
Parse URL Column in JSON Files Online
Parse URL columns in JSON files and extract host, path, query string, and fragment into separate columns — directly in your browser, no upload required.
Add Lag / Lead Column to JSON Files Online
Add a LAG or LEAD column to JSON files to shift any column forward or backward by N rows. See previous day's sales, next value in a sequence, or any time-shifted comparison — runs entirely in your browser.
Filter by Date Range JSON Files Online
Filter JSON files to rows within a date range using simple start and end date pickers. See a live match count before you apply the filter — no upload required, runs in your browser.
Compute Correlation Matrix for JSON Files Online
Compute a Pearson correlation matrix for numeric columns in JSON files directly in your browser. Instantly spot which variables move together — colour-coded heatmap, no upload required.